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:

o Coaching & mentoring team members to adopt Power BI best practices (e.g., performance optimization, security, deployment strategies).

o Upskilling teams in advanced DAX development (complex calculations, time intelligence, dynamic measures) and Power Query/M (efficient data transformation, custom functions).

o 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:

o Dimensional modeling (star/snowflake schemas) simplify cross-platform complexity.

o Logical/physical data layer design ensuring performance, scalability, and maintainability.

o 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:

o SAS, SQL, Denodo VQL for high-performance data extraction, transformation, and loading.

o Data quality controls (validation rules, anomaly detection, reconciliation processes).

o Seamless integration of new data sources with minimal latency and maximum reliability.

5. Documentation & Governance

• Establish and enforce documentation standards for:

o Datasets (business definitions, technical specifications, refresh policies).

o Workflows (ETL logic, Power BI reports, dependency mappings).

o 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, Power BI dataflows
• ETL tools : Alteryx, SAS, SQL, Denodo VQL, SSIS (legacy), Azure Data Factory (plus)