Data Analyst

Description

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.

Requirements

• 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 validating data across sources and schema design.
• You work confidently in Looker Studio or similar BI tools, advanced Excel, and a CRM, ideally Salesforce.
• You already use AI tools like Claude in your day-to-day analytical work.
• You're analytical, organized, and good at seeing a project through from request to delivery.
• You can explain what the numbers mean to technical and non-technical people alike.
• You're curious and self-motivated.
• You're 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 commitments

None of these are required.

What You Have:

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.

Who We Are:

OpenDor Media provides inspiring and informative content on all issues relating to Judaism and Israel, and those that affect young Jews today. We are proudly and transparently positive about Israel and Zionism, Jewish values and ideals. We celebrate the riches of Jewish and Israeli history and culture. We do so in a voice which is authentic, credible and therefore trusted. We embrace complexity and recognize and give voice to multiple perspectives on difficult issues. We push the boundaries of innovation, creativity and good old hard work. From our leadership team to new and veteran team members, we all strive to embody our core values:

• Fueled by creativity: We think and act creatively in everything we do, with the agility and flexibility to apply creativity whatever role we play.
• Inspired by excellence: We are driven to excel at whatever we do. Our teams are always ready to go the extra mile to get the very best results.
• Powered by positivity: We bring positivity to work every day, for a fun, creative and inviting work environment that brings out the best in everyone.
• Driven by self-improvement: Like our content, no issue is taboo, and we are open to constructive ways to improve and develop into the best professionals we can be.
• Empowered by collaboration: We thrive on sharing knowledge, teamwork, being a "mensch," and leveraging everyone's talents to achieve a sum greater than the parts.

Benefits

Some benefits and perks of working at OpenDor Media

• International exposure and a genuinely global team
• High level of autonomy and direct access to leadership and the Board
• Competitive salary
• Paid days off for Jewish and national holidays, plus a competitive vacation policy
• Healthcare coverage
• Great company culture and colleagues

Salary

Our target salary range for this position is $65,000 to $70,000 annually for a U.S.-based candidate. The final salary will be determined based on careful consideration of several factors, including the candidate's location, experience in similar roles, and expertise related to the qualifications above.