Jr. Data Analyst (Temporary-Mat Leave Coverage)

OpenDor Media • New York, NY

5d • $65,000 - $70,000 • Remote

About The Position

OpenDor Media is hiring a Jr. Data Analyst to provide coverage for a six-month maternity leave, with the option to continue long term. The role helps keep data accurate, current, and accessible for internal teams and funders. It responds to data requests, builds and improves Looker Studio dashboards for fundraising, Unpacked for Educators, ConnectED, and Amplified, and validates that BigQuery warehouse data matches its source platforms. The work supports organizational decisions, funder reporting, and program delivery.

The analyst prepares analysis for organization-wide and grant reporting, turns recurring requests into standing reports, and creates cross-divisional KPI views so colleagues can find answers independently. The role also investigates reporting issues and develops corrected versions of data in the analytics layer for the warehouse team to apply. This is a full-time, remote position with no travel required.

Requirements

• 3–5 years of experience in data analytics, business intelligence, or a related role.
• Bachelor's degree in data analytics, statistics, mathematics, computer science, economics, or a related field, or equivalent practical experience.
• Comfort writing SQL in BigQuery or a similar cloud warehouse, including validating data across sources and schema design.
• Confidence using Looker Studio or similar BI tools, advanced Excel, and a CRM; Salesforce is preferred.
• Use of AI tools such as Claude in day-to-day analytical work.
• Analytical, organized, and able to see projects through from request to delivery.
• Ability to explain what numbers mean to technical and non-technical audiences.
• Curiosity and self-motivation.
• Availability to work full time for a six-month maternity cover, with the option to continue long term.
• Ability to work remotely with no travel required.
• Attention to accuracy, including checking numbers against source data and identifying discrepancies.
• Ability to investigate reporting issues and identify their causes.
• Ability to quickly take over existing dashboards and processes.

Nice To Haves

• Social media analytics experience.
• ETL, Python, or scripting experience.
• Experience reporting against grant or funder commitments.

Responsibilities

• Respond to data requests from fundraising, department heads, and leadership.
• Prepare analysis for organization-wide and grant reporting.
• Turn recurring data requests into standing reports.
• Build and improve Looker Studio dashboards, including cross-divisional KPI views.
• Help colleagues use dashboards to find answers independently.
• Validate BigQuery tables and metrics against source platforms.
• Diagnose reporting bugs and create corrected analytics-layer versions for the warehouse team to apply.

Benefits

• 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.
• Company culture and colleagues described as great.

What This Job Offers

• Career Level: Entry Level