Senior Data Modeler

Hybrid in Miramar, FL, US • Posted 30+ days ago • Updated 6 days ago

Full Time

Occasional Travel Required

Hybrid

Depends on Experience

EmployVision

Fitment

Dice Job Match Score™

🧠 Analyzing your skills...

Job Details

Skills

Data Modeling
Dimensional Modeling
ERwin
ER/Studio
SCD
Slowly Changing Dimensions
PowerDesigner
SQL
Data Warehouse
Enterprise Data Warehouses
EDW

Summary

Job Title: Data Modeler – Senior Consultant

Location: Miramar, FL (Hybrid) (Local Only)

Duration: Permanent | Full-Time

Overview

We are looking for a Senior Data Modeler with deep expertise in enterprise data warehousing (EDW) and dimensional modeling to design scalable, analytics-ready data models. This role requires strong collaboration with business and technical stakeholders and hands-on leadership across end-to-end data initiatives.

Key Responsibilities

Design conceptual, logical, and physical data models for Enterprise Data Warehouses (EDW)
Apply Kimball dimensional modeling techniques (facts, dimensions, star schemas)
Define and implement Slowly Changing Dimensions (SCD), with strong focus on Type 2
Partner with stakeholders to translate business requirements into optimized data models
Define fact table grain, metrics, and dimensional relationships
Create and maintain data dictionaries, metadata, and source-to-target mappings
Identify and resolve data model and performance issues
Document standards and best practices across data modeling initiatives

Required Qualifications

Bachelor’s degree
7+ years of hands-on data modeling experience
Strong expertise in SQL and Kimball dimensional modeling methodology
Experience with EDW and relational/cloud databases (Oracle, SQL Server, or similar)
Knowledge of SCD Type 2 (plus other SCD types)
Experience with ETL/ELT architectures, data quality, and metadata management
Proficiency with data modeling tools (e.g. Erwin, PowerDesigner, ER/Studio, Visio)
Strong analytical, communication, and documentation skills

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: 10236683
Position Id: 8849491
Posted 30+ days ago

Company Info

About EmployVision

EmployVision is a talent acquisition and management solutions company delivering services that enable its clients to win in the changing work environment. We offer a range of services for the entire employment and business cycle, including direct-hire and contract staffing; executive search, employee assessment and selection; consulting and recruitment process outsourcing.

EmployVision meets the needs of its clients, including small and medium size enterprises in all major industry sectors, as well as the world's largest multinational corporations. Our broad-based experience in recruiting and an in-depth understanding of the workforce trends helps drive performance.

We combine our unique expertise and knowledge with a commitment to service excellence to deliver optimal workforce solutions that exceed expectations and integrate seamlessly within any organization.

Go to company profile

Create job alert

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