Data Modeller

EXL; New York (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

EXL is seeking a Data Modeller to join our data team in New York. You will design and implement structured data models across the medallion architecture, with a focus on Silver and Gold layers, collaborating with engineers, analysts and business stakeholders to ensure accurate, traceable models.

Responsibilities include source-to-target mapping, data standards enforcement, and comprehensive documentation of models and rules.

Qualifications

• Proven experience as a Data Modeller or Data Architect in modern data platforms.
• Strong knowledge of medallion architecture and data lineage documentation.
• Experience with dimensional modelling, star/snowflake schemas, and normalised/denormalised design.

Responsibilities

• Design, develop, and maintain data models for Silver and Gold layers.
• Create and manage source-to-target mapping documents and data lineage.
• Collaborate with data engineers to translate requirements into models.
• Define data standards, naming conventions, and best practices.
• Document models, transformation rules, and mapping specs for auditability.
• Review and validate transformation logic between Bronze-Silver and Silver-Gold.

Skills

Data Modeller

Data Architect

Medallion architecture

Source-to-target mapping

Dimensional modelling

SQL proficiency

Business stakeholder engagement

Documentation

Education

Bachelor's degree

Tools

erwin

dbt

Dataedo

Collibra

Alation

Purview

Delta Lake

Databricks

Snowflake

Azure Synapse

BigQuery

Job description

About the Role

We are looking for a skilled Data Modeller to join our data team and play a key role in designing and implementing structured data models across our medallion architecture - with a primary focus on the Silver (cleansed/conformed) and Gold (business-ready/aggregated) layers. You will work closely with data engineers, analysts, and business stakeholders to ensure data is modelled accurately, consistently, and in a way that drives value across the organisation.

Key Responsibilities

• Design, develop, and maintain data models for the Silver layer (cleansed, deduplicated, and conformed data) and the Gold layer (aggregated, business-logic-applied, reporting-ready data)
• Create and manage source-to-target mapping documents to clearly define data lineage from raw ingestion through to consumption layers
• Collaborate with data engineers to translate business requirements into logical and physical data models
• Define and enforce data standards, naming conventions, and modelling best practices across the data platform
• Work with business and analytics teams to understand reporting and analytical requirements and reflect them in Gold-layer structures
• Identify and resolve data quality, consistency, and integrity issues during modelling and mapping exercises
• Document data models, transformation rules, and mapping specifications to ensure traceability and auditability
• Participate in data governance initiatives, supporting metadata management and data cataloguing efforts
• Review and validate transformation logic applied between Bronze to Silver and Silver to Gold layers
• Contribute to the evolution of the overall data architecture and medallion framework

Required Skills & Experience

• Proven experience as a Data Modeller, Data Architect, or similar role within a modern data platform environment
• Strong understanding of medallion architecture (Bronze/Silver/Gold layering) and the purpose of each layer
• Hands-on experience with source-to-target mapping and data lineage documentation
• Proficiency in dimensional modelling (star schema, snowflake schema) and normalised/denormalised design approaches
• Experience with data modelling tools such as erwin, dbt, Dataedo, or similar
• Familiarity with cloud data platforms (e.g. Databricks, Snowflake, Azure Synapse, BigQuery)
• Strong SQL skills for validating and prototyping data structures and transformations
• Ability to engage with both technical teams and business stakeholders to gather and translate requirements
• Good documentation skills — comfortable producing mapping specs, data dictionaries, and model diagrams

Nice to Have

• Experience with dbt for managing Silver/Gold transformations and model documentation
• Exposure to data governance frameworks or tools (e.g. Collibra, Alation, Purview)
• Familiarity with Delta Lake or similar open table formats
• Understanding of data mesh or domain-oriented data modelling principles

Critical thought leader, crossfunctional leadership across GT functions in advancing EXL Unified architecture, design and process;
Establish highly productive partnerships with functional team, partners in the delivery of enterprise digital solutions;
Proactively engage/lead enterprise digital initiatives to improve usage, stability and business value.Bachelor Degree Min 10 years