Senior Microsoft Fabric Data Modeler / Semantic Model Architect


Purple Hires
Dice Job Match Score™
🛠️ Calibrating flux capacitors...
Job Details
Skills
- Business Intelligence
- Semantics
- Star Schema
Summary
Role: Senior Microsoft Fabric Data Modeler / Semantic Model Architect
Location : Phoenix, AZ – Local Profile Only
Long Term Contract
Client Interview: In-person Only
Role Summary
Seeking an experienced Microsoft Fabric Data Modeler to transform an on-premises MySQL Vessel ERP data model into a scalable Microsoft Fabric analytics platform. The role will own dimensional modeling, Gold-layer design, semantic model development, and collaboration with Power BI developers to enable enterprise self-service reporting.
Key Responsibilities
- Analyze complex MySQL ERP schemas and business processes.
- Design enterprise-grade Star Schema data (models Facts, Dimensions, Bridge Tables, SCDs).
- Develop and optimize Bronze, Silver, and Gold layer data models in Microsoft Fabric.
- Build and maintain Fabric Semantic Models for reusable enterprise reporting.
- Define KPIs, measures, hierarchies, relationships, and Row-Level Security (RLS).
- Partner with Data Engineers to design analytics-ready data structures.
- Collaborate closely with Power BI developers to deliver performant dashboards and self-service reporting solutions.
- Work with business stakeholders to translate reporting requirements into scalable data models.
- Ensure data quality, reconciliation, governance, and documentation standards.
- Optimize Direct Lake, semantic model performance, and reporting scalability.
Required Skills
- 7-10+ years of experience in Data Warehousing, Data Modeling, and BI solutions.
- Strong expertise in Star Schema, Dimensional Modeling, and Data Warehouse design.
- Hands-on experience with Microsoft Fabric, OneLake, Lakehouse, Warehouse, and Semantic Models.
- Advanced SQL skills and experience working with MySQL or other enterprise ERP databases.
- Strong knowledge of Power BI Semantic Modeling, DAX, and self-service analytics.
- Experience with Azure Data Services including Azure Data Factory, Azure Data Lake Storage, and cloud-based analytics architectures.
- Excellent communication skills with the ability to work across business and technical teams.
Preferred Qualifications
- Microsoft Fabric certifications (DP-600, DP-700).
- Dice Id: 91170791
- Position Id: 9051182
- Posted 7 hours ago
Company Info
About Purple Hires
At Purple Hires, we are dedicated to consistently delivering an outstanding recruitment experience that benefits both our clients and candidates.
We are committed to excellence in every aspect of our recruitment process. From understanding client requirements to sourcing, screening, and presenting the most suitable candidates, we maintain high standards and a results-driven approach. Our goal is not just to fill positions but to add genuine value to our clients’ teams by finding the right talent.
Honesty and openness are at the heart of our recruitment practices. We believe that clear, consistent communication fosters trust and reliability. Whether discussing job requirements, candidate expectations, or process timelines, we ensure that all parties remain well-informed and engaged. Transparency is key to building long-term relationships and ensuring mutual satisfaction.
Respect for both clients and candidates underpins our entire approach. We treat every individual with dignity and professionalism, recognizing that a positive experience leaves a lasting impact. From initial engagement to final placement, we handle each interaction with empathy and consideration, promoting a respectful and inclusive environment.
By combining performance, transparency, and respect, we create a seamless, rewarding recruitment experience. Clients can rely on us for consistent quality and integrity, while candidates feel valued and supported throughout their journey. This holistic approach allows us to build sustainable relationships and maintain a reputation as a trusted recruitment partner.


Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs