Lead Data Engineer

Lead Data Engineer

Experience: 10+ years

Location: Hyderabad

Type: Hybrid (Contractual)

Contract Duration: 6+ months

Job Summary:

We are seeking an experienced and results-oriented Lead Data Engineer to drive the design, development, and optimization of enterprise data solutions. This on-site role requires in-depth expertise in FiveTran, Snowflake, SQL, Python, and data modeling, as well as a demonstrated ability to lead teams and mentor both Data Engineers and BI Engineers. The role will play a critical part in shaping the data architecture, improving analytics readiness, and enabling self-service business intelligence through scalable star schema designs.

Key Responsibilities:

* Lead end-to-end data engineering efforts, including architecture, ingestion, transformation, and delivery.

* Architect and implement FiveTran-based ingestion pipelines and Snowflake data models.

* Create optimized Star Schemas to support analytics, self-service BI, and KPI reporting.

* Analyze and interpret existing report documentation and KPIs to guide modeling and transformation strategies.

* Design and implement efficient, scalable data workflows using SQL and Python.

* Review and extend existing reusable data engineering templates and frameworks.

* Provide technical leadership and mentorship to Data Engineers and BI Engineers, ensuring best practices in coding, modeling, performance tuning, and documentation.

* Collaborate with business stakeholders to gather requirements and translate them into scalable data solutions.

* Work closely with BI teams to enable robust reporting and dashboarding capabilities.

Required Skills:

* 7+ years of hands-on data engineering experience, with 2+ years in a technical leadership or lead role.

* Deep expertise in FiveTran, Snowflake, and SQL development.

* Proficiency in Python for data transformation and orchestration.

* Strong understanding of data warehousing principles, including star schema design and dimensional modeling.

* Experience in analyzing business KPIs and reports to influence data model design.

* Demonstrated ability to mentor both Data Engineers and BI Engineers and provide architectural guidance.

* Excellent problem-solving, communication, and stakeholder management skills.

Job Type: Contractual / Temporary
Contract length: 6 - 12 months

Pay: ₹90,000.00 - ₹120,000.00 per month

Schedule:

• Day shift

Experience:

• Python: 8 years (Required)
• snowflake: 8 years (Required)
• ETL: 8 years (Required)

Work Location: In person