Junior Data Engineer

Job Description

DESCRIPTION PFSCM strengthens, develops, and manages secure, reliable, cost-effective, and sustainable global supply chains to improve the health and well-being of people in low- and middle-income countries through increased access to quality and affordable health products. We help governments, non-profit organizations, and humanitarian agencies to achieve their public health goals through cost-saving procurement, efficient logistics, pharma-grade storage, last-mile delivery solutions, and real-time data tracking. PFSCM demonstrates its commitment to customer satisfaction and service excellence by upholding an ISO 9001:2015 certified Quality Management System that underpins all our processes, systems, and services.

PFSCM is a subsidiary of one of the leading international health consultancy organizations in the US — JSI Research & Training Institute, Inc. (JSI). In addition to our project management headquarters in Washington D.C., in the U.S., and our operational facility in Woerden, in the Netherlands, we have access to 50 other JSI offices around the world.

Within PFSCM’s global structure, approximately 90 seconded staff members from more than 35 countries contribute to the impact achieved through PFSCM’s services. PFSCM’s diversity of thought and culture allows us to engage fully with our clients and each other. We believe we can achieve our mission by upholding our purpose- and results-driven cultural style. We do this by creating an environment where staff can demonstrate our cultural values of collaboration, learning, proactivity, problem solving, and outcome orientation on a daily basis. RESPONSIBILITIES The Jr. Data Engineer is responsible for supporting the design and development of PFSCM’s data warehouse (DWH) environment including integrating data from various systems and platforms into PFSCM DWH. The Jr. Engineer is expected to work with senior DWH team members to help address DWH development and report backlog, as well as troubleshoot data quality issues. The Jr. Engineer will follow best practices in testing and development while contributing to an ongoing effort to refine data infrastructure and monitoring initiatives.

SPECIFIC RESPONSIBILITIES:

• Address DWH technical development working with supply chain operations, performance management & analytics, 4PL services, and finance & accounting teams.
• Enhance data quality monitoring by updating “Data Checks” report, and consolidate tracking of overall data quality to enhance client reporting.
• Contribute to our suite of reports and data products while collaborating with business analysts, product owners, and other team members, including UAT and support for technical testing.
• Work closely with senior team members in optimizing DWH performance and design, including outlining options to improve resilience.
• Explore ways to enhance data quality and reliability.
• Contribute to DWH architecture and report documentation.

QUALIFICATIONS Professional and Technical Knowledge

• Bachelor’s degree in Computer Science, Information Technology, Applied Math, or equivalent experience.
• Some experience or familiarity with MS SQL server and SSIS development experience.
• Familiarity with data warehousing, data marts, and OLAP.
• Familiarity with ETL processes and data integration for use of required BI tooling required, along with report drafting with SSRS and Power BI.
• Familiarity with Jira is a plus.
• Willingness and availability to travel, and perform other duties as needed.
• Must be eligible to work in US or the Netherlands.

Interpersonal skills/Communication

• Excellent written/verbal communication and interpersonal skills with strong sense of customer English fluency required, including speaking, writing, understanding, and reading.

Priority Setting, Problem Solving, & Detail Orientation

• Ability and desire to learn new languages and technologies.
• Strong organization skills with demonstrated analytical skills, eye for details, ability to plan, prioritize, and implement day-to-day operations in a timely manner in a fast moving, dynamic and time-bound environment

Location of the position can be based in Arlington, VA, U.S. or Project Management Office, Woerden, The Netherlands

Salary commensurate with experience.

About the Organization

John Snow, Inc., and our nonprofit JSI Research & Training Institute, Inc., are public health management consulting and research organizations dedicated to improving the health of individuals and communities in the US and around the Globe.

JSI's mission is to improve the health of underserved people and communities and to provide a place where people of passion and commitment can pursue this cause.

For over 35 years, JSI and our affiliates have provided high-quality technical and managerial assistance to public health programs worldwide. JSI has implemented projects in 106 countries, and currently operates from eight U.S. and more than 40 international offices, with more than 500 U.S.-based professionals and 1,600 host country staff.