Senior Data Analyst

Capgemini logo

Capgemini

View Salaries, Reviews, and more  

Job Summary


Salary
โ‚น51,580 - โ‚น84,483 / Monthly EST

Job Type
-

Seniority

Years of Experience
Information not provided

Tech Stacks
SQL Azure RedShift Synapse Teradata Analytics play Snowflake ETL

Job Description

We are looking for Data Analyst with hands-on experience in the Banking or Insurance domain to join our growing analytics team. You will play a key role in transforming complex datasets into actionable insights that drive business decisions across risk, operations, and customer experience.


What you'll do

  • Design, develop, and maintain data models and pipelines within enterprise data warehousing environments
  • Write complex SQL queries to extract, transform, and analyse large-scale financial and operational datasets
  • Build and maintain dashboards and reports to monitor KPIs across lending, claims, underwriting, or risk portfolios
  • Partner with business stakeholders in banking or insurance to translate requirements into analytical solutions
  • Identify data quality issues and work with data engineering teams to resolve them at source
  • Support regulatory and compliance reporting with accurate, timely, and audit-ready data
  • Contribute to the modernisation of legacy reporting infrastructure using cloud data platforms


What we're looking for

  • 5 plus years of experience as a Data Analyst, with at least 3 years in banking or insurance
  • Strong proficiency in SQL โ€” complex joins, window functions, CTEs, query optimisation.
  • Solid understanding of data warehousing concepts โ€” star/snowflake schema, ETL/ELT pipelines, dimensional modelling
  • Experience with DWH platforms such as Snowflake, Amazon Redshift, Azure Synapse, or Teradata
  • Familiarity with BI tools โ€” Power BI, Tableau, or Looker
  • Working knowledge of domain-specific data โ€” credit risk, policy data, claims, AML, or trade finance
  • Ability to communicate data findings clearly to both technical and non-technical stakeholders.


#DataAnalytics #SQL #DataWarehouse #Banking #Insurance #Hiring #Snowflake #PowerBI


Interview Questions of Senior Data Analyst at Capgemini

Interview questions from Capgemini that are similar to Senior Data Analyst
View more interview questions from Capgemini โ†’
banner icon
Prepare For Your Interview in 1 Week?
Equip yourself with possible questions that interviewers might ask you, based on your work experience and job description.
Get Started!

Achieve your dream job with our top-notch tools!

Resume Checker Illustration

Resume Checker

Our free resume checker analyzes the job description and identifies important keywords and skills missing from your resume in just a minute!

Check Now
Interview Preparation Illustration

AI InterviewPrep

Utilizing advanced AI, our tool generates tailored interview questions based on your industry, role, and experience. Practice and receive feedback on your answers in real time!

Check Now
Resume Builder Illustration

Resume Builder

Let us show you the differences between a bad, good, and great resume, and guide you in building a resume that helps you stand out to employers, ensuring you land your next position faster!

Check Now