SQL Power BI Analyst

The Partnership for Supply Chain Management Job Description

TITLE:

SQL Power BI Analyst

REPORTS TO:

Data Analytics and Reporting Manager

LOCATION:

Project Management Office, Woerden, NL (PMO-NL)

STATUS:
Full-time

Organization description

The Partnership for Supply Chain Management (PFSCM) focuses on strengthening and managing secure, reliable, cost-effective, and sustainable global supply chains to enhance health and well-being in low- and middle-income countries by increasing access to quality and affordable health products. We assist governments, non-profit organizations, commercial firms, and humanitarian agencies in achieving their public health objectives through cost-saving procurement, efficient logistics, pharma-grade storage, last-mile delivery solutions, and real-time data tracking.

PFSCM is dedicated to customer satisfaction and service excellence, which is reflected in our adherence to an ISO 9001:2015 certified Quality Management System and alignment with ISO 20400 for Sustainable Procurement, which underpins all our processes and services.

PFSCM, an affiliate of JSI Research & Training Institute, Inc. (JSI), a leading international public health and education consultant company in the U.S., operates from its project management headquarters in Washington D.C., and has an operational facility in Woerden, Netherlands. Additionally, we leverage the extensive network of 25 JSI offices around the world, allowing us to access their technical and operational expertise.

PFSCM's global team includes a diverse array of professionals from various countries who contribute to the effectiveness of our services. This diversity enriches our ability to connect with clients and collaborate internally. We believe our mission can be achieved by fostering a purpose- and results-driven culture. We strive to create an environment where our values of collaboration, learning, proactivity, problem-solving, and outcome orientation are reflected in our daily work.

Designs, develops, and maintains interactive Power BI dashboards, reports, and underlying data models to convert raw supply chain and operational data into actionable business insights. The SQL Power BI Analyst works closely with the Lead Data Analyst and business stakeholders to write optimized SQL queries, construct star-schema data models, build complex DAX measures, and enforce data accuracy across internal and external reporting platforms.

• Design, construct, publish, and maintain visually compelling, intuitive Power BI dashboards and executive reports.
• Establish standardized visual layouts and user-friendly interface designs that facilitate data exploration for non-technical users.
• Maintain and refresh existing enterprise reports, optimizing performance and query speeds.

• Write, test, and optimize complex SQL queries, views, and stored procedures to extract and transform data from relational databases and data warehouses.
• Connect Power BI to diverse data sources, utilizing Power Query and Power Automate for robust Data Transformation and Data Cleaning (ETL).
• Develop robust relational data models within Power BI, utilizing star schemas, relationships, and advanced DAX measures/calculated columns.

• Gather and refine reporting requirements from business units (Logistics, Sourcing, Finance, QA), translating them into functional technical specs.
• Conduct variance analysis, trend modeling, and KPI tracking to support operational efficiency initiatives.
• Assist users across the organization by providing technical training and documentation on published Power BI reports.

• Conduct…