Expert BI and Data Analyst Consultant

h3Mission Overview: /h3 pKeystone Solutions is seeking an expert Data Analyst for a consultancy mission in Brussels. You will be hired by Keystone Solutions and represent us on-site within our client's Corporate Banking transformation environment, working under the guidance of the client's Cluster Product Owner. The mission focuses on shaping the future of Corporate Banking data intelligence by modernising the BI and reporting ecosystem from SAS/SQL, Alteryx and JavaScript/React towards a future-proof Power BI platform integrated with Microsoft Dynamics 365. This is a strategic reinvention of how data flows, insights are delivered and business value is unlocked for Sales, Metiers and Leadership teams. /p h3Consultancy

Responsibilities:
/h3 pUnder Keystone Solutions' consultancy model, you will carry out the following responsibilities while representing Keystone Solutions in the client environment: /p ul libStrategic Banking Transformation: /b Lead end-to-end banking data transformations, focusing on strategic planning and migration from legacy ETL workflows to Power BI-centric architectures. /li liDrive adoption roadmaps for scalable, future-proof BI solutions aligned with enterprise data governance and regulatory requirements. /li libPower BI Architecture and Team Upskilling: /b Design and enforce a scalable Power BI architecture. /li liCoach and mentor team members to adopt Power BI best practices, including performance optimisation, security and deployment strategies. /li liUpskill teams in advanced DAX development, including complex calculations, time intelligence and dynamic measures, as well as Power Query/M for efficient data transformation and custom functions. /li liPromote reusable templates, standardised patterns and collaborative development, including shared datasets and Power BI Premium capacities. /li libData Modeling and Analytical Framework: /b Translate business requirements into optimised data models for analytics and reporting. /li liApply dimensional modelling, including star and snowflake schemas, to simplify cross-platform complexity. /li liDesign logical and physical data layers that ensure performance, scalability and maintainability. /li liManage metadata for traceability, including lineage, ownership and refresh cycles. /li libETL Pipeline and Data Integration: /b Own source-to-target mapping and ETL/ELT pipeline optimisation. /li liUse SAS, SQL and Denodo VQL for high-performance data extraction, transformation and loading. /li liImplement data quality controls, including validation rules, anomaly detection and reconciliation processes. /li liEnsure seamless integration of new data sources with minimal latency and maximum reliability. /li libDocumentation and Governance: /b Establish and enforce documentation standards for datasets, including business definitions, technical specifications and refresh policies. /li liDocument workflows, including ETL logic, Power BI reports and dependency mappings. /li liEstablish naming conventions and metadata tagging to ensure discoverability, reusability and auditability across teams. /li libTesting, Validation and Technical Debt Reduction: /b Orchestrate coexistence between legacy systems and the new Power BI ecosystem during transition phases. /li liDevelop reusable transformation patterns and consistent business logic across workflows to minimise technical debt. /li liDesign test cases, validate outputs with stakeholders and document changes for traceability. /li liProactively identify and remediate performance bottlenecks, data inconsistencies and integration gaps. /li /ul h3Profile: /h3 ul liA seasoned BI and Data Engineering expert with deep banking transformation experience. /li liA strategic thinker able to assess legacy systems, data flows and business needs and contribute to architecting a scalable, future-ready solution. /li liA change agent capable of guiding teams through technical transitions while ensuring business continuity and adoption. /li liA collaborative leader who bridges technical execution and business vision. /li liAt least 5 years of relevant experience. /li liMaster's degree or equivalent experience. /li liStrong analytical mindset. /li /ul h3Mandatory Technical

Experience:
/h3 ul liAdvanced Power BI stack expertise: DAX, Power Query/M, Premium capacities, deployment pipelines and XMLA endpoints. /li liSQL language. /li liData modelling expertise: star and snowflake schemas, dimensional modelling and Power BI dataflows. /li /ul h3Preferable Technical and Business

Experience:
/h3 ul liETL tools: Alteryx, SAS, SQL, Denodo VQL and SSIS for legacy environments; Azure Data Factory is a plus. /li liBanking data experience. /li liProven experience with Agile methods. /li /ul h3Language

Requirements:
/h3 ul liFluent English. /li liFluent knowledge of at least one local language: Dutch or French. /li liDutch or French is required, with either language satisfying the local-language requirement. /li /ul h3Agile Mindset an