Once Upon A Farm

Senior Business Intelligence Analyst

Remote

Not SpecifiedCompensation
Senior (5 to 8 years)Experience Level
Full TimeJob Type
UnknownVisa
Business Intelligence, AnalyticsIndustries

Requirements

Candidates should possess a bachelor's or advanced degree in information systems, analytics, computer science, data science, business, or a related field, or have equivalent years of experience. A minimum of 5 years of experience in data analytics, data science, business intelligence, or data engineering is required. Advanced skills in Power BI Desktop, Excel, SQL, and DAX are essential, along with expertise in the Microsoft data ecosystem including Power BI Premium, Fabric, and Azure. Familiarity with Power Query, SSMS, Tabular Editor, DAX Studio, Azure Data Factory, Azure SQL Database, and/or Fabric Notebooks is highly advantageous. Proficiency in Python or other predictive data modeling languages for AI/ML use cases is a plus, as are scripting abilities in C# and/or PowerShell. Solid knowledge of the Microsoft Suite, Outlook, and Slack is expected, and familiarity with Consumer Packaged Goods (CPG) data domains is beneficial.

Responsibilities

The Senior Business Intelligence Analyst will build advanced interactive reporting and dashboard solutions using Power BI and Excel, focusing on data visualization, DAX measure and KPI development, and navigation features. They will produce analytical reports and slide decks, incorporating data storytelling and business context to aid decision-making. The role involves building predictive data models and forecasts using various tools like SQL, Python, and Power BI. Responsibilities also include authoring SQL code for data transformation, assisting with data engineering pipelines in Azure, Fabric, and Fivetran, and supporting semantic modeling projects. The analyst will participate in data governance, master data management, and data stewardship by partnering with key individuals to optimize and harmonize data for analytics use cases.

Skills

Power BI
Excel
DAX
Data Visualization
KPI Development
Data Wrangling
Predictive Modeling
SQL
Data Engineering
Data Governance
Semantic Modeling
Reporting
Analytics

Once Upon A Farm

Organic meals and snacks for children

About Once Upon A Farm

Once Upon a Farm provides organic meals and snacks specifically designed for babies, toddlers, and young children. Their products include refrigerated pouches, oat bars, and frozen meals, which are delivered directly to customers' homes through a subscription service. This allows parents to customize their orders based on their children's needs. The company stands out from competitors by emphasizing organic farming practices and clean label certifications, which means their products have minimal exposure to pesticides and harmful chemicals. Once Upon a Farm's goal is to support healthy eating habits during the crucial first 1,000 days of a child's life, helping to develop their palate, reduce picky eating, and promote overall health and well-being.

Berkeley, CaliforniaHeadquarters
2015Year Founded
$82.8MTotal Funding
SERIES_DCompany Stage
Food & Agriculture, Consumer GoodsIndustries
51-200Employees

Benefits

Health Insurance
Dental Insurance
Vision Insurance
Life Insurance
Unlimited Paid Time Off
401(k) Company Match
401(k) Retirement Plan
Remote Work Options
Paid Volunteer Time
Paid Time Off to fulfill civic responsibilities
Flexible Spending Account/Flexible Spending Account
Employee Assistance Program
Paid Parental Leave
Monthly Cell and Internet Stipend
Employee Discounts
Annual Bonus
New Hire Remote Life Stipend
Wellness Program

Risks

Increased competition in the organic baby food market may impact market share.
Rising costs of organic ingredients could affect pricing strategies and profitability.
Economic downturns may reduce consumer spending on premium subscription services.

Differentiation

Once Upon a Farm offers cold-pressed, organic snacks for children, ensuring freshness.
Their subscription model provides convenience and customization for health-conscious parents.
Partnerships with regenerative farms emphasize sustainability and high-quality ingredient sourcing.

Upsides

Expansion into pantry snacks broadens their product range and market reach.
Collaborations with lifestyle brands enhance visibility and attract new customer segments.
Growing demand for clean label products aligns with their organic, non-GMO offerings.

Land your dream remote job 3x faster with AI