160 applicants
The Yay Company · 3 days ago
Business Analyst
Raleigh, NC
Full-time
Onsite
Mid Level
$70K/yr - $70K/yr
2+ years exp
Wonder how qualified you are to the job?
Maximize your interview chancesEdTechFood and Beverage
Insider Connection @The Yay Company
Responsibilities
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.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
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.
Benefits
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
Company
The Yay 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.
201-500 employees
Funding
Current Stage
Growth StageTotal Funding
$12MKey Investors
Valor Siren VenturesANIMO Ventures
2023-12-15Series Unknown· Undisclosed
2022-12-23Series C· Undisclosed
2021-11-19Series A· $12M
Leadership Team
Derek Mansfield
Co-Founder and President
Recent News
Business Insider
2023-12-25
The Business Journals
2023-12-25
2023-12-25
Company data provided by crunchbase
