Lead Data Engineer – Data Modeler

EXL

Lead Data Modeling Engineer with expertise in data pipeline orchestration at LendingClub. Designing scalable data models and maintaining high-quality data products in the financial sector.

Posted 5/21/2026full-timePune • 🇮🇳 IndiaSeniorWebsite

Tech Stack

Tools & technologies

AirflowAmazon RedshiftAWSCloudDistributed SystemsEC2JavaJenkinsPythonScalaSpark

About the role

Key responsibilities & impact

Design, develop, and maintain scalable, high-quality data models in a centralized data warehouse (primary focus)
Translate business requirements into well-structured, reusable data models that support analytics and downstream applications
Define and enforce data modeling standards, naming conventions, and best practices across domains
Lead and contribute to data standardization initiatives to ensure consistency and interoperability of data assets
Build and maintain data pipelines that support and operationalize data models (ingestion, transformation, and delivery)
Develop pipelines that transform raw data into clean, well-modeled, analytics-ready datasets
Collaborate with Product, Engineering, and Program teams to deliver end-to-end data solutions (models + pipelines)
Optimize data models and pipelines for performance, scalability, and cost efficiency
Implement processes for data validation, quality monitoring, and reliability
Write high-quality, testable code; adopt TDD and contribute to engineering documentation and best practices
Perform root cause analysis on data and pipeline issues to improve system robustness

Requirements

What you’ll need

10+ years of experience and a bachelor’s degree in Computer Science, Information Systems, or related field; or equivalent experience
Strong expertise in data modeling (dimensional modeling, warehouse design, normalization techniques)
Proven experience designing and implementing data models in centralized/cloud data warehouses (Databricks, Snowflake, Redshift, etc.)
Solid experience in data engineering and pipeline development to support modeled data layers
5+ years of experience with Databricks and DBT
Experience with orchestration tools such as Airflow or Dagster
In-depth experience with distributed systems such as Spark
Strong programming skills (Java, Scala, Python) with experience building production-grade data pipelines
Experience with AWS cloud services (EC2, EMR, RDS)
Strong understanding of data standardization, data governance, and data quality best practices
Experience with Git, JIRA, Jenkins, and CI/CD pipelines
Experience working with cross-functional teams in a dynamic environment

Benefits

Comp & perks

Health insurance
Retirement plans
Paid time off
Flexible work arrangements
Professional development

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data modelingdimensional modelingwarehouse designnormalization techniquesdata engineeringpipeline developmentprogramming (Java)programming (Scala)programming (Python)data validation

Soft Skills

collaborationleadershipproblem-solvingcommunicationorganizational skillsattention to detailadaptabilityanalytical thinkingroot cause analysisprocess improvement