Senior Data Engineer (ERP)

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.

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

• 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.

MCS Group is a leading professional recruitment services company resourcing for the specialist IT & Digital, Technical & Engineering and Professional Services recruitment markets in Northern Ireland. MCS Group is widely recognised as a genuine market leader in IT & Digital recruitment in Northern Ireland, with an increasing profile in the Technical & Engineering and Professional Services markets.

At MCS we connect people!! We work with the majority of NI’ leadings employers in the sector, from large foreign direct investment (FDI) organisations to successful, locally owned technology firms, connecting talented professional with the best career opportunities.

Our Team

At MCS Group our track record is impressive and through our highly experienced team we offer employers almost 100 years successful delivery experience in specialist disciplines.

Our consultants know the market and speak your language. They will help you cut through the flannel and will work hard to help you achieve your goals, either as candidate seeking a career improvement or an employer seeking talented people.

Ethics & Values

Honesty, trust and confidentiality are the pillars which underpin everything we do. We are known for treating people with respect and will deal with you in a straightforward manner. We are focused on long term wins for our candidates and clients.