Quick overview
Job description
Senior Data Modeler- Lakehouse and Dimensional Design
Job Type: Contract (6-12 Months)- Possible extension
Location: Philadelphia, PA / Vienna, VA - Hybrid
Job description:
Summary
- We are seeking a senior data modeler to design the target data model for a financial services client consolidating five legacy data and BI platforms onto Azure Databricks.
- You will rationalize overlapping legacy models into one set of conformed, governed models in Unity Catalog, and give engineers, BI developers and Genie developers a single definition of each entity and metric.
- Key responsibilities
- Reverse-engineer legacy SQL Server, MicroStrategy and ThoughtSpot models to identify entities, grain, keys and overlapping definitions.
- Design conceptual, logical and physical models for each lakehouse layer, from raw ingestion to curated, business-ready tables.
- Build conformed dimensional models for client accounts, households, positions, transactions, assets under management and the general ledger.
- Define how history is kept, including slowly changing dimensions and as-of reporting for month-end and quarter-end close.
- Set naming, key, data type and documentation standards, and review physical designs against them.
- Define Databricks metric views and shared business definitions for Power BI semantic models and Genie spaces.
- Work with business analysts on source-to-target mappings, and with the platform lead on catalog structure and sensitive-data tagging.
- Maintain models, data dictionaries and lineage documentation in the client's modeling tool and in Unity Catalog.
Required qualifications
- 10+ years in data modeling or data architecture, including at least two warehouse migration or consolidation programs.
- Expert dimensional modeling, including conformed dimensions, fact grain and slowly changing dimensions.
- 2+ years designing models on Databricks, Snowflake, Synapse or another cloud data platform.
- Ability to read T-SQL and legacy BI schemas to recover undocumented entities and business rules
- Hands-on use of a modeling tool such as erwin Data Modeler, ER/Studio or SqlDBM.
Ability to explain model trade-offs to both engineers and business stakeholders
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- EG

Lead Data ArchitectRecently posted
Eliassen Group · Los Angeles, CA · On-site · Posted 19 Nov 2026 🇺🇸
SQLGitAWS+11Technology$60 - $65/hr - SI

Data modelerRecently posted
Sage IT Inc · United States · Hybrid · Posted 20 Nov 2026 🇺🇸
SQLComplianceDatabricks+3Salary not listed - KT

Data Governance LeadRecently posted
Kforce Technology Staffing · Sandy Springs, GA · Hybrid · Posted 19 Nov 2026 🇺🇸
OnboardingSQLPCI DSSSalary not listed - ET

Database ArchitectRecently posted
Everest Technologies · Atlanta, GA · On-site · Posted 19 Nov 2026 🇺🇸
WorkdaySalary not listed - LE

Enterprise Data ArchitectRecently posted
Leidos · Saint Paul, Minnesota · Hybrid · Posted 20 Nov 2026 🇺🇸
GCPSQLAWS+2TechnologySalary not listed - MW
Data Architect – Data & AI Platforms (Databricks / Microsoft Fabric)Recently posted
Mind Ware Inc · Woodbridge Township, NJ · On-site · Posted 19 Nov 2026 🇺🇸
Stakeholder ManagementApache SparkSnowflake+8TechnologySalary not listed - AG

Data ArchitectRecently posted
ARROWCORE GROUP · Scottsdale, AZ · Hybrid · Posted 19 Nov 2026 🇺🇸
AWSETLEncryption+6TechnologySalary not listed - SR

Database ArchitectRecently posted
SriLakshmiTech · United States · On-site · Posted 19 Nov 2026 🇺🇸
WorkdayERPSalary not listed - TE

Data Warehouse ArchitectRecently posted
Technocrafts, Inc. · United States · Hybrid · Posted 19 Nov 2026 🇺🇸
TechnologySalary not listed - MT

Data ArchitectRecently posted
Mersoft Technology LLC · Washington, DC · On-site · Posted 19 Nov 2026 🇺🇸
SQLApache SparkETL+13TechnologySalary not listed - TE
Healthcare Data ArchitectRecently posted
TekShapers · United States · Hybrid · Posted 19 Nov 2026 🇺🇸
Stakeholder ManagementOracleSQL+5TechnologySalary not listed - RT
Data Warehouse ArchitectRecently posted
RedSalsa Technologies, Inc. · United States · On-site · Posted 19 Nov 2026 🇺🇸
TechnologySalary not listed