Senior Data Engineer (ERP)

MCS Group; Belfast City District; Hybrid; GBP 50,000 - 60,000; Full time

Benefits offered by this job

Hybrid working

Job summary

MCS Group is growing its data function in Belfast. We are seeking a Senior Data Engineer to design scalable data models that enable enterprise analytics and reporting across Finance, Procurement, Supply Chain, Planning and CRM.

You will bridge business requirements with the data platform, delivering robust enterprise data models and governance. Key responsibilities include leading workshops, developing dbt models, and ensuring data quality and lineage across ERP/CRM systems.

Qualifications

• Proven experience designing conceptual, logical and physical data models.
• Strong SQL skills and ability to analyze and validate complex datasets.
• Hands-on experience with dbt for data transformations and modelling.
• Experience with ERP/CRM platforms (SAP experience advantageous).
• Strong understanding of dimensional modelling and data warehousing principles.

Responsibilities

• Lead workshops and requirements sessions with business stakeholders.
• Design and maintain enterprise data models for reporting and analytics.
• Develop and maintain dbt models, transformations, testing and documentation.
• Define source-to-target mappings and data lineage across systems.
• Produce data dictionaries and technical documentation.
• Collaborate with Data Engineering, Analytics and BI teams to deliver reusable data assets.
• Promote data modelling standards and best practices.

Skills

Data modelling

SQL

Communication

Analytical thinking

Tools

dbt

Snowflake

Salesforce

SAP

Job description

Senior Data Engineer

Belfast | Hybrid | £50,000 - £60,000

This is an exciting opportunity to join a newly expanding team supporting enterprise-wide analytics and data transformation across Finance, Procurement, Supply Chain, Planning and CRM. The successful candidate will play a key role in designing scalable data models that enable business-critical reporting, analytics and decision-making across a global organisation.

The Role

Working closely with senior architects, data engineers and business stakeholders, you will act as the bridge between corporate functions and the data platform, translating business requirements into robust enterprise data models.

Key responsibilities include:

• Lead workshops and requirements gathering sessions with business stakeholders across Finance, Procurement, Supply Chain, Planning and CRM.
• Design and maintain conceptual, logical and physical data models for enterprise reporting and analytics.
• Develop and maintain dbt models, including transformations, testing, documentation and reusable components.
• Define source-to-target mappings and data lineage across ERP, CRM and other enterprise platforms.
• Produce ER diagrams, data dictionaries and technical documentation.
• Ensure consistency and integrity through strong master data modelling and governance practices.
• Collaborate with Data Engineering, Analytics and BI teams to deliver reusable, scalable data assets.
• Promote data modelling standards, naming conventions and best practices across the organisation.
• Work closely with senior technical leaders to align solutions with enterprise architecture standards.

About You

We're keen to speak with experienced Data Modelers, Data Architects, Analytics Engineers or Senior Data Engineers with strong data modelling expertise.

You’ll ideally have:

• Proven experience designing conceptual, logical and physical data models.
• Strong SQL skills and experience analysing and validating complex datasets.
• Hands-on experience with dbt for data transformations and modelling.
• Experience working with enterprise ERP or CRM platforms (SAP experience is advantageous but not essential).
• Strong understanding of dimensional modelling, data warehousing and enterprise data architecture principles.
• Experience gathering requirements and working directly with business stakeholders.
• Excellent communication skills with the ability to translate technical concepts into business language.

Desirable Experience

• Snowflake
• Master Data Management (MDM)
• Salesforce or other enterprise CRM platforms
• Data engineering concepts including ELT pipelines
• Experience working within large enterprise or corporate environments

What's on Offer

• Competitive salary of £50,000-£60,000, with flexibility for exceptional candidates.
• Hybrid working.
• Opportunity to join a growing global data function.
• Exposure to modern cloud data technologies and enterprise-scale analytics.
• Clear career progression within a large international organisation.
• Collaborative environment working alongside experienced architects and engineering teams.