Senior Data Modeler
Hybrid in Miramar, FL, US • Posted 30+ days ago • Updated 3 days agoFull Time
Occasional Travel Required
Hybrid
Depends on Experience
EmployVision
Fitment
Dice Job Match Score™
🔗 Matching skills to job...
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.
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.
.png%3Fformat%3Dwebp&w=1080&q=75)
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs