You apply on EXL’s own site. RoleWeek never sees your application.
Skills mentionedSnowflakedbtDatabricksAzureSQL
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
Responsibilities
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.
