Data Engineering & Analytics consultant

Talanto; Oslo; Hybrid; NOK 1,240,000 - 2,204,000; Full time

Job summary

Talanto seeks an experienced data and analytics consultant to support governance, data product design, and enterprise-grade reporting in a Microsoft Fabric environment. The role requires close collaboration with architects, risk, compliance, finance, and IT stakeholders to model financial data and deliver scalable data products for reporting and automation.

The engagement is 6 months, on-site in Oslo, with capacity for 1 FTE.

Qualifications

• Solid understanding of data modelling including scalable semantic models and reusable data products.
• Experience with financial data domains such as market data, static data, transactional data, AML/KYC, positions, and accounting data.
• End-to-end data engineering in a cloud-based modern data platform, preferably Microsoft Fabric.
• Experience working in complex organisations with data, insights, reporting, and automation initiatives involving multiple stakeholders.
• Knowledge of data governance including ownership, lineage, quality, access control, and auditability.

Responsibilities

• Ingest data from external source systems into Microsoft Fabric using robust pipelines.
• Design and implement transformations, curated data layers, and reusable data products for analytics and reporting.
• Develop data quality tests, validation routines, and reconciliation controls across source and target data sets.
• Document data lineage, dependencies, refresh logic, and ownership for Fabric solutions.
• Model financial data domains and translate concepts into scalable semantic models and reporting structures.
• Ensure consistent handling of identifiers, hierarchies, time dimensions, and source-system keys.

Skills

Data modelling

Data governance

Stakeholder management

Communication

Independent work

Tools

Microsoft Fabric

Power BI

Azure Data Lake

Synapse

Job description

Important: if an employer asks you to log into their system via iCloud or Google, send a code, an SMS or Telegram password, run some code, or install software — refuse. These are signs of fraud.

The client is a Nordic investment bank and investment firm with operations in Norway and Sweden, providing capital markets services across investment banking, equities, fixed income, foreign exchange, derivatives and investment research. We support corporate, institutional and private clients with financing, advisory services, securities trading, hedging solutions and capital and debt market insight. Through our sector expertise, execution capability and close cooperation with our owner banks, we combine strong local distribution with Nordic reach and international investor access, with the ambition to be a leading Nordic capital markets platform.

Engagement Overview

We are looking to engage an experienced data and analytics consultant to support the design and implementation of governed data products, enterprise-grade reporting layers, and automation-enabling datasets in and analytics in a modern data platform in Microsoft Fabric and related Microsoft data platform services.

The consultant will work closely with internal architects, business stakeholders, IT, operations, IT, risk and, compliance, and finance stakeholders to design and model external and internal financial data, establish data quality controls, implement secure access models, and translate business needs into reliable data sets for reporting, analytics, exports, and operational automation, and scalable, and governance aligned Power BI reports.

Engagement period: 6 months, with possible extension

Capacity: 1 FTE

Expected start date: To be specified by the supplier

Work location and presence requirements: On site at the client's offices, Oslo

Proposed consultant profile, including CV, relevant project references, and role in comparable assignments

Availability, earliest possible start date, and any known constraints during the engagement period

Proposed allocation model, including confirmation that the consultant can cover 1 FTE

Hourly rate, commercial terms, and any assumptions or dependencies in the proposal

Key Responsibilities

Microsoft Fabric Data Engineering

Ingest data from external source systems into Microsoft Fabric using robust, maintainable pipelines

Design and implement transformations, curated data layers, and reusable data products suitable for analytics and operational use

Develop and maintain data quality tests, validation routines, and reconciliation controls across source and target data sets

Document data lineage, dependencies, refresh logic, and operational ownership for Fabric-based solutions

Model financial data domains including market data, static data, transactional data, AML/KYC data, positions, and accounting data

Translate business concepts and financial data definitions into scalable semantic models and reusable reporting structures

Ensure consistent handling of identifiers, hierarchies, time dimensions, ownership, historization, and source-system keys

Collaborate with business, IT, risk, compliance, and finance stakeholders to clarify data meaning, usage, and control requirements

Security, Data Governance & Access Control

Advise on and implement security, data governance, and access control principles across data engineering and reporting solutions

Manage and contain confidential data in accordance with internal policies, external regulatory requirements, and agreed access models

Define and implement role-based access control, workspace governance, data classification, and segregation of duties where relevant

Support auditability through clear documentation of permissions, data handling principles, control points, and ownership

Reporting, Export Layer & Operational Automation

Understand business needs and translate them into data sets suitable for reporting, exports, analytics, and operational automation

Design and maintain reporting and export layers with clear data definitions, stable structures, and appropriate performance characteristics

Support downstream consumers by ensuring data sets are reliable, well-documented, and fit for business-critical use cases

Identify opportunities to standardise recurring reports, manual extracts, and operational processes through governed data products

Required Competence & Experience

Solid understanding of and hands-on experience with data modelling, including scalable semantic models, reusable data products, and reporting-ready data structures

Experience working with financial data domains such as market data, static data, transactional data, AML/KYC, positions, and accounting data

Experience with end-to-end data engineering in a cloud-based modern data platform, preferably in Microsoft Fabric

Proven experience working in complex organisations with data, insights, reporting, and/or automation initiatives involving both technical and non-technical stakeholders

Good understanding of key data governance principles, including data ownership, lineage, quality, classification, access control, and auditability

Experience implementing or advising on security, confidentiality, role-based access control, and segregation of duties in data and reporting solutions

Ability to translate business needs into well-defined data sets, reporting layers, exports, and operational automation use cases

Strong communication skills and ability to work independently with business, operations, IT, risk, compliance, and finance, and front-office stakeholders

Nice to Have

Familiarity with Microsoft Fabric, Azure Data Lake, Synapse, Power BI, and related Microsoft data platform services

Experience from regulated environments such as finance, compliance, risk, security, or other control- and reporting-heavy domains

Experience integrating financial, trading, CRM, identity, or third-party source systems into governed data and reporting platforms