Lead Data Engineer

Job Summary

We are seeking an experienced and results-oriented Lead Data Engineer to drive the design, development, and optimization of enterprise data solutions. In this on-site role, you will play a critical part in shaping the data architecture, improving analytics readiness, and enabling self-service business intelligence through scalable star schema designs. You will be responsible for architecting FiveTran-based ingestion pipelines, implementing Snowflake data models, and designing efficient data workflows using SQL and Python. As a leader, you will also mentor both Data Engineers and BI Engineers while collaborating with business stakeholders to transform requirements into scalable data solutions.

Responsibilities

• Lead End-to-End Data Engineering Efforts: Architect, design, and manage the complete data lifecycle including ingestion, transformation, and delivery.
• Develop and Optimize Data Pipelines: Architect and implement data ingestion pipelines using FiveTran and develop Snowflake data models.
• Design Scalable Data Models: Create and optimize star schemas and dimensional models that support analytics, self-service BI, and KPI reporting.
• Analyze and Interpret Business Data: Review existing report documentation and KPIs to guide data modeling and transformation strategies.
• Implement Efficient Data Workflows: Utilize SQL and Python to design, develop, and optimize scalable data workflows.
• Provide Technical Leadership: Mentor Data Engineers and BI Engineers, ensuring adherence to best practices in coding, performance tuning, and documentation.
• Collaborate with Stakeholders: Work with business teams and BI specialists to gather requirements and translate them into robust data solutions.

Qualifications

• Experience: Overall 10+ years in data engineering with 7+ years of hands-on experience and a minimum of 2+ years in a technical leadership role.
• Technical Expertise:
  • Deep expertise in FiveTran-based data ingestion.
  • Proficiency in Snowflake data modeling and development.
  • Advanced skills in SQL development.
  • Strong proficiency in Python for data transformation and orchestration.
• Data Modeling: Extensive knowledge in designing star schemas and dimensional models.
• Analytical Skills: Ability to analyze business KPIs and existing reports to influence data model design.
• Leadership: Demonstrated experience in mentoring and guiding Data Engineers and BI Engineers.
• Communication: Excellent problem-solving, stakeholder management, and communication skills.
• Education: Relevant Bachelor’s or Master’s degree in Computer Science, Engineering, or a related discipline.

Preferred Skills

• Familiarity with scalable enterprise data architectures.
• Experience with self-service business intelligence tools.
• Additional expertise in performance tuning and optimization of data workflows.
• Ability to work in dynamic, fast-paced environments while managing multiple priorities.

Experience

• A minimum of 10+ years overall experience in data engineering.
• At least 7+ years of hands-on experience in data engineering roles, including 2+ years in a leadership or technical lead position.

Environment

• Location: On-site roles in Hyderabad and Bangalore.
• You will be working in a dynamic, collaborative office environment where interaction with cross-functional teams is essential.
• The role involves close collaboration with business stakeholders and BI teams to ensure alignment between data solutions and business needs.