Senior Data Engineer / Analytics Engineer

Job Location - Chicago IL (Day One Onsite - Hybrid) About The Role The goal of analytics engineering team within the Service Analytics and AI organization is to build curated data products leveraging data from structured and unstructured enterprise data sources to enable business intelligence, data science, and advanced analytics. Seeking a highly skilled and motivated data engineer to join 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 innovative AI-driven solutions that fuel business growth and enhance customer experience. Key Responsibilities Data Pipeline Development: Lead the design, development, and deployment of scalable and robust data pipelines, ensuring seamless data integration and processing across diverse systems. Analytics Engineering Best Practices: Establish and uphold best practices for data engineering, including coding standards, data governance, performance optimization, and automation strategies. Code Quality and Review: Participate in code reviews, provide constructive feedback, and contribute to the team's continuous improvement in coding practices and methodologies. ETL/ELT Development: Design, build, and maintain robust ETL/ELT pipelines, reusable frameworks, and libraries to process and transform data from diverse sources, ensuring accuracy, quality, and consistency. System Monitoring: Proactively monitor and troubleshoot data pipelines, ensuring high availability, reliability, and performance across all data engineering workflows. Automation and CI/CD: Implement CI/CD pipelines to streamline the deployment, testing, and maintenance of analytics engineering processes. Cross-functional Collaboration: Partner with data scientists, engineers, analysts, product managers, and business stakeholders to understand requirements, translate them into actionable technical specifications, and deliver impactful data solutions. Stakeholder Communication: Articulate complex technical concepts to non-technical stakeholders, fostering alignment and ensuring a shared understanding of data initiatives across teams. Required Skills Hands-on experience with SQL, Python, dbt, and Snowflake. Experience in version control systems such as Git, and workflow management tools such as Airflow Proven experience in 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 integration of data from multiple sources into a data warehouse. Experience with CI/CD workflows and tools for data engineering. Strong problem-solving and analytical skills, with the ability to work effectively in a collaborative environment. Life At Capgemini Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer: Flexible work Healthcare including dental, vision, mental health, and well-being programs Financial well-being programs such as 401(k) and Employee Share Ownership Plan Paid time off and paid holidays Paid parental leave Family building benefits like adoption assistance, surrogacy, and cryopreservation Social well-being benefits like subsidized back-up child/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 environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.Click the following link for more information on your rights as an Applicant 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 not limited to, geographic location, relevant education, qualifications, certifications, experience, skills, seniority, performance, sales or revenue-based metrics, and business or organizational needs. At Capgemini, it is not typical for an individual to be hired at or near the top of the range for their role. The base salary range for the tagged location is $110841 to $145000 /yearly. This role may be eligible for other compensation including variable compensation, bonus, or commission. Full time regular employees are eligible for paid time off, medical/dental/vision insurance, 401(k), and any other benefits to eligible employees.Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law.For this role, the gross annual base salary range is $110841 to $145000 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 your current or past salary during our recruitment process.