Company DescriptionDerex 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 DescriptionRole: Senior Microsoft Fabric Data Modeler / Semantic Model ArchitectLocation : Phoenix, AZ - Local Profile OnlyLong Term ContractVisa type : H1BClient Interview: In-person OnlyRole SummarySeeking 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 GoudDerex Technologies INCContact : Ext 206QualificationsAdditional InformationAll your information will be kept confidential according to EEO guidelines.
Never miss an opportunity! Create an alert based on the job you applied for.