Data Analyst (Expert) - BNP Paribas Fortis

Detailed Responsibilities and Skills

Additional Responsibilities

• Apply dimensional modelling using star/snowflake schemas to simplify cross-platform complexity.
• Design logical and physical data layers for performance, scalability and maintainability.
• Manage metadata for traceability, including lineage, ownership and refresh cycles.
• Own source-to-target mapping and ETL/ELT pipeline optimisation.
• Extract, transform and load data using SAS, SQL and Denodo VQL.
• Implement data quality controls, including validation rules, anomaly detection and reconciliation processes.
• Integrate new data sources with minimal latency and maximum reliability.
• Establish documentation standards and enforce their use.
• Document datasets with business definitions, technical specifications and refresh policies.
• Document workflows with ETL logic, Power BI reports and dependency mappings.
• Standardise naming conventions and metadata tagging for discoverability, reusability and auditability across teams.
• Orchestrate legacy-system coexistence with the new Power BI ecosystem during transition phases.
• Develop reusable transformation patterns and consistent business logic across workflows to minimise technical debt.
• Design test cases for validation.
• Validate outputs with stakeholders.
• Document changes for traceability.
• Identify and remediate performance bottlenecks, data inconsistencies and integration gaps.

General skills

• Required: At least 5 years of relevant experience
• Required: Master’s degree or equivalent experience
• Required: Strong analytical mindset
• Required: Fluent English
• Required: Fluent Dutch or French; at least one local language is required, not both
• Required: Positive attitude and pragmatism within an Agile mindset
• Required: Learn, adapt and share knowledge
• Required: Prioritise team success over individual completion or heroic behaviour
• Required: Use feedback as learning and adjust actions for continuous improvement
• Required: Contribute across analysis, development, testing and other roles whenever needed to achieve sprint goals
• Required: Deliver high-quality work and drive results
• Required: Understand fundamental risk concepts and consider risk in daily activities
• Required: Act with discipline, integrity and high ethical standards as a corporate role model
• Required: Collaborate effectively and share information and solutions across cultures, teams, IT, Business and stakeholders
• Required: Treat internal stakeholders and external clients as customers
• Required: Maintain interest and learning in financial markets, economics and market dynamics; present views on conditions and trends
• Required: Understand market, credit, operational, compliance, legal, regulatory and reputational risks associated with the work
• Required: Show dedication, prioritise problems by business impact and identify quick wins
• Required: Remain calm and positive and manage emotions during conflict and market, time or client pressure
• Required: Listen actively and communicate clearly in native and English languages
• Required: Communicate proactively with management and escalate issues when necessary
• Required: Think laterally, identify useful information sources and find ways around obstacles
• Preferred: Experience with banking data
• Preferred: Proven experience with Agile method
• Mission context; priority not explicitly classified: Guide teams through technical transitions while ensuring business continuity and adoption
• Mission context; priority not explicitly classified: Bridge technical execution and business vision through collaborative leadership

Technical skills

• Required: Advanced Power BI stack expertise
• Required: Advanced DAX development
• Required: Advanced Power Query/M
• Required: SQL language proficiency
• Required: Star/snowflake schema data modelling
• Required: Dimensional modelling
• Mission context; priority not explicitly classified: Seasoned BI and Data Engineering expertise with deep banking transformation experience
• Mission context; priority not explicitly classified: Assess legacy systems, data flows and business needs and contribute to scalable, future-ready solution architecture

Tools

• Required: Power BI Premium capacities
• Required: Power BI deployment pipelines
• Required: Power BI XMLA endpoints
• Required: Power BI dataflows
• Preferred: Experience with Alteryx ETL tooling
• Preferred: Experience with SAS ETL tooling
• Preferred: Experience with SQL for ETL
• Preferred: Experience with Denodo VQL for ETL
• Preferred: Experience with legacy SSIS
• Preferred: Azure Data Factory is a plus