Data Engineer L2

Capgemini; Lincolnshire (IL); On-site; USD 77,366,000 - 106,020,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

Retirement benefits

Job summary

Tundra Technical Solutions is seeking an Onshore Data Engineering Lead in Lincolnshire, IL to design, build, and support enterprise data platforms. You will lead data pipelines with SQL, Databricks, PySpark, and Power BI, coordinating with offshore teams to ensure high-quality, timely delivery.

This contract role focuses on operational reliability, performance tuning, and governance, with close collaboration with client stakeholders to translate business needs into scalable data solutions.

Qualifications

• Expert-level proficiency in SQL, including query optimization and data modeling.
• Strong hands-on Databricks experience (GCP preferred; non-Azure environments acceptable).
• Extensive PySpark development experience.
• Strong Power BI expertise, including DAX and data modeling.
• Experience designing enterprise-scale ETL/ELT pipelines.
• Strong production support, RCA, and incident handling.
• Excellent communication and stakeholder engagement.
• Ability to lead cross-functional, distributed teams.

Responsibilities

• Design, develop, and maintain large-scale data pipelines and enterprise data solutions.
• Build, optimize, and support data workflows with Databricks, PySpark, and SQL.
• Develop Power BI dashboards, reports, and semantic data models.
• Lead production support, incident management, and RCA processes.
• Collaborate with stakeholders to translate requirements into technical solutions.
• Coordinate offshore teams to ensure on-time delivery and quality.
• Identify opportunities for automation and performance optimization.
• Promote data engineering best practices and platform reliability.

Skills

SQL

Databricks

PySpark

Power BI

ETL/ELT

Production support

Stakeholder management

Team leadership

Job description

Lincolnshire, IL, United States (On-site)

Contract (4 months 15 days)

Published 18 days ago

pyspark

SQL

GCP

databricks

PowerBI

Role Overview

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.

Key Responsibilities

• 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.

Required Qualifications

• 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.

Preferred Qualifications

• 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

Experience

• 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.

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.

We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected cahracteristic. Qualified applicants with arrest or conviction recors will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fait Chance Act. Unincorporated LA County workers; we reasonably believe that criminal history may have a direct, adverse, and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided propert, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public informaiton. In addition, job duties require acces to secure and protected client information technology systems and related data security obligations.