The role involves building interactive reporting solutions, conducting predictive analytics, and creating dashboards using various data tools like Power BI and SQL. You will support executives with data insights and assist in data governance efforts.
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!
Who We Are
Our Purpose: Drive systemic improvement in childhood nutrition for a healthier, happier, and more equitable world.
Our Business: At Once Upon a Farm, a better story starts here. We're on a greater mission in providing organic, crave-worthy, snacks and meals for children of all ages. Our recipes are crafted with only the best organic ingredients – whole fruits and veggies, cold-pressed (our pouches), or freshly frozen (our meals) to perfection– to support your growing kids at every stage. Each of our organic, non-GMO, non-dairy recipes contains no added sugar and are free from artificial flavors, colors, and preservatives – just simple, real, nutritious snacks your entire family will love.
We support and champion farmers who supply the highest-quality organic ingredients for our foods. We help parents keep their promise to provide the best nourishment for their children’s bodies and souls. We treat our consumers, customers, suppliers, investors, and all our valued employees with the same high level of dignity and respect that we expect from others. We will always fight for and support efforts to drive positive social change and food justice for the benefit of parents, kids, and families. Lastly, we foster an entrepreneurial and collaborative culture that values humility, honesty, passion, positive social impact, and fun.
Our Team: We’re all fully remote, which makes us a highly collaborative, dynamic, and supportive bunch. We share a singular mission to make the world a better place through the highest quality, most delicious, nourishing, and nutritious products made accessible to every home, from our farms to your fridge. And while we’re invested in our product, we’re equally invested in one another's success.
Once Upon A Farm is a purpose-driven brand made up of an inclusive group of individuals with diverse backgrounds, passions, and beliefs. We hire self-motivated, independent thinkers, and those who are genuinely passionate about improving childhood nutrition for a healthier and happier planet. Bring your whole self to your work at Once Upon A Farm, a proud equal-opportunity employer. In your application, please feel free to note which pronouns you use.
In an effort to help us remove unconscious bias from our resume review process, we ask that you please remove all identifying information from your resume (like profile photos) before you upload it. Once Upon A Farm is committed to cultivating an inclusive environment where a diverse group of people can and want to do their best work, and that starts with our hiring practices.
Once Upon a Farm, PBC, provides equal employment opportunities to all employees and applicants in all company facilities without regard to race, color, religious creed, sex, national origin, ancestry, cast, citizenship status, pregnancy, childbirth, physical disability, mental and/or intellectual disability, age, military status or status as a Vietnam-era or special disabled veteran, marital status, registered domestic partner or civil union status, gender (including sex stereotyping and gender identity or expression), medical condition (including, but not limited to, cancer-related or HIV/AIDS-related), genetic information, or sexual orientation in accordance with applicable federal, state and local laws. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
You must reside in the United States to be considered for this position.
Top Skills
Azure
Excel
Fabric
Fivetran
Power BI
Power Query
Python
SQL
Ssms
Similar Jobs
Artificial Intelligence • Cloud • Mobile • Security • Software
The Senior Business Intelligence Analyst will analyze and model business results, create dashboards, automate reporting, and collaborate across teams.
Top Skills:
Bi ToolsDatabricksExcelGoogle SheetsGoogle SlidesLookerPower BIPowerPointPythonRSalesforceSigmaSQLTableauVisio
Healthtech
The Senior BI Analyst I develops datasets, creates data visualizations, and supports decision-making by analyzing complex business problems with data insights.
Top Skills:
AlteryxDbtLookerPower BISQLSsisTableau
Artificial Intelligence • Cybersecurity
As a Senior Business Intelligence Analyst, you'll analyze data, develop dashboards, monitor KPIs, and present findings to support cross-functional teams.
Top Skills:
AWSAzureBigQueryCi/CdGCPGitPythonRedshiftScalaSnowflakeSQLTableau
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
