AWS Data Analyst - ETL & Data Warehouse

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

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.