LiftmyCVLiftmyCV
DT

Senior Microsoft Fabric Data Modeler / Semantic Model Architect

Derex Technologies IncOn-sitePhoenix, US

Job 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. 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: Ext 206

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

Job details

Published
August 5, 2026
Last checked
November 14, 2026
Job source
smartrecruiters
Workplace
On-site · Phoenix, US
First seen
August 5, 2026
AI match explained

See how well you match this job

Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.

Sign up to see your matchAlready have an account? Log in

More at Derex Technologies Inc

Similar jobs from this company

None listed.

Across the market

Similar jobs from other companies

Third-party content disclaimer

Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.

LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.

LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.

If you prefer, you may apply directly via the original listing for transparency.