Lead Data Engineer
Summary
Lead a critical data engineering project building scalable ETL/ELT pipelines with Azure Data Factory and Azure data services, plus advanced T-SQL/SQL Server development, DBA work, performance tuning and data modelling. 7+ years experience; Kochi/Trivandrum or remote with mandatory 1 week onsite in Kerala.
🚀 Hiring: Lead Data Engineer | 7+ Years
We are looking for an experienced Lead Data Engineer to join our team and work on a critical data engineering project.
Location: Kochi / Trivandrum / Remote*
Experience: 7+ Years
⏳ Notice Period: Immediate to 15 Days ONLY
Open Positions: 1
Mandatory Skills
- Strong hands-on experience with Microsoft SQL Server
- Advanced T-SQL development
- SQL Server DBA activities
- Query optimization, indexing & performance tuning
- Data modelling – logical, physical and dimensional modelling
- Strong experience with Azure Data Factory (ADF)
- Experience with Azure Data Platform services
- Strong understanding of ETL/ELT and data integration
Key Responsibilities
- Design, develop and maintain scalable ETL/ELT pipelines using ADF and Azure services
- Develop complex and optimized T-SQL queries, stored procedures, views, functions and database objects
- Perform SQL Server development, administration, troubleshooting and performance tuning
- Build data integration pipelines connecting multiple source and target systems
- Work with large volumes of structured and semi-structured data
- Troubleshoot data pipeline failures, data quality issues and production incidents
- Apply data modelling techniques for analytical and operational requirements
- Participate in code reviews, Agile ceremonies and production deployments
- Work closely with developers, architects, QA and business stakeholders
Experience with Agile/Scrum, technical documentation, distributed teams and CI/CD/source-control tools such as Azure DevOps, Git or Bitbucket is what we look for.
⭐ Good to Have
- Experience with telemetry / time-series data
- Azure DevOps / Git / Bitbucket
- Experience working with changing source data structures
⚠️ Important: Candidates must be available to join immediately to 15 days.
For remote candidates, 1 week of onsite presence at the Kerala office is mandatory.