Data Analyst | AWS Cloud | PostgreSQL

Capgemini; New York (NY); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Health coverage

401(k) plan

Paid time off

Family benefits

Mentoring & learning

Job summary

Capgemini is seeking a Data Analyst to support a strategic Financial Services engagement, focusing on enterprise data solutions, ETL/ELT development, data analysis, reconciliation, and data warehouse initiatives in an AWS cloud environment.

The role requires strong SQL/PostgreSQL skills, experience with AWS Aurora PostgreSQL, Oracle, and data modeling, with responsibilities spanning data mapping, validation, and collaboration with stakeholders to define data requirements.

Qualifications

• 6-10 years of experience in data analysis or related disciplines.
• Advanced SQL development and query optimization.
• Experience with AWS Aurora PostgreSQL and AWS cloud environments.
• ETL/ELT development and data warehousing experience.

Responsibilities

• Design, develop, and support ETL/ELT processes for enterprise data solutions.
• Write and optimize complex SQL queries and transformation logic.
• Perform data mapping, validation, reconciliation, and data quality activities.
• Create and maintain logical and physical data models.
• Support enterprise data warehouse and data integration initiatives.
• Work with PostgreSQL, AWS Aurora PostgreSQL, Oracle, and AWS cloud technologies.
• Troubleshoot data quality, performance, and integration issues.
• Collaborate with business and technical stakeholders to define data requirements and solutions.
• Support testing, production support, and release activities.
• Document data flows, mappings, and technical specifications.

Skills

Advanced SQL

PostgreSQL

AWS

ETL/ELT

Data modeling

Data warehousing

Oracle

Analytical thinking

Stakeholder communication

Tools

Oracle Database tools

AWS Aurora PostgreSQL

Job description

Choosing Capgemini means choosing a company where you will be empowered to shape your career, collaborate with talented colleagues around the world, and help leading organizations unlock the value of technology in a more sustainable and inclusive way.

About the Role

Capgemini is seeking a Data Analyst to support a strategic Financial Services engagement. This role will focus on enterprise data solutions, ETL/ELT development, data analysis, reconciliation, and data warehouse initiatives within an AWS cloud environment.

The ideal candidate will have strong experience with SQL, PostgreSQL, AWS Aurora PostgreSQL, Oracle, ETL/ELT processes, data modeling, and data quality management.

Responsibilities

• Design, develop, and support ETL/ELT processes for enterprise data solutions
• Write and optimize complex SQL queries and transformation logic
• Perform data mapping, validation, reconciliation, and data quality activities
• Create and maintain logical and physical data models
• Support enterprise data warehouse and data integration initiatives
• Work with PostgreSQL, AWS Aurora PostgreSQL, Oracle, and AWS cloud technologies
• Troubleshoot data quality, performance, and integration issues
• Collaborate with business and technical stakeholders to define data requirements and solutions
• Support testing, production support, and release activities
• Document data flows, mappings, and technical specifications

Required Qualifications

• 6-10 years of experience in Data Analysis, Data Integration, Data Engineering, or related disciplines
• Advanced SQL development and query optimization skills
• Experience with AWS Aurora PostgreSQL
• Experience working in AWS cloud environments
• ETL/ELT development and support experience
• Data modeling and data management experience
• Experience with Oracle databases
• Enterprise data warehouse experienceStrong analytical and problem-solving skills
• Excellent communication and stakeholder management skills

Preferred Qualifications

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

What You'll Bring

• Strong expertise in SQL, PostgreSQL, and enterprise data environments
• Experience with data validation, reconciliation, and quality management
• Ability to translate business requirements into scalable technical solutions
• Strong attention to detail and commitment to delivering high-quality data solutions
• Ability to work effectively in cross-functional teams

No sponsorship available. Applicants must be authorized to work in their country of employment without current or future visa sponsorship.

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 | www.capgemini.com

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:

• 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
• 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