![](https://cdn.prod.website-files.com/63cc0dbb5dfd654aec64a94a/667d3d00dd2b5e700e630081_IbZyXv967oL5Tfj8trST2hM5xHAxNkFBbmaWwREsA2M.jpeg)
The Yay Company
is hiring
Business Analyst
About Our Company
The Yay Company is a modern school lunch program offering custom meal solutions for schools and families to elevate the standard of how kids eat.
At Yay, we believe lunchtime should be an exciting break for students and a pause in the day for school staff. We believe in real food, made fresh, ingredients that help students thrive and an experience that feels modern and vibrant.
Since launching, we have served millions of meals at over 175 schools across the US, to 60,000+ students, faculty and staff every day!
Job Description & Responsibilities
The Business Analyst at The Yay Company is fully responsible for all analytics initiatives and data-driven insights that drive the company's continuous success. This role involves extracting, manipulating, and visualizing data using advanced SQL skills and various reporting tools. The Business Analyst creates and maintains self-service dashboards, supports core data warehouse activities, and assists in developing new data architectures.
You're Excited About This Opportunity Because You Will
- Take full responsibility for the core data warehouse using dbt, Snowflake, and GitHub by creating new models in SQL and maintaining existing models through fixes and revisions.
- Fulfill ad hoc data requests directly from Snowflake using SQL when self-service tools are unavailable.
- Maintain current contracts and manage the department budget.
- Plan, create, and present self-service business intelligence reports.
- Develop a plan for growing the analytics department and creative thinking around existing tools.
- Utilize ETL and reverse ETL programs such as FiveTran, Hightouch, and Census to integrate data from various sources including Laravel, ZenDesk, HubSpot, MailChimp, Bamboo HR, and Google Sheets.
Requirements
"We're Excited About You Because You Bring
- Advanced SQL skills and proficiency with Snowflake, dbt, and GitHub.
- Experience with business intelligence tools.
- Proficient in data integration using FiveTran and Hightouch.
- Strong data analysis, data modeling, and data visualization skills.
- Expertise in data cleaning and data manipulation.
- Expertise with Excel and Google Sheets.
- Adaptability, independent work capability, and team collaboration skills.
- Minimum of 2-3 years of experience in a data analysis or business intelligence role.
- Bachelor's degree in Data Science, Computer Science, Information Systems, or a related experience is preferred.
Tools And Technologies
- SQL, Snowflake, dbt, GitHub
- FiveTran, Hightouch, Census
- Google Sheets, Excel
"
What we offer
We pride ourselves on being a good employer, and to that end we provide:
- $70,000 annual salary
- Health Insurance - medical, vision, dental and life insurance
- Voluntary life and short-term disability Insurance, and flexible spending account (FSA)
- 401(k) retirement, up to 3.5% employer match after 6 months
- Flexible paid time off (unlimited time off program)
- Data stipend
- Remote, flexible environment
- Significant support structures, on-the-ground training, & coaching from central team member