EXL Logo

EXL

Lead Data Engineer

Reposted 24 Days Ago
Remote or Hybrid
Hiring Remotely in United States
94K-154K Annually
Senior level
Remote or Hybrid
Hiring Remotely in United States
94K-154K Annually
Senior level
Lead Data Engineer builds and maintains scalable data pipelines and lakehouse/warehouse platforms (Databricks) to support analytics, BI, reporting, and AI. Responsibilities include data modeling, ETL/ELT, medallion architecture, orchestration and monitoring (Airflow/Cron), performance tuning, CDC/incremental loads, data quality, and leading/mentoring a team while collaborating with stakeholders and maintaining documentation.
The summary above was generated by AI

We are looking for a Lead Data Engineer to build and maintain scalable data pipelines and data platforms that support analytics, business Intelligence, reporting, and AI. In this hands-on role, you will work closely with data architects, business stakeholders and analysts to develop reliable data solutions and ensure high-quality data is available across the organization. For more information on benefits and what we offer please visit us at https://www.exlservice.com/us-careers-and-benefits
 

Salary Range: $93,900 - $154,200 Base annually

The posted range is the hiring range for this role — a subset of the broader range available to employees over time — and reflects base salary across our national hiring scale. Final offers are based on several factors, including the candidate's skills and experience, internal pay equity, work location, market conditions for the role, and the specific scope and responsibilities of the position. The top of the range is reserved for candidates who notably exceed the requirements; the lower end applies to those with less experience or fewer preferred qualifications. For positions based in higher-cost zones (e.g., California, New York, New Jersey), actual compensation may exceed the posted range; your recruiter will share specifics during the process.

Responsibilities

Lead Data Engineering (Los Angeles)

Job Functions:

  • Collaborate with client stakeholders to gather requirements, structure solutions, and ensure high‑quality, timely delivery.
  • Experience working in the Databricks tech stack with strong proficiency in SQL, Python, and PySpark
  • Design and optimize data models, data marts, and Lakehouse/warehouse layers with strong focus on medallion architecture, query optimization, and performance engineering.
  • Build, orchestrate, and monitor scalable data pipelines on Databricks, ensuring reliable ingestion, transformation, CDC handling, and incremental load strategies.
  • Manage end‑to‑end pipeline operations including performance tuning, data quality monitoring, alerting, and issue resolution across production workloads.
  • Lead a project team of data engineers supporting multiple workstreams and provide technical leadership through code reviews, best‑practice guidance, reusable pattern creation, and mentorship to engineering team members.
  • Prepare and maintain project documentation to support project execution and delivery.

Expected work split

  • 50% Technical – Data modeling, hands-on coding, orchestration, and pipeline monitoring.
  • 50% Management– Client Collaboration, requirements gathering, designing technical solutions, presentations, global team management and mentoring.

Qualifications (Required):

  • 6-8 years’ experience in data engineering and analytics roles
  • Bachelor’s or Master's degree in analytics, computer science/engineering, economics, mathematics,  or related areas.
  • Experience building and maintaining ETL/ELT pipelines
  • Solid understanding of data warehousing concepts and dimensional data modeling
  • Familiarity with workflow orchestration tools such as Airflow or similar
  • Experience working with cloud data platforms or modern data infrastructure
  • Entrepreneurial hands-on approach to work. Demonstrated leadership ability and willingness to take initiative
  • Superior analytical and problem solving skills
  • Outstanding written and verbal communication skills
  • Effective time management and attention to detail
  • Hands on experience in using SQL, Python and Workflow Schedulers (Apache Airflow, Cron)
  • Experience in leading team and coordinating with internal / external stakeholders
  • Experience in using Cloud Platforms (AWS / GCP / Azure)
  • Experience in using Visualization tools (Tableau / Power BI)
  • Experience with Big Data Technologies (Hadoop, Hive, Hbase, Pig, Spark, etc.)
Qualifications
  • Collaborate with client stakeholders to gather requirements, structure solutions, and ensure high‑quality, timely delivery.
  • Experience working in the Databricks tech stack with strong proficiency in SQL, Python, and PySpark
  • Design and optimize data models, data marts, and Lakehouse/warehouse layers with strong focus on medallion architecture, query optimization, and performance engineering.
  • Build, orchestrate, and monitor scalable data pipelines on Databricks, ensuring reliable ingestion, transformation, CDC handling, and incremental load strategies.
  • Manage end‑to‑end pipeline operations including performance tuning, data quality monitoring, alerting, and issue resolution across production workloads.
  • Lead a project team of data engineers supporting multiple workstreams and provide technical leadership through code reviews, best‑practice guidance, reusable pattern creation, and mentorship to engineering team members.
  • Prepare and maintain project documentation to support project execution and delivery.

Work Split

  • 50% Technical – Data modeling, hands-on coding, orchestration, and pipeline monitoring.
  • 50% Management– Client Collaboration, requirements gathering, designing technical solutions, presentations, global team management and mentoring.

Similar Jobs

Yesterday
Remote
United States
135K-155K Annually
Senior level
135K-155K Annually
Senior level
Logistics • Transportation • 3PL: Third Party Logistics
Lead a team of data engineers to design, build, and maintain scalable data pipelines, a Data Vault, data warehouses and marts. Own backlog, sprint planning, mentoring, stakeholder collaboration, data validation/monitoring, and platform improvements to deliver key metrics and data infrastructure across the business.
Top Skills: Amazon RdsAuroraAWSAzureAzure Data FactoryCi/CdCoalesce.IoCsvData Vault 2.0DevOpsFivetranGitGCPJSONMicrosoft Sql ServerMySQLNumpyPandasPythonRequestsRest ApiSnowflakeSQLStreamlitTmsWmsYaml
Yesterday
Remote or Hybrid
Texas, USA
Senior level
Senior level
Insurance • Cybersecurity
Design and build a single data platform and pipelines, ensure infrastructure and standards, provide governance and consultancy, and work with stakeholders to expand data capabilities across the insurance business.
Top Skills: AWSAzureGCPPythonSparkSQL
4 Days Ago
In-Office or Remote
125K-160K Annually
Senior level
125K-160K Annually
Senior level
Database • Analytics
Lead design and implementation of scalable GCP-based data pipelines and semantic layers for enterprise healthcare analytics. Drive ingestion automation, BigQuery optimization, ETL/ELT orchestration, observability, data quality, and metadata management. Provide technical leadership, mentor engineers, and collaborate with architects and stakeholders to deliver production-ready cloud data solutions.
Top Skills: BigQueryCi/CdCloud ComposerCloud StorageDataflowDbtEltETLGoogle Cloud Platform (Gcp)LookerPythonSQL

What you need to know about the Boston Tech Scene

Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.

Key Facts About Boston Tech

  • Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
  • Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
  • Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
  • Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account