Data Engineer L2

Capgemini
Lincolnshire, IL, United States
about 1 month ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$56,160.0 - $76,960.0
Working hours
Regular working hours
Job source

Tech stack

Data Analysis Information Engineering Data Infrastructure Data Integrity Extract Transform Load (ETL) Python (Programming Language) Performance Tuning Query Optimization Power BI DataOps SQL Databases System Availability
+7 more
Data Lakes Pyspark Deployment Automation Google Bigquery Data Lakehouse Data Pipelines Databricks

Job description

We are seeking a highly skilled Onshore Data Engineering Lead to drive the design, development, support, and continuous enhancement of enterprise-scale data platforms. This role is ideal for a hands-on technical leader with deep expertise in SQL, Databricks, PySpark, and Power BI, combined with strong stakeholder management and delivery leadership skills.

As a key member of the team, you will work closely with client stakeholders to understand business needs, translate requirements into scalable data solutions, and lead coordination with offshore development teams to ensure high-quality, timely delivery. You will play a critical role in improving data reliability, operational efficiency, and business value realization across the organization., * Design, develop, and maintain large-scale data pipelines and enterprise data solutions.

  • Build, optimize, and support data processing workflows using Databricks, PySpark, and SQL.
  • Develop and maintain Power BI dashboards, reports, and semantic data models to support business decision-making.
  • Lead production support activities, including incident management, troubleshooting, root cause analysis (RCA), and service improvements.
  • Collaborate with business and technical stakeholders to gather requirements and translate them into effective technical solutions.
  • Coordinate and guide offshore teams, ensuring delivery quality, adherence to timelines, and alignment with project objectives.
  • Identify and implement opportunities for process automation, performance tuning, and operational excellence.
  • Drive best practices in data engineering, governance, and platform reliability.

Requirements

  • Expert-level proficiency in SQL, including query optimization, performance tuning, and data modeling.
  • Strong hands-on experience with Databricks (GCP preferred; experience with non-Azure Databricks environments required).
  • Extensive experience developing solutions with PySpark.
  • Strong expertise in Power BI, including DAX, dashboard development, reporting, and data modeling.
  • Proven experience designing, building, and supporting enterprise-scale ETL/ELT pipelines and modern data platforms.
  • Strong background in production support, issue resolution, and root cause analysis.
  • Excellent communication, stakeholder engagement, and client-facing consulting skills.
  • Demonstrated ability to lead cross-functional and distributed teams., * Experience with Google BigQuery
  • Proficiency in Python
  • Knowledge of Delta Lake
  • Experience with Data Lakehouse architectures
  • Familiarity with CI/CD pipelines, DataOps practices, and automated deployment frameworks, * 8+ years of overall IT experience.
  • 5+ years of experience in Data Engineering, Analytics, or related disciplines.
  • Proven experience working within onsite-offshore delivery models.
  • Experience leading technical initiatives and collaborating directly with business stakeholders.

If you are looking to lead impactful data initiatives while working closely with both business stakeholders and global delivery teams, we’d love to hear from you.

Benefits & conditions

Pulled from the full job description Health insurance Retirement plan Dental insurance

About the company

The pay range that the employer in good faith reasonably expects to pay for this position is $27.00 - $37.00 USD/hour. Our offered benefits include medical, dental, vision, and retirement benefits. Applications will be accepted on an ongoing basis. Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and out clients’ success are built on a foundation of service excellence.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

4:32 min

Harnessing Spark with Python using PySpark and Py4J

Ayon Roy · LIVE

2:00 min

Separating dataset creation from low-level software implementation steps

Jan Zawadzki · World Congress 2022

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

3:37 min

Scaling machine learning pipelines from prototypes to petabytes

Julian Joseph · LIVE

3:48 min

Standardizing data access schemas with OData

Florian Bader Florian Bader · World Congress 2026 Europe

Videos

See all

Related articles

See all