Technical Data Analyst

Nixor Resource Consulting Ltd; City of Edinburgh; Hybrid; GBP 75,000 - 88,000; Full time

Benefits offered by this job

Hybrid – 50% office / 50% home

Job summary

Nixor Resource Consulting Ltd. seeks a Technical Data Analyst/Data Modeller to join its new Group Data & AI Office in Edinburgh. You will work on designing and modelling the Enterprise Data Model, taking raw data and business requirements to define data structures, entities and relationships.

The role emphasizes data modelling over dashboards, with exposure to Databricks/Medallion environments and collaboration with Data Engineers. Hybrid work in central Edinburgh is offered.

Qualifications

• Analysing and profiling data using SQL and/or Python.
• Creating conceptual, logical and physical data models.
• Producing data mappings and data dictionaries.

Responsibilities

• Analyse and profile data to understand structure and requirements.
• Create conceptual, logical and physical data models for Enterprise Data Model.
• Produce source-to-target mappings and metadata documentation.
• Collaborate with Data Engineers to hand over models and mappings.

Skills

SQL

Python

Data modelling

Data profiling

Data mapping

Tools

ERwin

ER/Studio

Sparx

Job description

Nixor are currently working on an exciting Technical Data Analyst role that opens the door into a lucrative Data Modelling career, within a brand new Data & AI Office.

We're looking for someone who enjoys getting into the detail of how data is structured, what it means and how it should be modelled. You might already be a Data Modeller. Or you might currently be working as a Technical Data Analyst, Business Data Analyst or Data Design Analyst who has strong SQL/Python skills and has been exposed to data modelling.

Either route could work.

This is not a BI, reporting or visualisation Data Analyst role.

Great time to Join.

You’ll join a major financial services organisation as part of its new Group Data & AI Office, helping build and evolve the Enterprise Data Model that will underpin future data products, analytics and AI.

What will you actually be doing?

You’ll work on the "left-hand side" of the data lifecycle – taking raw data and business requirements and working out how that data should be understood, structured and incorporated into the Enterprise Data Model.

That will involve:

• Analysing and profiling data using SQL and/or Python
• Working with business stakeholders to understand data requirements and becoming an SME in the data
• Creating conceptual, logical and physical data models
• Identifying entities, attributes, relationships and business definitions
• Producing source-to-target mappings (STTM) and data mapping documentation
• Supporting metadata, lineage, data dictionaries and modelling standards
• Working closely with Data Engineers and handing over your models and mappings for them to implement
• Helping shape trusted, reusable data within a modern Databricks / Medallion environment

Who could be a good fit?

You don't necessarily need to be an established Enterprise Data Modeller.

We’re equally interested in speaking to technically strong Data Analysts who have worked closely with data structures and understand data modelling concepts.

You might have experience with some of the following:

Conceptual, logical or physical modelling | Source-to-target mapping | Data profiling | SQL | Python | Data mapping | ERDs | Entities & relationships | Metadata | Data lineage | Data dictionaries | Enterprise or domain data models

Experience with ERwin, ER/Studio, Sparx or similar modelling tools would be useful, but isn’t essential.

What this role isn't

This isn't a Power BI / dashboard / visualisation role.

It’s also not Data Science, predictive modelling or MLOps.

And it’s not a hands‑on Data Engineering position.

It’s about getting underneath the data: understanding it, analysing it, modelling it and creating the designs and mappings that Data Engineers can then build from.

Package

Salary: £75,000 to £88,000 + 12% bonus + up to 21% pension contribution

Location: Central Edinburgh

Hybrid – 50% office / 50% home

If you're a Technical Data Analyst who enjoys the structure and design of data more than building dashboards, or an existing Data Modeller looking for a major enterprise programme, then please get in touch.