OpenDor Media is searching for a Data Analyst to cover a 6-month maternity leave, with the option to stay on long term, and keep the numbers our teams and funders rely on accurate, current and easy to use. You will answer data requests, build Looker Studio dashboards for fundraising, Unpacked for Educators, ConnectED and Amplified, and make sure the data in our BigQuery warehouse matches its sources. Every number you get right ends up in a real decision, a funder report, or a program that reaches more people.
OpenDor Media is a leading global non-profit media company for the 21st century. We educate, entertain, and engage our audiences by bringing to life big ideas and authentic stories, and by celebrating all things Jewish.
What you'll own
- Reporting and analysis. Answer data requests from fundraising, department heads and leadership, prepare the analysis behind organization-wide and grant reporting, and turn recurring asks into standing reports.
- Dashboards. Build and improve the Looker Studio dashboards teams use to track their own performance, including cross-divisional KPI views, and help colleagues find answers on their own.
- Data quality. Validate BigQuery tables and metrics against their source platforms, diagnose reporting bugs, and build corrected versions in the analytics layer for the warehouse team to apply.
- You have 3-5 years in data analytics, business intelligence or a related role.
- You have a bachelor's degree in data analytics, statistics, mathematics, computer science, economics or a related field, or equivalent practical experience.
- You're comfortable writing SQL in BigQuery or a similar cloud warehouse, including validatin