Who You Are:
You are an analytical thinker with a knack for visualizing and finding patterns in data. You enjoy building and creating interactive data products and reporting solutions. You are experienced in wrangling disparate data sources to paint a complete picture of enterprise activity. You know how to make predictions and forecast the future using historical data. You’re capable of making critical business observations using data, and you are eager to present your findings to help executive audiences make great business decisions.
The Task At Hand:
You will be joining our small but growing Business Intelligence & Analytics team with a focus on generating insights and predictions from data, as well as developing user-facing front-end reporting solutions. Our team is responsible for the full data & analytics stack, including data ingestion, data transformation, semantic modeling, statistical & predictive modeling, reporting, and analytics. Your focus will be on creating interactive reporting and dashboard solutions for specific business audiences, as well as providing analytics to executive audiences by request. Our team is very cross-functional, and you may have the opportunity to assist with various data engineering, SQL development, data governance, and semantic modeling activities. Your primary focus will be on developing departmental and enterprise reporting solutions and providing predictive & prescriptive analytics for business leaders.
In This Role, You Will:
- 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
In This Role, You’ll Bring With You:
- 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
- Familiarity with Power Query, SSMS, Tabular Editor, DAX Studio, Azure Data Factory, Azure SQL Database, and/or Fabric Notebooks is a huge plus
- Data visualization capabilities paired with a strong sense of graphic design (fonts, colors, labels, layouts)
- 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
- 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
- Previous exposure to cross-functional work between Sustainability and Business Intelligence preferred
- Must reside in the United States to be considered for this position
- Please note that visa sponsorship is not available for this position
Compensation:
- 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.
Additional:
- 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
- And so much more!
