Senior Data Engineer (ERP) - Hybrid, Data Modeling

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

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.