Data Modeller

EXL Talent Acquisition Team; New York (NY); On-site; USD 90,000 - 130,000; Full time

Job summary

EXL Talent Acquisition Team is seeking a skilled Data Modeller to design, implement, and maintain structured data models across medallion layers. You will collaborate with data engineers, analysts, and business stakeholders to ensure accurate, consistent modelling that drives organizational value.

You will work on Silver and Gold layers, define mappings, standards, and governance, and help translate requirements into scalable data structures. Strong SQL and documentation skills are essential.

Qualifications

• Proven experience as a Data Modeller or Data Architect in a modern data platform.
• Strong understanding of medallion architecture (Bronze/Silver/Gold).
• Hands-on experience with source-to-target mapping and data lineage docs.
• Proficiency in dimensional modelling and related design approaches.
• Experience with data modelling tools and cloud platforms.

Responsibilities

• Design, develop, and maintain data models for Silver and Gold layers.
• Create and manage source-to-target mapping documents defining data lineage.
• Collaborate with engineers to translate business requirements into data models.
• Define data standards, naming conventions, and best practices across the platform.
• Reflect reporting and analytics needs in Gold-layer structures.
• Identify and resolve data quality issues during modelling and mapping.
• Document models, transformation rules, and mapping specs for traceability.
• Support metadata management and data cataloguing initiatives.
• Review transformation logic between Bronze→Silver and Silver→Gold.

Skills

Data Modeller

Data Architect

Medallion architecture

Source-to-target mapping

Dimensional modelling

SQL

Documentation

Tools

erwin

dbt

Dataedo

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 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 → Silver and Silver → 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