Job Search
 Business Analyst at The Yay Company
Business Analyst
@
The Yay Company

Key information

Apply now
Posted on: 
June 27, 2024
Views count:
0
Status: 
Expired

Summary of the Business Analyst job at The Yay Company

The Yay Company is hiring a Business Analyst with 0 - 3 years of experience. Based in United States - Raleigh, NC and with Remote ways of working. The expected salary range for this role is $70,000 - $70,000
About 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.

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!

Business Analyst - Job Role & 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.
Business Analyst - Job 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 at The Yay Company

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

Please mention “I found this job at DataAnalyst.com!” in your application, it will help us offer you more opportunities

insertpageurl
Thank you for reporting
Oops! Something went wrong while submitting the form.

What about the salary?

Average business analyst salary in the Other industry is $93,093.
Salary Guide

Apply now

Please mention: “I found this job at BusinessAnalyst.com” in your application, it will help us offer you more opportunities.

Apply now
The Yay Company

The Yay Company

is hiring

Business Analyst

Website:
Posted on: 
July 14, 2024

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
Apply now

Featured business analyst jobs