Senior Semantic Model Developer/Programmer Analyst IV (Power BI / Fabric / Tabular) - Workforce Operations
Minimum Qualifications:
Bachelor's degree or equivalent in a related field; 4 years of related experience.
Job Description:
To provide technical guidance and direction in the development, implementation, and maintenance of information systems at the medical branch.
Reports to: Executive Director, Business & Academic Systems
Preferred Qualifications:
- Master's degree in a related field plus three (3) years of related experience, or bachelor's degree in a related field plus five (5) years of related experience. Related fields include Computer Science, Information Systems, Data Analytics, Business Analytics, Engineering, or a comparable discipline. Related experience means business intelligence, data warehousing, or analytics development, including hands-on development of enterprise semantic/tabular data models in Power BI, Microsoft Fabric, or SQL Server Analysis Services.
- Experience in an academic medical center, health system, or higher-education institution
- Familiarity with clinical, academic, research, or financial data domains
- Experience supporting enterprise-scale BI platforms serving multiple stakeholder groups
- Experience with data governance, data catalogs, or metric standardization
- Experience with source control and CI/CD promotion for BI artifacts (Git / Azure DevOps, Fabric deployment pipelines)
- Experience with Tabular Editor scripting / C# automation
- Experience preparing analytics data structures for AI or machine learning workflows
- Microsoft certification: PL-300, DP-600, or DP-700
Essential Job Functions:
The Senior Semantic Model Developer designs, develops, secures, and deploys enterprise-grade semantic data models on Microsoft Fabric capacity. This position delivers the trusted, high-performance analytical models that support institutional reporting, analytics, and AI initiatives across an academic medical enterprise. Work is hands-on with SQL Server data warehouses, Tabular Editor, DAX, and row-level security, in partnership with data engineering, reporting, analytics, and AI teams.
- Design, develop, and maintain enterprise semantic models using Tabular Editor, deployed to Microsoft Fabric / Power BI Premium capacity.
- Develop measures, KPIs, calculation groups, and supporting metadata using advanced DAX, including query performance optimization.
- Apply dimensional modeling and enterprise BI standards — star schema, conformed dimensions, and reusable certified measures.
- Design and optimize SQL views and analytical objects in the enterprise data warehouse to support semantic models.
- Design and implement Row-Level Security using role-based and attribute-based patterns, and manage security group mappings in line with institutional governance standards.
- Manage the full model lifecycle — development, version control, testing, deployment, refresh management, and performance monitoring.
- Support CI/CD-style promotion of models across Development, Test, and Production environments in collaboration with platform teams.
- Partner with report developers, analysts, and data scientists to ensure correct and efficient use of enterprise models.
- Contribute to enterprise initiatives including centralized KPI repositories, governed metrics, and AI-ready semantic layers.
- Produce and maintain documentation and development standards for the semantic layer.
- Adhere to institutional data privacy, security, and compliance policies, including HIPAA and FERPA requirements applicable to institutional data.
Knowledge, Skills, and Abilities:
- Advanced DAX, including complex calculations, calculation groups, and performance tuning
- Strong T-SQL and experience building analytical views in an enterprise data warehouse
- Hands-on experience with Tabular Editor (v2 or v3) for semantic model development
- Demonstrated experience deploying and managing semantic models on Power BI Premium or Microsoft Fabric capacity, including refresh and performance management
- Proven experience designing and implementing Row-Level Security, including dynamic and attribute-based patterns
- Solid working knowledge of dimensional modeling and semantic layer design
- Working familiarity with Tabular Object Model (TOM) concepts
- Ability to work independently on complex technical initiatives and communicate effectively with analysts, senior stakeholders, and executive leadership
- Strong technical documentation skills
Software and Tools:
Category | Tools | Requirement |
Semantic modeling | Tabular Editor 2 / 3, Power BI Desktop, DAX Studio | Required |
Platform | Microsoft Fabric, Power BI Service (Premium / Fabric capacity) | Required |
Languages | DAX, T-SQL, M / Power Query | Required |
Databases | Microsoft SQL Server, Azure SQL | Required |
Model APIs | Tabular Object Model (TOM), XMLA endpoint | Required |
Security | Entra ID security groups, Row-Level Security | Required |
Source control / DevOps | Git, Azure DevOps, Fabric deployment pipelines | Preferred |
Governance | Data catalog / metric standardization tooling | Preferred |
Other | Python, Databricks, Snowflake, Alteryx, Tableau | Preferred |
Salary Range:
Actual salary commensurate with experience.
Working Conditions
Standard office / hybrid environment. Occasional after-hours work to support production model deployments and refresh windows.
Equal Employment Opportunity
UTMB Health strives to provide equal opportunity employment without regard to race, color, religion, age, national origin, sex, gender, sexual orientation, gender identity/expression, genetic information, disability, veteran status, or any other basis protected by institutional policy or by federal, state or local laws unless such distinction is required by law. As a Federal Contractor, UTMB Health takes affirmative action to hire and advance protected veterans and individuals with disabilities.
