Business Intelligence Analyst & Developer
Description 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. What You’ll Do: Analytics & reporting • 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 • Data management • 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. Cross-functional support • 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. Project & process management • 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. Optional / value-add responsibilities • 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. • Requirements What You Have: • 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. Bonus Points for: • 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. 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 each and everyone’s talents to achieve a sum that is greater than the parts. Some benefits and perks of working at OpenDor Media: • 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 Salary Our target salary range for this position when based in New York is $100,000 to $110,000 annually. In Israel, the salary range is 23,000 - 25,000 NIS/month. The final salary for this role will be determined based on careful consideration of a variety of factors, such as the candidate's exact location, experience in similar roles, and expertise related to the qualifications. Apply tot his job