Lead Data Analyst

About the Role:

• The bank's Capital Markets division is undergoing a major modernization of its capital reporting and analytics environment.

• As the team transitions from legacy Excel- and Access-based workflows toward a fully automated, Power BI-driven reporting ecosystem, we are seeking a 
  Lead Data Analyst / ETL Developer
   to drive transformation across data pipelines, reporting, automation, and process optimization.

• This role is ideal for someone who combines deep technical expertise in 
  Python, SQL, ETL pipelines, data modeling, and automation
   with strong business acumen in financial or capital markets environments.

• You will work closely with senior stakeholders, capital reporting SMEs, and technology partners to modernize data processes, streamline reporting, enhance controls, and deliver meaningful insights to the business.

Key Responsibilities:

Data Engineering & ETL

• Design, build, and optimize ETL pipelines to support Capital Reporting datasets (daily, monthly, and regulatory reporting cycles).

• Write and maintain high-performance Python scripts for automation, data reconciliation, and transformation tasks.

• Develop advanced SQL queries, stored procedures, and optimized data extraction frameworks across multiple upstream systems.

• Ensure all ETL processes follow best practices in version control, documentation, and production readiness.

Reporting & Power BI Modernization

• Lead the transition from Excel-based reporting to Power BI dashboards and standardized data models.

• Build semantic models, DAX calculations, and reusable datasets to support business-critical reporting.

• Implement governance, refresh schedules, and source-of-truth validations for Power BI assets.

• Integrate solutions with Power Platform (Power Automate, Power Apps) where required.

Data Analysis & Process Optimization

• Analyze large datasets to identify data gaps, inconsistencies, and improvement opportunities.

• Document current-state processes and design future-state workflows to reduce manual touchpoints and operational risk.

• Support process automation using VBA, macros, and scripting to replace legacy workflows.

• Build and maintain detailed metadata, data dictionaries, and technical specifications.

Stakeholder Engagement

• Partner with Capital Reporting SMEs, Risk, Technology, Finance, and Front Office teams to gather requirements.

• Translate business needs into technical solutions with clarity and precision.

• Present findings, roadmaps, and recommendations to senior stakeholders.

• Work collaboratively within a diverse team, maintaining a learner's mindset and continuous-improvement approach.

Qualifications & Experience:

Must-Haves:

• 5-10 years of experience as a Data Analyst, ETL Developer, Data Engineer, or similar role.

• Strong experience with:

• Python scripting
   (automation, data prep, validation).

• Advanced SQL
   (joins, window functions, procedures, optimization).

• ETL development
   (SSIS, Informatica, Azure Data Factory, or equivalent).

• Data modeling
   (dimensional modeling, semantic layers, star/snowflake schemas).

• Power BI
   (dataflows, DAX, modeling, governance).

• Version control
   (Git or similar).

• Process mapping & documentation
   (Visio, Confluence, or similar).

• VBA/Macros
   for supporting legacy workflows.

Nice-to-Haves:

• Experience in 
  Capital Markets
  , 
  Risk Reporting
  , 
  Finance
  , or 
  Regulatory
   environments.

• Exposure to capital reporting (RWA, EAD, SA-CCR, OSFI, Basel reporting).

• Familiarity with Power Platform (Power Automate, Power Apps).

• Understanding of data lineage, controls, audit requirements, and reconciliations.

Soft Skills:

• Strong communication skills with ability to engage senior stakeholders.

• Curious, growth-oriented mindset with willingness to learn Capital Markets concepts.

• Ability to operate independently in fast-paced, high-pressure reporting environments.

• Problem-solving thinker with strong attention to detail and analytical rigor.