Data Modeler

Our client is looking for a Senior Data Modeler to design and evolve trusted, analytics-ready data models that power reporting, self-serve analytics, and data products across the business.

In this role, you will be a key technical leader who partners with data engineering, BI, governance, and business stakeholders to translate business processes into scalable dimensional models, establish consistent metric definitions, and drive modeling standards across domains. You’ll influence how data products are shaped—from conceptual design through implementation—ensuring clarity, performance, and long-term maintainability.

This role is ideal for someone who combines deep modeling expertise with strong business acumen, and who can mentor others while raising the overall quality bar for analytics models.

What You’ll Do

Enforce the design and evolution of dimensional models (facts, conformed dimensions, metrics) that support enterprise analytics and self-serve use cases.

Lead discovery with business stakeholders to define business processes, grain, measures, hierarchies, and conformed dimensions, translating these into model specifications and semantic definitions.

Define and enforce modeling standards (naming conventions, metric definitions, dimensional patterns, SCD strategies, documentation templates).

Partner with data engineering to ensure performant implementations on Azure platforms (e.g., curated layers, incremental patterns, scalability, and query performance).

Drive conformed dimension strategy and cross-domain consistency.

Establish and maintain a metrics and dimensional standards library, promoting consistent definitions across reports and data products.

Support semantic and consumption layers to ensure governed, consistent results for business users.

Define data quality and reconciliation approaches (balancing, exception handling, completeness / accuracy rules) and partner with teams to operationalize them.

Contribute to governance practices including metadata, lineage, classifications (e.g., PII), and access patterns aligned to enterprise controls.

Produce and maintain high-quality modeling artifacts : conceptual / logical / physical designs, model diagrams, data dictionaries, mapping documents, and change logs.

Provide technical leadership through design reviews, peer coaching, and mentorship for engineers / analysts building or extending models.

What You Bring

7+ years of experience in data modeling / analytics engineering / BI modeling, including ownership of enterprise models and standards.

Star / snowflake schema design, fact table patterns, conformed dimensions

SCD Type 1 / 2 (and when to use each), role-playing dimensions, bridge tables

Strong SQL skills and strong analytical methods for data profiling, reconciliation, and validation.

Demonstrated ability to translate complex business processes into clear models, explain trade-offs, and align multiple stakeholders to a shared design.

Strong documentation and communication skills—able to create artifacts that enable scalable delivery.

Experience working in Agile, cross-functional delivery teams and providing technical direction.

Preferred / Nice-to-Have

Experience with Azure data platforms and modern analytics stacks.

Experience with Power BI semantic modeling (tabular concepts, metrics governance, deployment patterns).

Familiarity with governance and security concepts (cataloging, lineage, RBAC / ABAC, auditing, data classification).

Experience with modeling / documentation tooling (e.g., ERwin, SQLDBM, dbt docs, Lucidchart, etc.).

Understanding of master / reference data management concepts.

Core Competencies

Business-first modeling : You anchor models in real-world processes and user outcomes.

Pragmatic standardization : You establish standards that enable speed without sacrificing quality.

Clarity & documentation : You create models and definitions that others can trust and extend.

Collaboration & influence : You align stakeholders and lead through expertise.

Quality mindset : You prioritize correctness, reconciliation, repeatability, and reusability.

Technical Environment

Seniority level : Mid-Senior level

Employment type : Contract

Job function : Information Technology

Industries : IT Services and IT Consulting

#J-18808-Ljbffr