Principal Data Engineer - Snowflake and DBT

Job description

FC Global Services India LLP (First Citizens India), a part of First Citizens BancShares, Inc., a top 20 U.S. financial institution, is a global capability center (GCC) based in Bengaluru. Our India-based teams benefit from the company’s over 125-year legacy of strength and stability. First Citizens India is responsible for delivering value and managing risks for our lines of business. We are particularly proud of our strong, relationship-driven culture and our long-term approach, which are deeply ingrained in our talented workforce. This is evident across all key areas of our operations, including Technology, Enterprise Operations, Finance, Cybersecurity, Risk Management, and Credit Administration. We are seeking talented individuals to join us in our mission of providing solutions fit for our clients’ greatest ambitions. Job Description: Value Proposition Responsible for developing and maintaining large scale data platforms: building data pipelines to share enterprise data, designing and building cloud solutions with appropriate data access, data security, data privacy and data governance Demonstrate deep technical knowledge and expertise in software development, data engineering frameworks and best practices. Use agile engineering practices and various data development technologies to rapidly develop creative and efficient data products Job Details Position Title: Principal Data Engineer Career Level: P4 Job Category: Assistant Vice President Role Type: Hybrid Job Location: Bangalore About the Team: The data engineering team is community of dedicated professionals committed to designing, building, and maintaining data platform solutions for the organization. Impact Enterprise data warehouse supports several critical business functions for the bank including Regulatory Reporting, Finance, Risk steering, and Customer 360. This role is vital for building and maintaining enterprise data platform, data processes, and to support business objectives. Our values — inclusivity, transparency, and excellence — drive everything we do. Join us and make a meaningful impact on the organization. Key Deliverables As a Principal Data Engineer, you will be responsible for building and maintaining large scale data platforms: enriching data pipelines to share enterprise data, designing, building, and maintaining a data platform such as Enterprise Data Warehouse, Operational Data Store or Data Marts etc. with appropriate data access, data security, data privacy and data governance. Demonstrate technical knowledge and leadership in software development, data engineering frameworks and best practices. Collaborate with the Data Architects, Solution Architects & Data Modelers to enhance the Data platform design, constantly identify a backlog of tech debts in line with identified upgrades and provide technical solutions & implement the same. Participates on the Change Advisory Board (CAB) and ensures effective change control is implemented for all infrastructure and/or application installations, rollbacks, and updates. Collaborate with IT and CSO teams to ensure compliance with data governance, privacy and security policies and regulations. Manage deliverables of developers, perform design reviews and coordinate release management activities. Drive automation, identify inefficiencies, optimize processes and data flows, and recommend improvements. Use agile engineering practices and various data development technologies to rapidly develop and implement efficient data products. Work with global technology teams across different time zones (primarily US) to deliver timely business value. Skills and Qualification Functional Skills: Business/Domain Knowledge: Good understanding of application systems and business domains Partnership and Collaboration: Develop and maintain partnership with business and IT stakeholders Communication: Excellent verbal, written, and interpersonal communication skills. Problem Solving: Excellent problem-solving skills, incident management, root cause analysis, and proactive solutions to improve quality. Team Player: Support peers, team, and department management. Attention to Detail: Ensure accuracy and thoroughness in all tasks. Technical/Business Skills: Data Engineering: 15+ years of experience in designing and building Data Warehouse and Data lakes. Extensive knowledge of data warehouse principles, design, and concepts. Strong knowledge of Snowflake data platform and solutions for enterprise level implementation, and migration from legacy or on-prem systems. Technical expertise of AWS cloud related services such as S3, Lamda, Glue, Step Function, CloudWatch, etc. Technical expertise working in large scale Data Warehousing applications and databases such as Oracle, Netezza, Teradata, and SQL Server. Deep technical knowledge in data engineering frameworks and best practices. Good to have machine learning capabilities such as Sagemaker, DataRobot. Data integration skills: Expertise in creating and maintaining ELT/ETL processes and architecting complex data pipelines - knowledge of data modeling techniques and high-volume ELT/ETL design. Technical expertise in ELT/ETL tools such as DBT, Qlik Replicate, Snowpark, etc. Expert in SQL Experience with Unix and Python scripting Experience in data pipeline orchestration using Airflow Good to have experience in any industry leading ETL tools such as SAP Business Objects Data Services (BODS), Informatica Cloud Data Integration Services (IICS), IBM Data Stage. Data Model: Expert knowledge of Logical and Physical Data Model using Relational, Dimensional or Data Vault Modeling practices with high-volume ETL/ELT design. Knowledge of Data Visualization using Power BI or Tableau Performance tuning of data pipelines and DB Objects to deliver optimal performance. Excellent data analysis skills using SQL and experience in incident management techniques. Data protection/compliance standards like GDPR, CCPA, HIPAA Experience working in Financial Industry is a plus Leadership Qualities Communication: Clearly conveys ideas and listens actively. Inspiration: Motivates and encourages the team to achieve their best. Influence: Extensive stakeholder management experience and ability to influence people Driving strategic and technical initiatives Relationships & Collaboration Reports to: Associate Director - Data Engineering Partners: Senior leaders and cross-functional teams Leads: A team of Data Engineering associates Accessibility Needs We are committed to providing an inclusive and accessible hiring process. If you require accommodations at any stage (e.g. application, interviews, onboarding) please let us know, and we will work with you to ensure a seamless experience. Equal Employment Opportunity FC Global Services India LLP (First Citizens India) is an Equal Employment Opportunity Employer. We are committed to fostering an inclusive and accessible environment and prohibit all forms of discrimination on the basis of gender, religion, caste, disability, sexual orientation, economic status or any other characteristics protected by the law. We strive to foster a safe and respectful environment in which all individuals are treated with respect and dignity. Our EEO policy ensures fairness throughout the employee life cycle.