About Capgemini

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, supported by a collaborative global team, and inspired to reimagine what's possible. Join us and help leading organizations unlock the value of technology and build a more sustainable, inclusive future.

Note:

No sponsorship available. Candidates must be authorized to work in the U.S. on a permanent basis without the need for current or future visa sponsorship.

Role Overview

Capgemini is seeking a strong Data Analyst to support a large-scale Financial Services initiative. This role will focus on enterprise data solutions, ETL/ELT development, data analysis, data quality, and data warehouse support within an AWS cloud environment.

The ideal candidate will have hands-on experience with SQL, PostgreSQL, AWS Aurora PostgreSQL, ETL/ELT development, data modeling, Oracle, and enterprise data warehouse environments.

Key Responsibilities

  • Develop and maintain ETL/ELT pipelines and data integration solutions
  • Write complex SQL queries, transformations, and stored procedures
  • Perform data analysis, mapping, validation, reconciliation, and quality assurance
  • Design and maintain logical and physical data models
  • Support enterprise data warehouse and analytics environments
  • Work with PostgreSQL, AWS Aurora PostgreSQL, and Oracle databases
  • Troubleshoot data quality, performance, and integration issues
  • Create technical documentation including data mappings and transformation specifications
  • Collaborate with business and technical teams to translate requirements into data solutions
  • Support testing, production deployments, and ongoing operational support

Required Qualifications

  • 6+ years of experience in Data Analysis, Data Engineering, Data Integration, or related fields
  • Strong SQL development and query optimization experience
  • Hands-on ETL/ELT development experience
  • Experience building and supporting enterprise data pipelines
  • Strong data modeling and data management background
  • Strong PostgreSQL expertise
  • Experience with AWS Aurora PostgreSQL
  • Experience working in AWS cloud environments
  • Experience with Oracle databases
  • Experience supporting enterprise data warehouse solutions
  • Strong analytical and problem-solving skills
  • Excellent communication and stakeholder collaboration skills

Preferred Qualifications

  • Financial Services industry experience
  • Experience supporting BI and reporting initiatives
  • Data governance and data quality experience
  • Experience with cloud-based analytics and data warehouse platforms

Why Join Capgemini?

  • Work on enterprise-scale cloud and data transformation programs
  • Collaborate with leading financial services organizations
  • Exposure to modern AWS-based data platforms
  • Competitive compensation and career growth opportunities
About Capgemini:
Capgemini is an AI-powered global business and technology transformation partner, delivering tangible business value. We imagine the future of organizations and make it real with AI, technology and people. With our strong heritage of nearly 60 years, we are a responsible and diverse group of 420,000 team members in more than 50 countries. We deliver end-to-end services and solutions with our deep industry expertise and strong partner ecosystem, leveraging our capabilities across strategy, technology, design, engineering and business operations. The Group reported 2024 global revenues of 22.1 billion.
Make it real | ;/div>
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