Job details
- Location
- USA
- Work type
- Onsite
- Posted
- today
- Apply on
- opendormedia.org
About this role
OpenDor Media is searching for a Jr. 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.
## Requirements
- 3-5 years in data analytics, business intelligence or a related role.
- A bachelor's degree in data analytics, statistics, mathematics, computer science, economics or a related field, or equivalent practical experience.
- Comfortable writing SQL in BigQuery or a similar cloud warehouse, including validating data across sources and schema design.
- Confident working in Looker Studio or similar BI tools, advanced Excel, and a CRM, ideally Salesforce.
- Already use AI tools like Claude in day-to-day analytical work.
- Analytical, organized, and good at seeing a project through from request to delivery.
- Able to explain what the numbers mean to technical and non-technical people alike.
- Curious and self-motivated.
- Available full time for a 6-month maternity cover, with the option to continue long term, working remotely with no travel required.
## Bonus points for
- Social media analytics
- ETL, Python or scripting experience
- Experience reporting against grant or funder commitmentsNone of these are required.
## What we're looking for
- A stickler for accuracy. You check numbers against the source, and you notice when something doesn't add up.
- Someone who closes the loop. When the same request comes in twice, your instinct is to turn it into a standing report so nobody has to ask a third time.
- A good detective. When a report looks off, you dig in until you find out why.
- Quick to get up to speed. You're comfortable picking up existing dashboards and processes and running with them from the first weeks.
Ready to apply to OpenDor Media?
ApplyBolt finds matching jobs, tailors your resume, and submits applications for you.