Data Engineer L2 (contract)
Capgemini · Lincolnshire, IL · 2 mo ago
Information Technology$27–$37/hrContract
We are seeking a hands-on technical leader with deep expertise in SQL, Databricks, PySpark, and Power BI to drive the design, development, support, and continuous enhancement of enterprise-scale data platforms. This role involves close collaboration with client stakeholders to understand business needs, translate requirements into scalable data solutions, and lead coordination with offshore development teams.
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.
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.
- 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.
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.
Pay
$27.00 - $37.00 USD/hour.
Benefits
- Medical, dental, and vision benefits.
- Retirement benefits.