Data Officer

PFSCM; Woerden; On-site; EUR 42,000 - 65,000; Full time

Job summary

PFSCM, an affiliate of JSI, with an operational office in Woerden, NL, seeks a Data Officer to design, develop, and maintain Power BI dashboards and data models. You will write optimized SQL, enforce data accuracy, and collaborate with the Lead Data Analyst and stakeholders to turn data into actionable insights.

The role focuses on data quality, operational reporting, and ad-hoc data requests, while supporting SOPs and master data governance within a cross-functional team in the PMO-NL.

Qualifications

• Bachelor's degree or equivalent in a relevant field.
• 1–3 years in data analysis, master data management, or operations.
• Strong Excel, Power BI, and basic SQL skills; English communication.

Responsibilities

• Design, develop, and maintain Power BI dashboards and data models.
• Write optimized SQL queries and construct star schemas.
• Ensure data accuracy across reporting platforms.
• Support monthly/quarterly reporting and ad-hoc data requests.
• Maintain master data tables and data dictionaries.
• Document data methodologies and SOPs; assist with data quality initiatives.

Skills

Data analysis

Master data management

Business operations

Problem solving

Attention to detail

English communication

Education

Bachelor’s degree in Data Analytics, Business Administration, Computer Science, Economics, or related field

Tools

Excel

Power BI

SQL

Job description

The Partnership for Supply Chain Management Job Description

TITLE: Data Officer

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

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 Data Officer 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 Quality & Error Correction

• Perform routine and targeted data checks to identify discrepancies, missing values, duplicates, and process linkage errors across systems.
• Execute operational data corrections in collaboration with Finance, Logistics, Procurement, and PPM teams.
• Support organizational data quality initiatives by conducting periodic master data audits and enforcing consistent data entry standards.

Operational Reporting & Maintenance

• Assist in updating and maintaining standard operational reports, tracker spreadsheets, and existing Power BI dashboards.
• Extract and compile routine datasets using Excel and basic SQL queries to support ongoing departmental data requests.
• Assist in verifying monthly and quarterly reporting inputs prior to final aggregation.

Database & Process Support

• Support the maintenance of core master data tables and reference sets (e.g., lead time matrices, rate cards, item master data).
• Log recurring data issues and collaborate with technical analysts and business units to suggest workflow or system process improvements.
• Assist in documenting data methodologies, correction logs, and standard operating procedures (SOPs).

Ad‑Hoc Assistance

• Perform basic data extractions and exploratory checks for ad‑hoc requests as assigned by the Data Analytics & Reporting Manager.
• Provide general administrative and analytical support to the broader Data & Reporting unit.
• Other duties as assigned.

Qualifications

Professional and Technical Knowledge

• Bachelor’s degree in Data Analytics, Business Administration, Computer Science, Economics, or a related field (or equivalent combination of education and certified technical training).
• 1–3 years of hands‑on experience in data analysis, master data management, or business operations.
• Advanced proficiency in Microsoft Excel (pivot tables, VLOOKUP/XLOOKUP, data validation, complex formulas).
• Working knowledge of Power BI (navigating, updating, and basic report editing) and basic SQL querying capabilities (SELECT, WHERE, JOIN statements).
• Previous experience in supply chain, international logistics, or ERP environments is a plus.
• Strong logical thinking and systematic problem‑solving skills.
• Must be eligible to work in the Netherlands.

Interpersonal skills/Communication

• Good written and spoken English skills, with the ability to communicate data issues clearly to operational teams.

Priority Setting, Problem Solving, & Detail Orientation

• High level of accuracy and exceptional attention to detail.
• Strong team player willing to take ownership of operational data cleanup tasks.
• High attention to detail, analytical rigor, and solution‑oriented mindset.
  

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.