Technical Lead Data Engineer

Project Role: Technical Lead Data Engineer

Work Experience: 8-13 Years

Work location: Bengaluru

Work Mode: Hybrid

Must Have Skills: Data engineering, Data pipelines, ETL/ELT frameworks, and DWH with data modeling, Python

Job Overview:

We are seeking a highly skilled and motivated Tech Lead to lead the design, development, and delivery of data-driven solutions aligned with organizational goals. This hybrid role combines technical leadership and people management, requiring expertise in Database technologies, Datawarehouse with Data model, Python, and AI/ML concepts.

The role involves managing end-to-end project delivery and ensuring alignment with business strategy while fostering innovation in data and AI initiatives.

Job Responsibility:

Lead and deliver multiple concurrent data and AI-driven projects within scope, schedule, and budget.

Own the full project lifecycle: initiation, planning, execution, monitoring, and closure.

Serve as the single point of contact for assigned projects, ensuring clear communication with stakeholders.

Drive Agile methodologies to enhance delivery efficiency and adaptability.

Manage and mitigate risks, dependencies, and issues, ensuring timely resolution.

Provide hands-on technical leadership and people management

Guide architecture decisions and ensure alignment with enterprise data strategy.

Drive adoption of AI/ML solutions to support business goals (predictive analytics, automation, analytics use cases).

Ensure best practices in code quality, data governance, performance tuning, and security.

Identify opportunities to leverage AI/ML technologies to improve business processes and decision-making.

Lead, mentor, and manage a team of data engineers, developers, and analysts.

Perform performance management, coaching, and career development of team members.

Allocate resources effectively across projects in a matrix environment.

Foster a culture of collaboration, innovation, and accountability.

Technical/Required Skills:

8+ years of Strong expertise in:

Database technologies (Snowflake preferred); Database design, development, and optimization

Python programming

Data engineering, Data pipelines, ETL/ELT frameworks, and DWH with data modeling

Python-based data engineering and automation solutions

Experience in ETL development using PowerCenter, Data Stage, AWS preferred or any other ETL tool

Strong capabilities in SQL development on any of the large-scale data platforms: Snowflake, Databricks, Redshift, SQL Server, etc.

Understanding of SQL table structure and DDL – primary & foreign keys, required columns, naming and data typing standards - and why they are important.

General understanding of Data Warehousing technology, ETL processes – facts, dimensions, star and snowflake schemas, data warehouse schema layers, SCD

Exposure to AI/ML concepts and implementations in business contexts.

Good to have Skills/Experience:

• Healthcare/Pharma experience

Educational Qualification:

• BTech/BCA/BSc/MTech/MCA/MSc