> Markdown version of [/jobs/ext/2627642-data-engineer-l2](https://www.wearedevelopers.com/jobs/ext/2627642-data-engineer-l2). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer L2 - **Company:** Capgemini - **Location:** Lincolnshire, IL, United States - **Experience:** Expert - **Salary:** $56,160.0 - $76,960.0 - **Contract:** Temporary contract - **Skills:** 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, Data Lakes, Pyspark, Deployment Automation, Google Bigquery, Data Lakehouse, Data Pipelines, Databricks - **Published:** August 3, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=29005ad10a028330 ## About the Role * 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. ## 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. ## Related Videos - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)