Lead Data Engineer (AWS, Data Pipelines)

Why Principal?

At Principal, we believe in encouraging a collaborative and welcoming environment where everyone's input is appreciated. We are committed to your professional development and assist our team members in reaching their personal and career ambitions. Join us and become part of a world-class team that is making an impact!

Are you ready to lead a dynamic team and drive impactful data engineering solutions? At Principal, we offer an outstanding opportunity for an ambitious Lead Data Engineer to join our Enterprise Architecture engineering team. Here, you will work on groundbreaking projects, using automation, CI/CD, and Agile delivery approaches to deliver detailed results.

As a Lead Data Engineer (AWS, Data pipelines, Python or Typescript), your responsibilities will include:

• Support data management, LeanIX platform configurations and integrations, and application development.
• Build, develop, and maintain data pipelines through AWS cloud offerings alongside Snowflake.
• Maintain data using Snowflake data products.
• Coordinate and refine database updates using SQL, Snowflake technologies, and version control techniques.
• Apply AWS services including Lambda, S3, SNS, SQS, IAM, EventBridge, DynamoDB, KMS, and CloudWatch.
• Quickly grasp and adjust to new AWS services and developing cloud technologies.
• Create complex SQL queries and lead Power BI reports, dashboards, and visualizations.
• Develop programming solutions using Python and/or TypeScript.
• Perform automated testing, pipeline automation, and apply CI/CD tools.
• Work within Agile methodologies to ensure efficient project delivery.
• Exhibit leadership capabilities, leading the work for a small team.
• Mentor team members, providing technical guidance and support.
• Evaluate build options, making sound technical decisions and trade-offs.
• Collaborate effectively with collaborators and Enterprise Architects.
• Potentially handle LeanIX platform administration, maintenance, and integrations.

To be successful in this role, you should have:

Must Have / Primary Skills

AWS & Data Engineering

• Strong hands-on experience in building and supporting data pipelines. 

• Strong practical experience with AWS services, particularly services used for data engineering. 

• Experience with data integration and database changes. 

Programming & SQL

• Strong programming skills in Python and/or TypeScript. 

• Strong SQL skills, including advanced query development. 

Testing, CI/CD & Agile

• Experience with automated testing. 

• Experience with Continuous Integration and Continuous Delivery (CI/CD) tools and practices. 

• Experience working in an Agile environment. 

Leadership & Collaboration

• Ability to lead, mentor, and develop team members. 

• Strong communication and collaboration skills. 

• Ability to work effectively with technical and business stakeholders. 

Good to Have

Snowflake

• Working knowledge or practical experience with Snowflake. 

• Experience working with Snowflake databases and database/schema changes would be an advantage. 

Power BI

• Experience with Power BI. 

• Experience building and supporting reports and dashboards would be an advantage. 

Key Primary Skills:

CI/CD, Automated Testing, and Agile. 

• 7-9 years of relevant experience.

• Bachelor’s degree or Master’s degree or equivalent experience in Computer Science, Technology, Engineering, Mathematics, or a related field (B.E. / B.Tech / M.S. / M.Tech / MCA).