Lead Data Analyst
About This Role
Role Overview
We are seeking an experienced Senior Data Analyst with deep expertise in SQL, data mapping, data marts, and data warehousing, along with significant exposure to the banking domain (last 5–6 years). The ideal candidate will play a critical role in transforming business requirements into scalable data solutions and enabling data-driven decision-making.
Key Responsibilities
Design, develop, and optimize complex SQL queries for data extraction, transformation, and analysis
Lead data mapping and data lineage activities across multiple systems
Develop and maintain data marts and enterprise data warehouse (EDW) structures
Collaborate with business stakeholders to understand requirements and translate them into data models and analytical solutions
Ensure data quality, consistency, and integrity across systems
Work closely with ETL teams to define and validate data transformation logic
Perform data analysis and profiling to support reporting and regulatory requirements
Support banking-specific analytics use cases (e.g., risk, compliance, customer analytics, transactions)
Document data flows, mappings, and technical specifications
Mentor junior analysts and provide technical guidance
Required Skills & Experience
13+ years of experience in Data Analytics roles
Strong expertise in:
SQL (advanced level – complex joins, performance tuning, optimization)
Data Mapping & Data Lineage
Data Warehousing concepts (Star/Snowflake schemas)
Data Mart design and implementation
Solid understanding of ETL processes and data pipelines
Experience working with large-scale relational databases (e.g., Oracle, SQL Server, Teradata, etc.)
Strong analytical and problem-solving skills
Similar Jobs
Lead Data Scientist
Capgemini · Abu Dhabi
**About the job you are considering** ------------------------------------- **Your Role** ------------- **Your Skills and Experience** ------------------------------ **Why you should consider Capgemini** ----------------
Yesterday
Generate Resume ↗Lead Data Scientist
Capgemini · Abu Dhabi
**About the job you are considering** ------------------------------------- Capgemini Global Insights \& Data business line is a market leader in the data, platform, and analytics across all regions and cross many sector
Yesterday
Generate Resume ↗Lead Data Engineer
Capgemini · Abu Dhabi
**About the job you are considering** ------------------------------------- Capgemini Global Insights \& Data business line is a market leader in the data, platform, and analytics across all regions and across many secto
Yesterday
Generate Resume ↗Lead Data Engineer
Capgemini · Abu Dhabi
**About the job you are considering** ------------------------------------- Capgemini Global Insights \& Data business line is a market leader in the data, platform, and analytics across all regions and across many secto
Yesterday
Generate Resume ↗Lead Data Intelligence Machine Learning Engineer
Dyson · Dubai
**About Us** At Dyson, we’re driven by a relentless pursuit of innovation—pushing boundaries in engineering, AI, and robotics. Our new Data Intelligence team sits at the heart of this mission: shaping Dyson’s future thro
1 weeks ago
Generate Resume ↗Informatica Technical Lead Data Quality & Data Governance
Datamatics Technologies · Dubai
Lead design and implementation of Data Quality rules, manage Data Governance workflows, and develop data integration patterns using Informatica IDMC and Power BI.
2 weeks ago
Generate Resume ↗Lead Data Intelligence Project Manager
Dyson · Dubai
**About Us** At Dyson, we’re driven by a relentless pursuit of innovation—pushing boundaries in engineering, AI, and robotics. Our new Data Intelligence team sits at the heart of this mission: shaping Dyson’s future thro
2 weeks ago
Generate Resume ↗Lead Data Engineer
Inception · Abu Dhabi
Inception, a G42 company, is the region’s leading innovator of AI\-powered domain\-specific as well as industry\-agnostic products, built on a rich heritage of research and development. Within the G42 ecosystem, Inceptio
3 weeks ago
Generate Resume ↗Lead Data Analyst
Net2Source (N2S) · Dubai
**Technical Skills:** * Strong data querying and processing skills using **SQL** * Data Visualization tools – Power BI, Business Objects, Crystal or similar tool * Data Warehousing and ETL concepts **Competencies:** * Ex
3 weeks ago
Generate Resume ↗Stop applying blindly.
Start getting hired.
Base Career automates the hardest parts of job searching — apply smarter, not harder.
AI Resume in 60s
Your resume rewritten for this exact role using the job description as the brief.
ATS-Optimized
Get past automated screening filters with the right keywords matched to each job.
Application Tracker
Track every job, follow-up, and interview in one visual kanban board.
Free plan · No credit card required