Senior Business Intelligence Analyst

Once Upon a Farm Logo

Once Upon a Farm

💵 $108k-$126k
📍Remote - Worldwide

Summary

Join our growing Business Intelligence & Analytics team and leverage your analytical skills to build interactive data products and reporting solutions. You will generate insights and predictions from data, develop user-facing reporting solutions, and provide analytics to executive audiences. Responsibilities include building interactive reports and dashboards using Power BI and Excel, producing analytical reports and slide decks, building predictive data models, authoring SQL code, and assisting with data engineering pipelines. You will also participate in data governance and semantic modeling projects. This role requires advanced Power BI, Excel, SQL, and DAX skills, as well as experience with the Microsoft data ecosystem. The ideal candidate will also possess strong data visualization and predictive modeling skills.

Requirements

  • A bachelor’s or advanced degree in information systems, analytics, computer science, data science, business, or any other relevant major, or equivalent years of experience
  • 5+ years of experience in any combination of data analytics, data science, business intelligence, data engineering, or equivalent roles
  • Advanced Power BI Desktop & Excel development skills
  • Advanced SQL & DAX skills
  • Expertise working within the Microsoft data ecosystem: Power BI Premium, Fabric, and Azure
  • Data visualization capabilities paired with a strong sense of graphic design (fonts, colors, labels, layouts)
  • Solid knowledge of Microsoft Suite, Outlook, Slack, and other professional platforms
  • Familiarity with Consumer Packaged Goods (CPG) data domains including sales, marketing, accounting, e-commerce, direct to consumer, co-manufacturing, sourcing, consumption & point of sale, forecasting (sales, demand, supply, financial), etc
  • Up to 10% travel required: Although this role is a remote work-from-home position, we “Farmers” do meet as a company and/or as a department at least once a year
  • Genuine passion for improving childhood nutrition for a healthier and happier planet
  • Desire to contribute to a dynamic, high-growth, purpose-driven work environment
  • Demonstrated ability to thrive in ambiguity, deeply understand business needs, develop a cohesive strategy, and make decisions requiring a high level of judgment
  • Must reside in the United States to be considered for this position
  • Please note that visa sponsorship is not available for this position

Responsibilities

  • Build advanced interactive reporting and dashboard solutions using your deep expertise in Power BI & Excel. Data visualization, DAX measure & KPI development, calculation groups, parameters, dynamic content: cross filtering, drill through, slicers, filters, bookmark & button navigation
  • Produce analytical reports and slide decks, utilizing narrative storytelling with data visualizations and layering in business context to assist with decision making
  • Build predictive data models and forecasts using SQL, Python, Fabric Notebooks, Power BI, Excel, and/or any other languages or tools of your choice (subject to approval)
  • Author SQL code to transform raw data into analytics-ready tables & views
  • Occasionally assist with building, monitoring, and maintaining data engineering pipelines in Azure, Fabric, and Fivetran
  • Occasionally assist with semantic modeling projects: star schema dimensional data modeling
  • Participate in data governance, master data management, and data stewardship by partnering with key individuals throughout the company who administer our various systems of record (Enterprise Resource Planning (ERP), Trade Promotion Management (TPM), Direct to Consumer (DTC), E-commerce, Point of Sale, Planning & Forecasts, etc.) to help optimize and harmonize data for analytics use cases

Preferred Qualifications

  • Familiarity with Power Query, SSMS, Tabular Editor, DAX Studio, Azure Data Factory, Azure SQL Database, and/or Fabric Notebooks is a huge plus
  • Proficiency in Python and/or any other predictive data modeling languages for AI/ML use cases is a huge plus
  • Scripting abilities C# and/or PowerShell are a plus
  • Previous exposure to cross-functional work between Sustainability and Business Intelligence preferred

Benefits

  • Full-Time, Salaried, Exempt
  • The anticipated salary range for this position is $108,800.00 to $126,208.00. The actual salary offer will carefully consider a few factors, including your skills, qualifications, experience, and location
  • Certain positions are eligible for additional forms of compensation such as bonuses, stipends, equity, and role-specific perks
  • 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 program, 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
  • Medical Insurance for the employee, covered at 100% on select plans with additional plan options at a reduced cost to the employee
  • Vision and Dental Insurance, covered at 100% for the employee and dependents
  • Life Insurance
  • Flexible Spending Account (Medical & Dependent Care) and Health Savings Account for applicable plans
  • Employee Assistance Program (EAP)
  • All other benefits, leaves, and insurance as required by law, based on your specific residence

Share this job:

Disclaimer: Please check that the job is real before you apply. Applying might take you to another website that we don't own. Please be aware that any actions taken during the application process are solely your responsibility, and we bear no responsibility for any outcomes.