Lead Data Analyst

Partnership for Supply Chain Management, Inc.; Netherlands; Remote; EUR 75,000 - 110,000; Full time

Job summary

The Partnership for Supply Chain Management, Inc. is seeking a Lead Data Analyst to drive complex analytics projects, oversee dashboard architecture, and mentor junior team members within the Data Analytics & Reporting unit at the Woerden PMO.

You will ensure high data quality and governance across organizational reporting. The role emphasizes collaboration with internal teams and external donors, applying SQL, Python/R, and advanced Power BI skills to deliver narrative data stories and

Qualifications

• Bachelor’s degree in data analytics, statistics, CS, or related field; Master’s preferred.
• 5+ years of progressive experience in data analytics, BI, and reporting in international supply chain or global health.
• Expert knowledge of Microsoft Power BI (Desktop and Service), advanced DAX, and Power Query.
• Strong SQL skills (PostgreSQL/MySQL/SQL Server) and relational modeling.
• Familiarity with Python or R is desirable.
• Experience with data warehousing, ETL pipelines, and ERP systems.
• Ability to provide technical direction, coordinate project delivery, and mentor junior colleagues.
• Must be eligible to work in the Netherlands.

Responsibilities

• Serve as the primary technical reference point for the data analyst team and mentor members.
• Manage analytics projects, ensuring timely delivery and quality standards.
• Translate business requirements into detailed technical specs for dashboards and data structures.
• Architect, build, and maintain scalable Power BI dashboards and visuals.
• Conduct exploratory data analysis to identify trends and bottlenecks.
• Synthesize findings into narrative reports for stakeholders and leadership.
• Partner with IT to design data warehouse schemas and data pipelines.
• Enforce data governance, QA, and documentation across dashboards.
• Support monthly, quarterly, and annual performance metrics for management and donors.

Skills

Power BI expertise

SQL querying

Data analytics

Stakeholder collaboration

Mentoring

Education

Bachelor’s degree in Data Analytics/Statistics/CS

Master’s degree preferred

Tools

Power BI

PostgreSQL/MySQL/SQL Server

Python or R

ETL / Data warehouse concepts

Python or R

ETL pipelines

Data warehouse concepts

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.