SQL Power BI Analyst

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.

Overall responsibilities

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.

Specific responsibilities

Data Visualization & Reporting

• 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.

SQL Querying, Data Modeling & ETL

• 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.

Stakeholder Collaboration & Technical Analysis

• 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.

Data Integrity & Governance

• Conduct rigorous testing and validation of data outputs to ensure full accuracy before deploying dashboards.
• Align data structures with PFSCM’s overall Data Governance Framework and security access policies.
• Troubleshoot reporting errors, broken data feeds, or calculation discrepancies promptly.
• Other duties as assigned.

Professional and Technical Knowledge

• Bachelor’s degree in Computer Science, Data Analytics, Information Technology, Statistics, or a related field.
• 4+ years of dedicated hands-on experience in BI development, data visualization, and database querying.
• Expert-level proficiency in Microsoft Power BI (Desktop & Service), DAX, and Power Query.
• Advanced SQL skills (PostgreSQL, MySQL, T-SQL) with demonstrated ability to query large relational databases efficiently.
• Application of AI in reporting.
• Solid understanding of relational database design, star schemas, dimensional modeling, and data warehousing principles.
• Experience with supply chain, logistics, or ERP data environments is a strong advantage.
• Must be eligible to work in the Netherlands.

Interpersonal skills/Communication

• Excellent verbal and written English skills, with the ability to explain technical dashboard features clearly.

Priority Setting, Problem Solving, & Detail Orientation

• Strong problem-solving skills and rigorous attention to detail.
• Ability to prioritize tasks in a fast-paced, time-sensitive environment.

PFSCM is committed to providing equal employment opportunities for all qualified applicants and employees and to fostering a workplace free from discrimination. We believe in upholding the values of individual merit, hard work, and excellence, and we actively oppose any practices that promote illegal preferences or actions in hiring, contracting, or other employment decisions or practices. We strive to create an environment where every individual is treated with dignity and respect, and we are dedicated to promoting a culture that recognizes and rewards individual initiative and achievements.