Senior Data Engineer
CapgeminiAbout the role
Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.
About the Role
Capgemini is seeking an experienced Data Engineer to support a strategic Financial Services engagement. This role will be responsible for developing scalable data solutions, building and maintaining data pipelines, optimizing data processing workflows, and supporting enterprise reporting and analytics initiatives.
The ideal candidate will have strong hands-on experience in SQL, ETL/ELT development, data modeling, and cloud-based data platforms, with a proven track record of delivering scalable and reliable data solutions.
Responsibilities:
- Design, develop, and maintain scalable ETL/ELT pipelines
- Build and optimize data integration solutions across multiple source systems
- Develop complex SQL queries, stored procedures, and transformation logic
- Create and maintain logical and physical data models
- Perform data mapping, validation, reconciliation, and quality assurance activities
- Support cloud-based data warehouse and analytics platforms
- Work with AWS Aurora PostgreSQL, Amazon Redshift, 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 scalable data solutions
- Support reporting, analytics, and business intelligence initiatives
Required Qualifications
- 6-10 years of Data Engineering 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
- Experience with AWS data platforms, including Aurora PostgreSQL and Amazon Redshift
- Experience with PostgreSQL and Oracle databases
- Experience supporting enterprise data warehouse environments
- Strong analytical, troubleshooting, and problem-solving skills
- Excellent communication and collaboration skills
Preferred Qualifications
- Experience within Financial Services environments
- Experience supporting BI and reporting solutions
- Tableau experience
- Data governance and data quality experience
- Exposure to cloud-based analytics platforms and modern data architectures
What You'll Bring
- 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
Compensation & Benefits
- Base salary up to $118,000
- Target annual bonus of 15%
- Comprehensive medical, dental, vision, life insurance, and retirement benefits
- Paid time off and holidays
- Career development opportunities within a global technology and consulting organization
Additional Information
- Location: New York Metro Area
- Candidates must be authorized to work in the United States now and in the future.
- Capgemini is unable to provide sponsorship for this position.
Skills
- Data Engineering
- SQL
- ETL
- ELT
- Data Pipelines
- Data Modeling
- Data Management
- AWS
- Amazon Redshift
- Aurora PostgreSQL
- PostgreSQL
- Oracle
- Data Warehousing
- Data Integration
- Query Optimization
- Data Validation
- Data Quality
- Tableau
- Financial Services
The base compensation range for this role in the posted location is: 100,000 to 118,000 / yearly
Capgemini provides compensation range information in accordance with applicable national, state, provincial, and local pay transparency laws. The
Apply for this role
Generate a tailored application kit with a matched cover letter, interview prep, and CV highlights — in under 60 seconds.
Apply Now →Generate Application KitFree account required — sign up in 30s