Director of Business Intelligence and Analytics

Summary

Join Once Upon a Farm as their Director of Business Intelligence & Analytics, leading the organization's data and analytics strategy. You will develop and implement comprehensive data strategies, manage data governance, and lead a high-performing data team. Responsibilities include automating data processing and reporting, collaborating with various business units, and deploying BI solutions. The ideal candidate possesses a Bachelor's degree, 5+ years of experience in data analytics and BI strategy, and advanced proficiency in Power BI and Azure data solutions. This remote-first position offers a competitive salary, annual bonus, comprehensive benefits package, and a supportive work environment.

Requirements

• A Bachelor’s degree in Computer Science, MIS, Mathematics, Data Science, Data Analytics, or a related field, or equivalent years of experience, is required
• A minimum of 5 years of experience in data analytics and BI strategy, preferably as a leader in mid-size companies, with a proven track record of building and developing high-performing teams
• A minimum of 5 years of experience in data modeling, metadata management, and data dictionary development is required, along with 2-3 years working with Azure data solutions, including Azure SQL, Microsoft Fabric, and the broader Microsoft Technology Stack
• Advanced proficiency in Power BI, including semantic modeling, self-service dashboards, and automated reporting workflows, is essential
• Strong knowledge of data architecture and modeling, with expertise in creating normalized and denormalized data structures for efficient query performance, is required
• Proficiency in SQL, DAX, and preferably Python or PowerShell, with experience in automating data handling and reporting processes
• Hands-on experience with Azure Data Warehousing solutions, ensuring scalability, performance, and availability, and strong skills in data integration and ETL processes using Microsoft Fabric, integrating multiple data sources (cloud and on-premises)
• Prior exposure to predictive analytics, AI-driven insights, and their application in guiding business strategy and operations
• A strong understanding of regulatory compliance standards and data governance, is essential
• Exceptional leadership, communication, and interpersonal abilities
• Strong problem-solving and decision-making skills, with the ability to turn complex data into actionable insights
• Excellent presentation skills, with the ability to communicate technical concepts clearly to non-technical stakeholders, are essential
• Must reside in the United States to be considered for this position

Responsibilities

• Develop and implement a comprehensive data strategy aligned with organizational goals, focusing on driving innovation, operational efficiency, and competitive advantage
• Establish and enforce data governance policies to ensure data quality, security, and compliance with regulations such as GDPR and CCPA
• Manage reliable data pipelines using Azure Data Warehouse, Microsoft SQL, and Microsoft Fabric to integrate data sources efficiently and maintain governance across platforms
• Lead initiatives to automate data processing and reporting, particularly in financial and accounting areas, by designing and deploying self-service reporting frameworks in Power BI
• Translate complex business requirements into scalable, automated reporting solutions that support business objectives and enable on-demand insights for stakeholders
• Partner with business units such as Finance, Sales, Marketing, and Operations to ensure alignment between data initiatives and business goals
• Foster a data-driven culture by implementing user-friendly reporting tools that promote self-service and democratize data across the organization
• Leverage expertise in Sage X3 ERP to streamline data integration and optimize workflows
• Lead the deployment of business intelligence solutions, integrating tools like Power BI into business workflows to drive high-impact use cases
• Continuously monitor and optimize analytics models for performance, scalability, and accuracy
• Evaluate and implement advanced analytics and ML/AI technologies to enhance organizational capabilities and improve decision-making processes
• Build and manage a high-performing data team, fostering a culture of innovation, collaboration, and professional growth
• Advocate for data literacy and provide training resources to empower employees to make informed, data-driven decisions
• Champion the adoption of advanced analytics and BI tools to uncover business opportunities and address challenges
• Establish metrics to track the success of data initiatives and present insights, trends, and recommendations to senior leadership to inform decision-making and drive organizational goals

Preferred Qualifications

• Experience with ERP systems, particularly Sage X3, is preferred to enable deeper integration and streamlined workflows
• Prior experience with investor communications, including preparing investor presentations and reports, and cross-functional experience in Sustainability, Finance, and Analytics, is an advantage
• Solid knowledge of Microsoft Suite, Outlook, Slack, and other professional platforms
• Genuine passion for improving childhood nutrition for a healthier and happier planet
• Desire to contribute to a dynamic high-growth, purpose-driven work environment

Benefits

• Remote-first work environment
• Annual Bonus
• 401(k) program + 4% company match after three months
• New Hire Remote Life Stipend + annual Nourish and Nurture Allowance
• Monthly Cell and Internet Stipend
• Quarterly Farm-to-Fridge home deliveries and Employee Discounts
• New Parents: Up to 18 weeks of paid Parental Leave, Baby Steps Back To Work, 3 months’ supply of Once Upon A Farm products, and breast milk shipping service and support for those who travel after birth for the duration of your breastfeeding journey
• Unlimited Paid Time Off
• Paid Volunteer Time
• Paid Time Off to fulfill civic responsibilities including jury duty and voting in local, state, and national elections