Senior Data Engineer / Analytics Engineer based in Chicago, IL with a hybrid work arrangement, responsible for designing, building, and maintaining scalable data pipelines and analytics solutions, including a semantic data layer and AI driven data products to enable business intelligence, data science, and advanced analytics.
Responsibilities
- Lead the end-to-end design, development, and deployment of scalable data pipelines to enable seamless data integration and processing across heterogeneous systems.
- Define and uphold analytics engineering standards, covering coding practices, data governance, performance optimization, and automation strategies.
- Contribute to code quality through participation in reviews, providing constructive feedback, and advancing engineering practices.
- Develop and maintain robust ETL and ELT pipelines, along with reusable frameworks, to process data from multiple sources and ensure accuracy and consistency.
- Monitor, troubleshoot, and optimize data pipelines to maintain high availability and performance across data workflows.
- Establish CI/CD processes to automate deployment, testing, and maintenance of analytics workflows.
- Collaborate with data scientists, engineers, analysts, product managers, and business stakeholders to translate requirements into technical specifications and deliver data solutions.
- Explain complex technical concepts to non-technical stakeholders to foster alignment on data initiatives across teams.
Requirements
- Hands-on experience with SQL, Python, dbt, and Snowflake.
- Proficiency with version control systems such as Git and workflow orchestration tools such as Airflow.
- Proven track record designing and building scalable data pipelines and architectures.
- Strong understanding of data governance, quality assurance, and performance optimization in a data engineering context.
- Expertise in ETL/ELT processes, data modeling, and integrating data from multiple sources into a data warehouse.
- Experience implementing CI/CD workflows and tools for data engineering.
- Strong problem-solving and analytical skills, with a collaborative mindset.
Technologies
- SQL
- Python
- dbt
- Snowflake
- Git
- Airflow
Benefits
- Flexible work arrangements
- Healthcare coverage including dental, vision, mental health, and well-being programs
- Financial well-being programs such as 401(k) and Employee Stock Ownership Plan
- Paid time off and paid holidays
- Paid parental leave
- Family building benefits including adoption assistance, surrogacy, and cryopreservation
- Social well-being benefits such as subsidized back-up child and elder care and tutoring
- Mentoring, coaching, and learning programs
- Employee Resource Groups
- Disaster relief
About the Role
The analytics engineering team within the Service Analytics and AI organization focuses on creating curated data products by leveraging data from both structured and unstructured enterprise sources to support business intelligence, data science, and advanced analytics.
We are seeking a highly capable data engineer to join the Analytics Engineering team within the Service Analytics and AI organization.
This role is pivotal in designing, building, and maintaining scalable data pipelines and analytics solutions that empower Advanced Analytics, Business Intelligence, and Data Science initiatives.
You will play a crucial role in building a semantic data layer, defining and implementing cutting edge data products, and delivering AI driven solutions that fuel business growth and enhance customer experience.
Life at Capgemini
- Flexible work arrangements
- Healthcare coverage including dental, vision, mental health, and well-being programs
- Financial well-being programs such as 401(k) and Employee Stock Ownership Plan
- Paid time off and paid holidays
- Paid parental leave
- Family building benefits including adoption assistance, surrogacy, and cryopreservation
- Social well-being benefits such as subsidized back-up child and elder care and tutoring
- Mentoring, coaching, and learning programs
- Employee Resource Groups
- Disaster relief
Disclaimer
Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law. This is a general description of the duties, responsibilities and qualifications required for this position. Physical, mental, sensory or environme
Salary Transparency
Capgemini discloses salary range information in compliance with state and local pay transparency obligations. The disclosed range represents the lowest to highest salary we, in good faith, believe we would pay for this role at the time of this posting, although we may ultimately pay more or less than the disclosed range, and the range may be modified in the future. The disclosed range takes into account the wide range of factors that are considered in making compensation decisions including, but
Salary Transparency
For this role, the gross annual base salary range is $110,841 to $145,000 for a full-time position. This range covers base pay only; we will discuss any bonuses, incentives, and benefits during the hiring process. Your exact offer will depend on objective, job-related factors – like your experience, skills, and qualifications – in line with our fair pay principles. If a collective labour agreement applies to this role, we will share the relevant pay scale details with you. Note: We never ask about
