Back to Jobs
Recently postedOther

Senior Data Modeler

eSolutionsFirst, LLCPhiladelphia, PA🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationPhiladelphia, PA, United States
SQLT-SQLSnowflakeDatabricksGeneral LedgerUnityAzurePower BISQL Server

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