Senior Business Analyst

Intellias; Portugal; On-site; EUR 42,000 - 65,000; Full time

Benefits offered by this job

Health Insurance

22 days annual leave

Permanent contract

Porto office

Snacks and drinks at the office

Discount platform

Job summary

Intellias is hiring a Business Analyst to join a delivery team for a large-scale enterprise data platform migration in the financial services sector. You will bridge domain owners with delivery engineers, own the backlog in Azure DevOps, and help shape data models across multiple business domains.

You will collaborate with SMEs and analysts to define concepts, standards, and governance, and contribute to a federated data model while supporting lakehouse initiatives and CI/CD processes.

Qualifications

• Substantial data modelling experience including conceptual/logical modelling
• Credible domain knowledge in asset/investment management or related financial services
• Ability to run business workshops and translate definitions for engineering/architecture teams
• Experience with backlogs, requests, and traceability from business terms to delivered data columns

Responsibilities

• Run data modelling workshops with business SMEs and analysts
• Design conceptual and logical data models across multiple domains
• Ensure traceability from business terms to delivered data columns
• Contribute to federated data model and governance standards
• Review and challenge model changes including AI-generated drafts

Skills

Data modelling

Asset management domain

Workshops facilitation

Backlog management

Tools

GitHub

Azure DevOps

Git

Erwin/ER/Studio

Job description

We are hiring a Business Analyst to join an Intellias delivery team on a large-scale enterprise data platform migration programme for a financial services client. You will bridge the client's domain owners and stewards on one side and the delivery engineers on the other, and you will own the backlog in Azure DevOps.

Project Overview

• Our client is an independent, active global asset manager with over R3 trillion in assets under management. They are executing a firm-wide data strategy to govern, manage and engineer data as a product across more than 70 business-owned sub-domains.
• As part of this, they are migrating to Databricks as the foundational layer of their Enterprise Data Platform, adopting a lakehouse architecture built on open formats, declarative pipelines and Unity Catalog.

Requirements

• Substantial data modelling experience, with a track record of conceptual, logical modelling that powered physical models that went into production, consumed, iterated upon & versioned accordingly. You must be competent in the principles of abstraction, inheritance, normalisation. Experience with dimensional/denormalization techniques.
• Demonstrable domain knowledge in asset/investment management, or a closely related financial services area — sufficient to hold a credible conversation with a SME, e.g. a portfolio manager, a fund accountant or a risk analyst about what their data actually means.

We are building out domain by domain. You would be expected to develop working depth across more than one area. We expect some in depth asset management knowledge in at least 3 of these areas:

• Instrument/Security reference, Index & Benchmarks, Party, Counterparty/ Client, Portfolio, Holdings & Valuations, Execution, Trade Life cycle, Performance & Attribution, ESG/sustainability, Fund Accounting, Sales & Marketing.
• Working fluency with Git and GitHub: branching, pull requests, resolving conflicts, reviewing others' changes. You do not need to be a software engineer, but you must be comfortable that your model lives in a repository and moves through code review.
• Comfort authoring in YAML, and working with JSON data – plus the willingness to learn a schema language - prior exposure is welcome but not expected.
• Experience establishing or working to modelling standards — naming conventions, data dictionaries, glossaries, and the ability to add/enhance those standards as part of the platform maturation and greater automation.
• Soft Skills: The ability to run a workshop with business stakeholders and leave with clarity, and not a list of open questions. Precision with language. Dealing with ambiguity. Much of this role is writing definitions that all stakeholders can agree on.

Nice to have

• Databricks, Delta Lake or a comparable Lakehouse platform.
• Data contracts, particularly ODCS, or equivalent interface-versioning practice.
• CI/CD concepts.
• Experience of developing/using agentic workflows for delivering model artefacts.
• Experience of a federated or data mesh operating model, and its failure modes.
• Traditional modelling tools such as Erwin, ER/Studio is useful, for reference, however our way of working will be different.

Responsibilities

• Run data modelling workshops with business SMEs, domain owners, analysts.
• Design conceptual and logical data models across multiple business domains, working from business definitions as well as from existing data structures in mastering systems.
• Model business complexity appropriately: e.g. class hierarchies, inheritance, controlled vocabularies, reusable patterns, shared data domains, business rules, and define where cross-domain references exist.
• Present models back to stakeholders for review, information-sharing, and agreement
• Ensure every model element traces back to a business term from data governance, and that the trace survives all the way to the delivered column. Help to resolve conflicts or missing inputs/outputs where they exist
• Review other domain data models from the modelling team. We envisage a small team of modellers who contribute to the federated data model as a whole.

Standards and federation

• Contribute to and enforce the modelling standards that make federated delivery safe: naming conventions, data type standards, model layering rules, and the conventions that prevent domains colliding as the model grows
• Define reusable enterprise-level structures — shared types, reusable/common patterns, balancing core versus domain-local

Delivery and automation

• Work in Git and GitHub as your primary environment: branches, pull requests, code review, releases
• Review model changes raised by others — including, ultimately, any changes drafted by AI agents — and apply the judgement that automated checks cannot
• Version models, assess the impact of breaking changes on downstream consumers in order for migration planning
• Contribute to the automated checks that enforce standards in CI, in collaboration with engineering
• Have input into the logical-to-physical mapping — deciding and documenting where a normalised structure can/should be denormalised for query performance or analytics (e.g. a data product), an define agreed and named patterns for these transformations rather than ad-hoc judgement so they can be automated.

What we offer

• 22 days of annual leave per year + 3 paid sick leaves;
• Permanent contract;
• Health Insurance (employee);
• Modern, well-equipped office in the centre of Porto;
• Snacks and drinks at the office;
• Access to discount platform.

Why this position

Sit at the centre of a large-scale enterprise data platform migration, translating a 70+ sub-domain data strategy into clear, actionable requirements for engineering and architecture teams to build against. You'll work closely with business domain owners and technical teams to shape how data standards and migration priorities get defined and delivered, gaining hands‑on exposure to a high‑stakes lakehouse transformation and modern, AI‑enabled ways of working.