Expert BI and Data Analyst Consultant

Keystone Solutions; Brussel Hoofdstad; Hybrid; EUR 70,000 - 110,000; Full time

Job summary

Keystone Solutions in Brussels is seeking an expert Data Analyst to join a consultancy mission on-site within a Corporate Banking transformation program. You will shape the future of data intelligence by modernising the BI and reporting ecosystem from SAS/SQL/Alteryx towards a Power BI platform integrated with Microsoft Dynamics 365.

You will lead data transformations, design scalable BI architectures, mentor teams in DAX and Power BI best practices, and ensure data governance and performance.

Qualifications

• 5+ years of BI/data engineering experience in banking transformations.
• Master's degree or equivalent experience.
• Fluent English and Dutch or French; local-language proficiency required.

Responsibilities

• Lead end-to-end banking data transformations and migrate from legacy ETL to Power BI-centric architectures.
• Design and enforce a scalable Power BI architecture and promote reusable templates.
• Coach and mentor teams in DAX, Power BI best practices, and data transformation techniques.
• Manage metadata, data quality controls and governance across datasets and reports.
• Ensure seamless integration of new data sources with minimal latency and high reliability.

Skills

Power BI

DAX

Power Query/M

SQL

Data modelling

Education

Master's degree

Tools

SAS

Denodo VQL

SSIS

Alteryx

Azure Data Factory

Job description

Mission Overview:

Keystone 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.

Consultancy Responsibilities:

Under Keystone Solutions' consultancy model, you will carry out the following responsibilities while representing Keystone Solutions in the client environment:

• Strategic Banking Transformation: Lead end-to-end banking data transformations, focusing on strategic planning and migration from legacy ETL workflows to Power BI-centric architectures.
• Drive adoption roadmaps for scalable, future-proof BI solutions aligned with enterprise data governance and regulatory requirements.
• Power BI Architecture and Team Upskilling: Design and enforce a scalable Power BI architecture.
• Coach and mentor team members to adopt Power BI best practices, including performance optimisation, security and deployment strategies.
• Upskill 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.
• Promote reusable templates, standardised patterns and collaborative development, including shared datasets and Power BI Premium capacities.
• Data Modeling and Analytical Framework: Translate business requirements into optimised data models for analytics and reporting.
• Apply dimensional modelling, including star and snowflake schemas, to simplify cross-platform complexity.
• Design logical and physical data layers that ensure performance, scalability and maintainability.
• Manage metadata for traceability, including lineage, ownership and refresh cycles.
• ETL Pipeline and Data Integration: Own source-to-target mapping and ETL/ELT pipeline optimisation.
• Use SAS, SQL and Denodo VQL for high-performance data extraction, transformation and loading.
• Implement data quality controls, including validation rules, anomaly detection and reconciliation processes.
• Ensure seamless integration of new data sources with minimal latency and maximum reliability.
• Documentation and Governance: Establish and enforce documentation standards for datasets, including business definitions, technical specifications and refresh policies.
• Document workflows, including ETL logic, Power BI reports and dependency mappings.
• Establish naming conventions and metadata tagging to ensure discoverability, reusability and auditability across teams.
• Testing, Validation and Technical Debt Reduction: Orchestrate coexistence between legacy systems and 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, validate outputs with stakeholders and document changes for traceability.
• Proactively identify and remediate performance bottlenecks, data inconsistencies and integration gaps.

Profile:

• A seasoned BI and Data Engineering expert with deep banking transformation experience.
• A strategic thinker able to assess legacy systems, data flows and business needs and contribute to architecting a scalable, future-ready solution.
• A change agent capable of guiding teams through technical transitions while ensuring business continuity and adoption.
• A collaborative leader who bridges technical execution and business vision.
• At least 5 years of relevant experience.
• Master's degree or equivalent experience.
• Strong analytical mindset.

Mandatory Technical Experience:

• Advanced Power BI stack expertise: DAX, Power Query/M, Premium capacities, deployment pipelines and XMLA endpoints.
• SQL language.
• Data modelling expertise: star and snowflake schemas, dimensional modelling and Power BI dataflows.

Preferable Technical and Business Experience:

• ETL tools: Alteryx, SAS, SQL, Denodo VQL and SSIS for legacy environments; Azure Data Factory is a plus.
• Banking data experience.
• Proven experience with Agile methods.

Language Requirements:

• Fluent English.
• Fluent knowledge of at least one local language: Dutch or French.
• Dutch or French is required, with either language satisfying the local-language requirement.

Agile Mindset and Soft Skills:

• Bring a positive attitude and pragmatism.
• Demonstrate a thirst for knowledge, embracing learning, adaptation and knowledge sharing as essential to Agile success.
• Focus on team success rather than individual success or heroic behaviour; achieving the team's goal takes priority over merely completing individual tasks.
• Treat outcomes as feedback and lessons, adjusting actions continuously to improve.
• Work effectively in a cross-functional Agile team encompassing analysis, development, testing and other disciplines. Although team members have a primary discipline, be prepared to contribute to other roles whenever this supports the sprint goal.
• Drive for results and deliver high-quality work.
• Demonstrate risk awareness and a solid understanding of fundamental risk concepts, always considering risk in daily activities.
• Act as a corporate role model with discipline, integrity and high ethical standards.
• Be a strong team player with cross-cultural awareness, collaborating and sharing information and solutions with colleagues, other teams and stakeholders across IT and Business.
• Maintain a strong client focus and regard both stakeholders and external clients as customers.
• Show genuine interest in financial markets, continually learning and staying abreast of developments, with a good appreciation of economics and market dynamics and sufficient understanding to present views on market conditions and trends.
• Understand the market, credit, operational, compliance, legal, regulatory and reputational risks associated with the work performed.
• Show diligence and dedication, prioritising problems according to business impact and identifying quick wins.
• Demonstrate resilience by staying calm and positive and managing emotions during conflict or intense pressure related to markets, deadlines or clients.
• Be an active listener and clear communicator in both English and the applicable native/local language, communicating proactively with management and escalating issues when necessary.
• Demonstrate innovation by thinking laterally, identifying additional useful sources of information and finding ways around obstacles and barriers.

Additional Conditions:

• No travel is required.
• All sourcing-related communication and process steps must comply with the client's sourcing process and be governed through the designated e-sourcing platform, with the appropriate external staffing function kept informed of supplier-initiated contacts.
• Applicable deontology rules prohibit gifts, advantages or invitations to employees involved in supplier selection during a consultation; non-compliance may result in supplier exclusion. Potential conflicts of interest involving supplier relationships with employees of the relevant client entity must be disclosed in the proposal.
• Information relating to the sourcing consultation must be treated as strictly confidential and proprietary and must not be disclosed to third parties not directly involved in preparing the proposal. The supplier relationship must not be publicised without prior written consent.
• The client will treat supplier information designated as confidential and proprietary with equivalent consideration.
• The designated external staffing function and e-sourcing platform are the only counterparts for rate commitments; rates must not be discussed with managers.
• The client's supplier Code of Conduct and commitments concerning corporate social responsibility, environmental responsibility, internationally recognised human rights and avoidance of complicity in human-rights abuses apply to suppliers.

Why Join Keystone Solutions:

As a Keystone Solutions consultant, you combine a strong on-site consultant identity with exposure to dynamic projects and diverse challenges across client environments. This model offers turbo-charged learning through broad technical, business and transformation experiences while supporting skyrocketing ambition and continued career growth within Keystone Solutions. Being a K-Stone means bringing our core values, professionalism, collaboration, adaptability and commitment to quality to every engagement while growing across challenging client projects.