Power BI - Backend Data Modeling Engineer

Job Title: Power BI - Backend Data Modeling Engineer
Duration: 12 months
Work Location: 100% Remote - EST/CST Hours

ABOUT OUR CLIENT / ABOUT THE ROLE

Medix is currently seeking a highly technical Power BI - Backend Data Modeling Engineer for a contract position with one of our best retail pharmacy clients.

This individual will be focused on developing the core data foundation and semantic data models that feed enterprise reporting. Unlike traditional dashboard developers who focus on the User Interface Dashboards, this role is dedicated to 100% back-end semantic modeling, data architecture, and the creation of certified datasets.

You will be instrumental in creating next generation reporting capabilities by moving away from legacy, query-heavy reports toward a scalable, efficient semantic layer.

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

REQUIRED SKILLS & QUALIFICATIONS

• 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

For California Applicants:

We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable federal, state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance (FCIHO), Los Angeles Fair Chance Ordinance for Employers (ULAC), The San Francisco Fair Chance Ordinance (FCO) , and the California Fair Chance Act (CFCA).

This position is subject to a background check based on its job duties, which may include patient care, working with vulnerable populations, access to financial and confidential information, driving, working with heavy machinery, or working in a warehouse or laboratory environment. Due to these job duties, this position has a significant impact on the business operations and reputation, as well as the safety and well-being of individuals who may be cared for as part of the job position or who may interact with staff or clients.