Lead Data Engineer
Chennai, IndiaFull-timeSenior · 6-10 years
About this role
Role Summary
We are looking for a hands-on Data Analyst Lead to drive ETL and data migration projects end-to-end.
This role is execution-focused, responsible for:
- Handling complex data migration tasks
- Leading small teams of data analysts
- Ensuring timely and accurate delivery
The candidate should be comfortable working in a fast-paced, client-facing implementation environment.
Key Responsibilities
1. ETL & Data Migration Execution (Core Responsibility)
- Perform end-to-end data migration (Extract, Transform, Load)
- Work on:
- Data extraction from source systems
- Data transformation and mapping
- Data loading into target systems
- Handle large datasets with accuracy and performance in mind
2. Data Mapping & Transformation
- Create and manage:
- Data mapping documents
- Transformation logic
- Perform:
- Data cleansing
- Deduplication
- Data normalization
3. Data Validation & Reconciliation
- Validate migrated data against source systems
- Prepare reconciliation reports
- Identify and fix:
- Data mismatches
- Missing or inconsistent data
4. Team Handling (Light Leadership)
- Guide and support junior data analysts
- Review their work (mapping, validation, outputs)
- Ensure quality and consistency in delivery
5. Client Interaction
- Work directly with clients to:
- Understand data requirements
- Clarify mapping and transformation rules
- Participate in:
- Data workshops
- Requirement discussions
6. Delivery Ownership
- Manage timelines for assigned projects
- Handle multiple migration tasks simultaneously
- Take ownership of delivery under tight deadlines
Required Skills & Qualifications
Must Have
- Strong experience in ETL and data migration projects
- Advanced SQL skills
- Strong Excel skills (data comparison, VLOOKUP, Pivot tables, etc.)
- Experience handling large datasets
- Experience in data validation and reconciliation
Good to Have
- Experience with Python (for automation)
- Exposure to ETL tools (Informatica, Talend, etc.)
- Experience in SaaS product migrations (CRM, PSA, ERP)
- Basic understanding of APIs / integrations
Behavioural Competencies
- Strong execution mindset
- Ability to work under pressure
- Attention to detail and data accuracy
- Ownership-driven approach
- Excellent communication with clients and internal teams
- Passion for learning and improvement
- Comfortable working in 3 PM – 1 AM shift