Senior Microsoft Fabric Data Modeler / Semantic Model Architect

Company Description

Derex Technologies Inc specializes in providing IT consulting, staffing solutions and software services. Globally headquartered in Harrison New Jersey since 1996 Derex delivers the highest quality technology professionals and an array of customized IT talent solutions designed to improve productivity and drive results to global clients throughout North America.

With over two decades of unparalleled experience, Derex provides supports to its clientele, across such industries as Systems Integration, Banking and Finance, Telecommunications, Pharmaceutical and Life Sciences, Energy, Healthcare, Technology, Transportation, and local and federal Government agencies.

Job Description

Role: Senior Microsoft Fabric Data Modeler / Semantic Model Architect

Location : Phoenix, AZ – Local Profile Only

Long Term Contract

Visa type : GC, USC, H1B

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).

Regards,

Manoj Goud

Derex Technologies INC

Contact : 973-834-5005 Ext 206

Qualifications

Additional Information

All your information will be kept confidential according to EEO guidelines.