Medix Technology · 4 hours ago
Power BI - Backend Data Modeling Engineer - 249394
Medix Technology is currently seeking a highly technical Power BI - Backend Data Modeling Engineer for a contract position with one of their best retail pharmacy clients. This role focuses on developing the core data foundation and semantic data models that feed enterprise reporting, emphasizing back-end semantic modeling and data architecture.
Responsibilities
Leading the creation of new Power BI data architecture that relies on semantic modeling and certified datasets
Handling large, complex, multi-dimensional datasets involving HIPAA regulated Medicare/Medicaid data
Designing and implementing complex semantic data models in Power BI to bridge the gap between raw data and end-user self-service analytics
Working with SQL and BigQuery to write queries and manage data
Building and optimizing the data architecture and foundation - robust fact and dimension tables following a clean star schema model
Developing and maintaining certified datasets that serve as the single source of truth for the organization, reducing report redundancy (Power BI Endorsement)
Conducting performance optimization, focusing on the back-end of Power BI, optimizing model performance, data ingestion, and refresh speeds of the data
Acting as an individual contributor and project owner, helping to identify blind spots in the data and drive deliverables from the backlog with minimal oversight and guidance
Qualification
Required
Expertise in Data Modeling - seeking advanced knowledge of dimensional modeling, star schema, and handling large, complex, multi-dimensional datasets
Mastery of Back-End Power BI - seeking deep expertise in DAX, Power Query (M), and semantic modeling
SQL & BigQuery: Strong proficiency in writing complex SQL queries and managing data within BigQuery or similar cloud data warehouses
Data Governance: A commitment to data accuracy and governance over 'fancy visuals'
Strategic Thinking: Ability to look at data through a long-term lens to support a federated analyst corps and chatbot-driven analytics platforms
Communication: Ability to collaborate with cross-functional teams and transition technical requirements into a scalable data foundation