Senior Data Modeler

Hybrid in Philadelphia, PA, US • Posted 1 day ago • Updated 16 hours ago
Contract W2
12 Months
No Travel Required
Hybrid
Depends on Experience
Company Branding Image
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • data modeling or data architecture
  • Databricks
  • Snowflake
  • Synapse or another cloud data platform.

Summary

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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10367586
  • Position Id: 9147809
  • Posted 1 day ago

Company Info

About eSolutionsFirst, LLC

eSolutionsFirst is a premier technology and talent solutions partner providing best-in-class IT solutions and staffing services that empower our clients to be market leaders.

We Believe in Consistent, Quality & Transparent Hiring Process.

As a pioneer in talent management since we are proud of bridging the gap between diverse aspiring talent and various visionary organizations. Our people-centric Workforce portfolio spans across to help businesses overcome any talent management challenge. Our experience in serving industry leaders and Fortune500 companies gear us to empower enterprises of any size and industry with our dynamic staffing solutions.

 We Deliver the Promise of Modern Technology.

Our leading-edge capabilities in Cloud, Data, and Security have been fortifying businesses with accelerated digital transformation over years. Our proven methodologies and pragmatic approaches revolutionize IT environments across diverse industries. Through our advisory and end-to-end digital transformation solutions, we encourage companies to establish a “Cloud-First Data-Driven” culture.

 • Over 1,000 man-years of services in IT services.

• Over 100+ software development and management engagements.

• Over 17+ years of advisory services and multiple commercial-grade software products developed.

About_Company_OneAbout_Company_Two
Contact the job poster
GR

Gajendra Ravuru

Recruiter @ eSolutionsFirst, LLC

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.