Main areas of focus: Data Analyst, Data-driven business strategy, Water, Sanitation, and Hygiene
Location: This opportunity is for those located in the New York City area only. Applicants must be eligible to work in the U.S. or have an existing U.S. work permit.
As the part-time Data Visualization Analyst, you’ll assist the Monitoring and Evaluation team with data processing and visualization for key performance indicators and metrics collected from global water, sanitation, and hygiene (WASH) programs. You will design and implement dashboards that enable internal and external partners to access and explore data coming from global field teams. You will work cross-departmentally to determine the main focus areas of data visualization that are important for team success.
This will be a part-time contracted position, divided into three main phases, with the potential option for, but no guarantee of, renewal.
YOU’LL BE RESPONSIBLE FOR…
Phase I – Data Processing
- Transforming survey data sets into formats ready for import into an AWS Redshift database.
- Data consists of survey data collected from mobile devices, in addition to metadata about the locations surveyed.
- Creating and/or updating documentation to capture current business rules about data cleaning processes.
- Suggesting modifications to the current data cleaning and processing methods to streamline and automate steps where possible.
Phase II – Static Data Views
Working with key stakeholders to identify static data visualization needs and create these views.
- Meeting with internal team members to determine questions to be answered through data visualizations to inform internal decision-making about WASH programs and funding.
- Designing a survey or interview for external charity: water partner organizations to determine questions to be answered through data visualizations to inform implementation decisions.
- Working with the Monitoring and Evaluation team to interpret this information, and create visualizations within Looker and/or Klipfolio systems for both internal and external use.
Phase III – Dynamic Data Views
- Building upon Phase II, establishing additional dynamic, exploratory data views that create dynamic visualizations to enable internal team members to investigate different connections.
- Working closely with the Monitoring and Evaluation team to investigate specific data questions, as needed – including data aggregation for more advanced analysis.
- Liaising with the Database Administrator and/or Software Engineering team on Water Programs-related data infrastructure work at the organization level.
YOU MUST HAVE…
- A Bachelor's degree in a quantitative field such as mathematics, statistics, computer science, data science, or other relevant fields
- 5+ years of hands-on experience in data visualization, analytics, or business intelligence
- Excellent conceptual and analytical reasoning competencies
- Experience successfully utilizing data visualization software Looker, and a strong understanding of the importance of aesthetics when communicating results visually
- Strong analytic SQL skills and experience working with traditional relational databases and columnar-databases such as AWS Redshift
IT’S AN ADDED PLUS IF YOU HAVE…
- Experience successfully utilizing Looker and Klipfolio as data visualization tools
- Proven knowledge of programming languages especially R and Python
YOU’LL BE SUCCESSFUL IF...
You're a problem solver and strategic thinker
We find ways of getting it done. You know how to articulate and roll out solutions, recognizing there are many approaches to the same problem. You find new and effective ways to streamline and create processes to increase efficiency.
You’re a great communicator
You are great at sharing insights both verbally and written; but what you love to do is apply real context to findings so that stakeholders understand what it means for them and also how it impacts our strategy.
You're not only driven -- you can drive your own boat
You can work independently and you know when to ask critical questions to get to the root of a problem. You're a self-starter -- even if no one else were in the office, you'd work just as hard and just as meticulously.
You are passionate about your work and what it means
You’re a fast learner and interested in understanding the topic areas of water, sanitation, and hygiene (WASH).
The Water Programs team works closely with our local partners: vetting, managing, and monitoring the programs we fund and acquiring the information we need to report back to our donors. The Water Programs team manages approximately $70 million in donor dollars in 22 countries (and growing) each year. They are the protectors of our transparency pillar - ensuring our partners continue to meet our sustainability and reporting requirements.
At charity: water, our team of world chargers believe that water changes everything. As a non-profit organization, we work to bring sustainable solutions, providing clean and safe drinking water, to those in developing countries. In 13 years, we’ve been able to bring healthier living conditions to over 10 million people in 28 countries. With the inner makings of a mid-size tech startup, we’re reinventing charity through endless innovation and contagious passion. When we’re not eating pizza, gathering for Bagel Breakfasts, or Friendsgiving Feasts, we’re working side-by-side to create beautifully crafted stories and a powerful brand that inspires a whole new kind of generosity.