Capgemini is seeking a highly motivated and detail-oriented Data Engineer for a top 10 US Insurance Carrier.
In this role, you will be part of a team that prioritizes continuous improvement and optimization, with a strong focus on measuring and reporting performance and adherence.
Responsibilities:
- Building ETL process as well as reporting applications using Power BI to create new business functionalities as well to solve business problems.
- Writing Complex Queries, Stored Procedures, Views, User Defined Functions, Cursors and Common Table Expressions.
- Responding to new requests for reports/data understanding business objectives and processes; reviewing and refining technical requirements/User Stories.
- Extracting data directly from relational databases (e.g. Snowflake, SQL Server), data warehouses, or other data stores using SQL.
- Working under the direction of reporting manager on the successful delivery of projects, enhancements, and defects.
- Translating functional requirements into technical specifications for ETL development; developing source-to-target mappings and actively manage.
- Conducting performance tuning and query optimization of Snowflake database
- Troubleshooting production defects, performing root cause analysis, and providing guidance to team on the fixes.
- Supporting application unit testing for enhancements or system/infrastructure upgrades.
Work Experience in This Field
- Minimum Required: 7-9 years
- Preferred: Over 9 years
English Proficiency
- Minimum Required: Fluent
Required Education
- Minimum Required: Bachelor's Degree
- Preferred: Bachelor's Degree
Required Branch of Study
- Bachelors in Technology
Other Critical Skills:
- Power BI - Advanced
- SnowFlake - Intermediate
- AWS - Intermediate
- Informatica - Advanced
Software / Tool Skills:
- Rally - Advanced )
Competitive compensation and benefits package:
- Competitive salary and performance-based bonuses
- Comprehensive benefits package
- Career development and training opportunities
- Flexible work arrangements (remote and/or office-based)
- Dynamic and inclusive work culture within a globally renowned group
- Private Health Insurance
- Pension Plan
- Paid Time Off
- Training & Development
Note: Benefits differ based on employee level.
About Capgemini
Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology. The Group is guided everyday by its purpose of unleashing human energy through technology for an inclusive and sustainable future. It is a responsible and diverse organization of over 340,000 team members in more than 50 countries. With its strong 55-year heritage and deep industry expertise, Capgemini is trusted by its clients to address the entire breadth of their business needs, from strategy and design to operations, fueled by the fast evolving and innovative world of cloud, data, AI, connectivity, software, digital engineering and platforms. The Group €22.5 billion in revenues in 2023.
Top Skills
What We Do
Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology. The Group is guided everyday by its purpose of unleashing human energy through technology for an inclusive and sustainable future. It is a responsible and diverse organization of 270,000 team members in nearly 50 countries. With its strong 50 year heritage and deep industry expertise, Capgemini is trusted by its clients to address the entire breadth of their business needs, from strategy and design to operations, fueled by the fast evolving and innovative world of cloud, data, AI, connectivity, software, digital engineering and platforms. The Group reported in 2020 global revenues of €16 billion.
