Business Intelligence Analyst & Developer

OpenDor Media

89d • $100,000 - $110,000

About The Position

OpenDor Media (ODM) is on the lookout for a Business Intelligence Analyst & Developer (BI) to empower us to make informed data-driven decisions by transforming complex datasets into actionable insights. You will design, develop, and maintain dashboards and reporting tools that enable all business units - from marketing and content to operations and fundraising - to monitor performance, uncover trends, and optimize strategies. You will collaborate closely with IT, Finance, Marketing, Fundraising and other cross-functional teams to ensure high quality, accurate data is accessible for business intelligence purposes. This is a remote position reporting directly to our Creative Director.

Requirements

• 5+ years in data analytics, business intelligence, or related roles.
• Strong expertise in SQL and Python for data analysis and manipulation.
• Proficiency in BI and visualization tools such as Looker Studio, Tableau, or Power BI.
• Experience with cloud-based data platforms (Google Cloud, BigQuery).
• Advanced Excel skills for complex data analysis.
• Experience with CRM systems, preferably Salesforce.
• Excellent analytical, problem-solving, and project management skills.
• Ability to communicate insights clearly to technical and non-technical stakeholders.
• Highly inquisitive and self-motivated.

Nice To Haves

• Experience with survey tools (SurveyMonkey, Google Forms) and social media analytics.
• Data engineering or scripting experience for ETL and database management.
• Familiarity with QuickBooks or other financial systems.

Responsibilities

• Develop, maintain, and optimize dashboards and reports across departments using BI and CRM tools.
• Monitor and analyze KPIs, trends, and performance metrics to guide business strategy.
• Conduct ad-hoc analysis to support incoming decision-making needs.
• Suggest KPIs that represent value-drivers of the business.
• Manage and maintain data warehouse and data lake environments (Google Cloud, BigQuery).
• Ensure data accuracy, consistency, and integrity across multiple sources.
• Collaborate with IT and data engineering teams to implement and maintain ETL pipelines and analytics infrastructure.
• Partner with fundraising, marketing, operations, content, and finance teams to understand data needs and deliver insights.
• Provide actionable recommendations and support data-driven decision-making across the organization.
• Assist in the implementation of analytics tools, tracking tags, and CRM integrations (Salesforce).
• Conduct CRM maintenance and general systems management, debugging and cleaning data, to ensure accurate reporting.
• Lead or participate in analytics projects from ideation through implementation.
• Coordinate multiple projects simultaneously while meeting deadlines.
• Document BI processes, data definitions, and reporting standards for consistency.
• Collaborate with Content Data Specialist to analyze content data for integrated performance insights.
• Survey creation, management and reporting.
• Support financial reporting through integration with tools like QuickBooks.

Benefits

• International exposure
• High level of autonomy
• Competitive salaries
• Paid days off for Jewish & national holidays as well as competitive vacation policy
• Healthcare policy if employed outside of Israel
• Great company culture and colleagues

What This Job Offers

• Number of Employees: 11-50 employees