EXL

Senior Data Architect

EXL

full-time

Posted on:

Location Type: Hybrid

Location: 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AzureETLSQLVault

About the role

  • Design and maintain enterprise data models using Data Vault 2.0, dimensional modeling (Kimball), and normalized approaches (Inmon).
  • Develop modular, reusable model components that can be adapted across multiple business entities.
  • Build curated datasets and support the development of data products for business consumption.
  • Work with engineering teams to implement models on Azure and Databricks platforms.
  • Align data model designs with ETL/ELT pipelines, ingestion frameworks, and BI/reporting tools.
  • Ensure models support performance, scalability, and data quality requirements.
  • Establish and maintain modeling standards, documentation guidelines, metadata structures, and lineage requirements.
  • Promote consistency and adherence to data governance practices across teams.
  • Work closely with business stakeholders to translate requirements into data model designs.
  • Provide guidance and mentorship to junior data modelers.
  • Serve as a subject matter expert for data modeling methodologies and modern data architecture practices.

Requirements

  • 10–12 years of experience in data architecture, data modeling, or data warehousing.
  • Strong expertise in Data Vault 2.0, including hub, link, and satellite design.
  • Hands-on experience with Azure (ADF, Synapse, ADLS) and Databricks.
  • Deep understanding of Kimball and Inmon modeling techniques.
  • Proficiency in SQL and ELT/ETL concepts.
  • Experience with metadata management and modeling documentation.
  • Insurance industry experience in P&C and/or L&A (policy, claims, underwriting, billing, actuarial, etc.).
  • Strong communication and collaboration skills; able to guide junior team members.
  • Experience designing reusable data model templates or frameworks.
  • Background supporting data product development or semantic layer implementation.
  • Familiarity with data governance frameworks and enterprise data management practices.
Benefits
  • EXL never requires or asks for fees/payments or credit card or bank details during any phase of the recruitment or hiring process and has not authorized any agencies or partners to collect any fee or payment from prospective candidates. EXL will only extend a job offer after a candidate has gone through a formal interview process with members of EXL’s Human Resources team, as well as our hiring managers.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
Data Vault 2.0dimensional modelingnormalized modelingSQLETLELTmetadata managementdata modeling documentationdata product developmentsemantic layer implementation
Soft skills
communicationcollaborationguidancementorship