Data Analyst

BI & Data Analyst Expert

We're seeking a visionary BI & Data Analyst / Engineering Expert with a proven track record in banking transformation to lead a high-impact digital evolution. If you thrive at the intersection of business strategy, cutting-edge analytics, and technical innovation, this is your opportunity to redefine how data drives decisions for Corporate Banking's Sales, Metiers, and Leadership teams.

Your Mission: From Legacy to Leadership

Under the (Cluster) Product owner's guidance, you'll spearhead the end-to-end modernization of our BI and reporting ecosystem—transitioning from SAS/SQL, Alteryx, and JavaScript/React to a future-proof Power BI platform integrated with Microsoft Dynamics 365.

This isn't just a migration; You won't just build reports; it's a strategic reinvention of how data flows, insights are delivered, and business value is unlocked.

What We’re Looking For

• A seasoned BI & Data Engineering expert with deep banking transformation experience.
• A strategic thinker who can assess legacy systems, data flows, and business needs—contributing to architecting a scalable, future-ready solution.
• A change agent who excels in guiding teams through technical transitions while ensuring business continuity and adoption.
• A collaborative leader who bridges the gap between technical execution and business vision.
• Ready to transform data into a strategic asset? Let's build the future—together

Function description

1. Strategic Banking Transformation (ETL & visualisation modernisation)
   • Lead end-to-end banking data transformations, with a focus on strategic planning and migration from legacy ETL workflows to Power BI-centric architectures.
   • Drive adoption roadmaps for scalable, future-proof BI solutions, ensuring alignment with enterprise data governance and regulatory requirements.
2. Power BI Architecture & Team Upskilling
   • Design and enforce a scalable Power BI architecture, including:
   • Coaching & mentoring team members to adopt Power BI best practices (e.g., performance optimization, security, deployment strategies).
   • Upskilling teams in advanced DAX development (complex calculations, time intelligence, dynamic measures) and Power Query/M (efficient data transformation, custom functions).
   • Promoting reusable templates, standardized patterns, and collaborative development (e.g., shared datasets, Power BI Premium capacities).
3. Data Modeling & Analytical Framework
   • Translate business requirements into optimized data models for analytics and reporting, including:
   • Dimensional modeling (star/snowflake schemas) simplify cross-platform complexity.
   • Logical/physical data layer design ensuring performance, scalability, and maintainability.
   • Metadata management for traceability (lineage, ownership, refresh cycles).
4. ETL Pipeline & Data Integration
   • Own source-to-target mapping and ETL/ELT pipeline optimization, with expertise in:
   • SAS, SQL, Denodo VQL for high-performance data extraction, transformation, and loading.
   • Data quality controls (validation rules, anomaly detection, reconciliation processes).
   • Seamless integration of new data sources with minimal latency and maximum reliability.
5. Documentation & Governance
   • Establish and enforce documentation standards for:
   • Datasets (business definitions, technical specifications, refresh policies).
   • Workflows (ETL logic, Power BI reports, dependency mappings).
   • Naming conventions and metadata tagging to ensure discoverability, reusability, and auditability across teams.
6. Testing, Validation & Technical Debt reduction
   • Orchestrate coexistence between legacy systems and new Power BI ecosystems during transition phases.
   • Develop reusable transformation patterns and consistent business logic across workflows to minimize technical debt.
   • Design test cases, validate outputs with stakeholders, and document changes for traceability.
   • Proactively identify and remediate performance bottlenecks, data inconsistencies, or integration gaps.

Language requirements

Fluent knowledge of English as well as (at least) one local language

Education

Master or equivalent experience

Strong analytical mindset

Required experience / knowledge

At least 5 years of relevant experience

Technical experience mandatory

Power BI stack : Advanced: DAX, Power Query/M, Premium capacities, deployment pipelines, XMLA endpoints SQL language

Data modeling : Star/snowflake schemas, dimensional modeling, Po