Lead Data Analyst

pfscm; Woerden; On-site; EUR 70,000 - 110,000; Full time

Job summary

The Partnership for Supply Chain Management (PFSCM) seeks a Lead Data Analyst to act as senior technical authority in the Data Analytics & Reporting unit. The role drives complex analytics projects, dashboards, and data standards while mentoring junior team members.

You will work on scalable Power BI solutions, data governance, and collaboration with cross-functional stakeholders to deliver high-quality reporting for donors and operations in Woerden, NL.

Qualifications

• Bachelor’s or higher in a quantitative field; Master’s preferred.
• 5+ years of progressive experience in data analytics, BI, and reporting.
• Expert knowledge of Power BI (Desktop and Service), advanced DAX, and Power Query.
• Strong SQL skills and relational modeling. Familiarity with Python or R is desirable.
• Experience with data warehouse concepts, ETL, and ERP systems.
• Eligible to work in the Netherlands.

Responsibilities

• Serve as the senior technical authority and coordinate delivery of analytics projects.
• Architect, build, and maintain Power BI dashboards and data visualizations.
• Define data standards, governance, and QA across dashboards.
• Collaborate with IT/Data Engineering to optimize data warehouses and data pipelines.
• Support performance measurement and reporting for internal stakeholders and donors.

Skills

Data analytics

Mentoring

Project coordination

Stakeholder collaboration

Communication skills

Education

Bachelor’s degree in Data Analytics/Statistics/CS

Master’s degree preferred

Tools

Power BI

DAX

Power Query

SQL (PostgreSQL/MySQL/SQL Server)

Python/R

Data warehouse concepts

ETL pipelines

ERP systems

Job description

The Partnership for Supply Chain Management Job Description

TITLE: Lead Data 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.

Overall responsibilities

Serves as the senior technical authority and operational coordinator within the Data Analytics & Reporting unit. The Lead Data Analyst drives the execution of complex analytics projects, oversees dashboard architecture, establishes technical standards (SQL, DAX, Python/R), and mentors junior team members. While not holding formal people-management responsibilities, this position guides daily workflows and ensures high data quality and analytical rigor across all organizational reporting.

Specific responsibilities

Technical Guidance & Delivery Coordination

• Serve as the primary technical reference point for the data analyst team, performing code reviews (SQL/DAX), setting data modeling standards, and mentoring team members.
• Manage the technical execution of analytics projects assigned by the Data Analytics & Reporting Manager, ensuring delivery timelines and quality standards are met.
• Translate complex business requirements from operational units into detailed technical specifications for dashboards and data structures.

Dashboard Architecture & Advanced Analytics

• Architect, build, and maintain scalable, high-performance dashboards and data visualizations in Power BI.
• Conduct exploratory data analysis to identify hidden trends, supply chain bottlenecks, and operational anomalies.
• Synthesize technical findings into narrative-driven visual reports for cross-functional stakeholders and senior leadership.

Data Architecture Support & Quality Governance

• Partner with IT and Data Engineering to design optimal data warehouse schemas, star schemas, and data pipelines that support analytics.
• Enforce data validation controls, documentation practices, and quality assurance (QA) protocols across all public and client-facing dashboards.
• Serve as a key gatekeeper for data governance, ensuring consistent data definitions and table usage across departments.

Performance Measurement & Stakeholder Collaboration

• Support the compilation, verification, and presentation of monthly, quarterly, and annual performance metrics for internal management and external donors (e.g., The Global Fund).
• Collaborate with OpEx and business units to align operational processes with underlying data structures.
• Support the development of new performance measures for expanding or evolving client scopes.
• Other duties as assigned.

Qualifications

Professional and Technical Knowledge

• Bachelor’s degree in Data Analytics, Statistics, Computer Science, Information Systems, or a related quantitative field; Master’s degree preferred.
• 5+ years of progressive experience in data analytics, business intelligence, and reporting, ideally within an international supply chain or global health environment.
• Expert knowledge of Microsoft Power BI (Desktop and Service), advanced DAX, and Power Query.
• Strong proficiency in writing complex SQL queries (PostgreSQL, MySQL, or SQL Server) and relational database modeling.
• Familiarity with programming languages for analytics (Python or R) is highly desirable.
• Demonstrated experience in data warehouse concepts, ETL pipelines, and ERP systems.
• Proven ability to provide technical direction, coordinate project delivery, and mentor junior colleagues.
• Must be eligible to work in the Netherlands.
  

Interpersonal skills/Communication

• Strong written and verbal English communication skills; ability to interact comfortably across multi-cultural teams.
• Willingness to take decisions and gather buy-in from stakeholders.
• Strong team player willing.
• Supportive and collaborative in interpersonal relationships.
  

Priority Setting, Problem Solving, & Detail Orientation

• High attention to detail, analytical rigor, and solution-oriented mindset.
• Ability to manage competing priorities and expectations.
  

Disclaimer:

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.

If you are an individual with a disability or a disabled veteran and unable to apply online for an available position, you may submit your request for reasonable accommodation by calling Human Resources at 617-482-9485.