Data Analyst

Capgemini•New York, NY

12d•$100,000 - $118,000•Remote

About The Position

Capgemini is seeking an experienced Data Analyst to support a strategic Financial Services engagement. This role will be responsible for supporting enterprise data solutions, developing and maintaining ETL/ELT processes, performing data analysis and reconciliation activities, and supporting enterprise data warehouse initiatives within an AWS cloud environment. The ideal candidate will possess strong SQL, ETL/ELT, data modeling, PostgreSQL, and Oracle experience, along with working knowledge of AWS Aurora PostgreSQL and AWS cloud environments.

Requirements

6-10 years of Data Analysis, Data Integration, Data Engineering, or related experience
Strong SQL development and query optimization skills
Experience developing and supporting ETL/ELT solutions
Experience building and maintaining enterprise data pipelines
Strong data modeling and data management experience
Strong PostgreSQL experience
Experience with AWS Aurora PostgreSQL
Experience working within AWS cloud environments
Experience with Oracle databases
Experience supporting enterprise data warehouse environments
Strong analytical, troubleshooting, and problem-solving skills
Excellent communication and collaboration skills
Ability to work independently and within cross-functional teams
Strong attention to detail and focus on data quality
Experience delivering reliable, scalable, and high-performance data solutions
Ability to translate business requirements into technical data solutions
Candidates must be authorized to work in the U.S. on a permanent basis without the need for current or future visa sponsorship.

Nice To Haves

Experience within Financial Services environments
Experience supporting BI and reporting solutions
Data governance and data quality experience
Experience supporting cloud-based analytics platforms and data warehouse environments

Responsibilities

Design, develop, and maintain ETL/ELT processes supporting enterprise data solutions
Develop complex SQL queries, stored procedures, and transformation logic
Create and maintain logical and physical data models
Perform data mapping, validation, reconciliation, and data quality activities
Support enterprise data warehouse environments and data integration solutions
Work with AWS Aurora PostgreSQL, PostgreSQL, and Oracle databases
Troubleshoot and resolve data quality, performance, and integration issues
Document data flows, mappings, transformation rules, and technical specifications
Partner with business and technical stakeholders to translate requirements into technical data solutions
Support reporting, analytics, and business intelligence initiatives
Participate in testing, validation, production support, and release activities

Benefits

Comprehensive medical, dental, vision, life insurance, and retirement benefits
Paid time off and holidays
Career development opportunities within a global technology and consulting organization
Vacation: 12-25 days, depending on grade
Company paid holidays
Personal Days
Sick Leave
Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
Life and disability insurance
Employee assistance programs