Data Modeler

Us3 Consulting; Manchester; Hybrid; GBP 73,800 - 101,475; Full time

Job summary

A leading consulting firm in Manchester is seeking a Data Modeller for a 6 to 12 month contract. You will design Gold-layer domain-specific data models that enhance reporting and analytics, requiring strong Azure-based experience. The role demands strong SQL skills and the ability to translate business needs into effective data structures. This position is onsite three days a week, emphasizing engagement with both technical and non-technical stakeholders. Competitive opportunities abound for those with a background in complex data environments.

Qualifications

• Experience working in regulated or complex data environments is an advantage.
• Comfortable working to tight timescales.
• Proven ability to design models that support both operational reporting and exploratory analytics.

Responsibilities

• Design, evolve, and govern Gold-layer domain specific data models.
• Translate reporting requirements and business questions into robust, performant data structures.
• Ensure intuitive, consistent, and future-proof data models aligned with enterprise standards.

Skills

Strong experience designing analytics-ready Gold models within an Azure-based medallion architecture

Advanced SQL skills for modelling, validation, and performance optimisation

Deep understanding of dimensional modelling concepts (facts, dimensions, grain, conformed dimensions)

Ability to translate ambiguous business questions into clear, reusable data structures

Strong documentation and communication skills

Tools

Power BI

Job description

Executive Search/Sr.BD Consultant - Bridging Business Goals and Professional Insight

One of our leading utilities clients are seeking a Data Modeller for a 6 to 12 month contract position in Manchester, UK. Must be onsite 3 days a week – Tuesday, Wednesday and Thursday.

The Data Modeller is responsible for designing, evolving, and governing Gold-layer domain specific data models that power trusted reporting, analytics, and scalable self‑service use across the organisation.

This role blends deep data modelling expertise with strong analytical skills – translating reporting requirements and business questions into robust, performant, and reusable data structures that balance clarity for reporting with flexibility for ad‑hoc data exploration.

The modeller acts as a critical bridge between Silver-layer data engineering patterns and business-facing consumption, ensuring that the resulting data models are intuitive, consistent, and future‑proof while remaining aligned with enterprise standards and governance.

Key Skills & Experience

• Comfortable working to tight timescales
• Strong experience designing analytics‑ready Gold models within an Azure‑based medallion architecture
• Deep understanding of dimensional modelling concepts (facts, dimensions, grain, conformed dimensions)
• Proven ability to design models that support both operational reporting and exploratory analytics
• Advanced SQL skills for modelling, validation, and performance optimisation
• Experience supporting self‑service BI platforms (e.g. Power BI), including interaction with semantic models
• Understanding of how upstream modelling choices (e.g. Data Vault, Silver transformations) impact Gold design
• Ability to translate ambiguous business questions into clear, reusable data structures
• Experience working in regulated or complex data environments an advantage
• Strong documentation and communication skills, able to explain modelling decisions to technical and non‑technical audiences

Kindly submit your application if you are interested.

Seniority level: Associate

Employment type: Contract

Job function: Information Technology

Referrals increase your chances of interviewing at Us3 Consulting by 2x