2024 Q3 EXT Senior Data Analyst

Company Description

• We all remember our first job and can reflect on all the ways it shaped our careers and lives. That's why we take such great pride in our mission - helping the world's top employers recruit the future of their workforce. Here at Yello, we're committed to providing best-in-class campus recruiting software to early talent teams, and helping qualified and diverse students and recent graduates find internships and jobs.
  Founded in 2008, Yello is a venture-backed talent acquisition software company that empowers Fortune 500 and fast-growing enterprise companies to find the best new talent for their organizations - and helps people early in their careers find their dream job. In July 2021, Yello merged with WayUp, bringing together Yello's best-in-class campus recruiting solution and WayUp's industry-leading DEI sourcing solution, featuring a database of over 7M students and recent graduates. Now, Yello supports the entire early talent recruiting journey for both employers and candidates.
  If you'd like to be part of a team that helps some of the world's largest brands connect with their future employees, come grow your career with Yello.

About The Role
You'll join an existing data services team charged with ensuring the delivery of business insights from data that Yello collects. You will work closely with the Director of Data, data engineers, product managers, and Customer Success to gather requirements necessary to produce analytics products that drive meaningful change in the recruiting experience.
What will I learn in this role?

• How to ask the right questions to solve client problems
• How to implement robust reporting solutions within a multi-tenant environment
• Product analytics & the enhancement of your technical skill set
• Modern data stack
• About the recruiting industry and the challenges companies face in hiring talent

Why is this role important?

• Accurate and timely requirements are imperative to producing reporting and analytics that provide valuable insights.
• Internal teams, from Customer Success to Growth Marketing, rely on thoughtfully-crafted internal dashboards to better help our customers.
• Fulfill our mission to improve the health and accessibility of data at Yello
• Analytics is at the heart of what we do, with our reports inspiring meaningful change in recruiting practices.
• As a Yello data subject-matter expert, this role will have the opportunity to influence the strategic direction of the company.

About our stack:
Scheduling/Orchestration: Dagster
ETL: Custom Python, DBT, SQL
Data Warehouse: Snowflake, Starburst
Data Visualization: Sisense Fusion/Periscope, Looker
Code versioning: Git
How You'll Make An Impact
RESPONSIBILITIES

• Partner with Customer Success to acquire accurate business requirements
• Construct custom dashboards based upon defined business requirements
• Consult with Product Managers to define key performance metrics and business insights
• Provide data-driven insights to guide product development decisions
• Utilizing Agile principles to manage request intake and completion
• Work closely with Product, UX, and Design team members to develop internal analytical solutions (e.g. dashboards, automated reports) for internal personnel
• Build SQL queries to deliver ad hoc insights to both internal and external stakeholders
• Build complex SQL queries to transform, cleanse, and validate data for the data lake/warehouse based on business rules and requirements
• Implement cataloging best practices and leading the definition, collection, and documentation of our data sources

What We're Looking For
MINIMUM QUALIFICATIONS

• A bachelor's degree or higher in Management Information Systems, Computer Science, Statistics, Mathematics, another quantitative discipline or equivalent work experience required
• 2 to 4 years of business analysis experience
• 2 to 4 years of data analytics experience
• Proficient in SQL - must be able to build and performance tune complex transformation, reporting, and validation queries, preferably in Trino SQL, to ensure accuracy, scalability, and maintainability of code
• 2 to 4 years working experience with data visualization tools, such as Tableau, Power BI, Looker, or Sisense
• Agile project management experience
• Analytical and problem-solving skills to take complex business requests and transform them into clean, simple, data driven solutions
• Strong verbal and written communication skills and the ability to effectively collaborate with other engineers as well as internal/external stakeholders

PREFERRED QUALIFICATIONS

• 2 to 4 years of experience working in customer-facing analytics reporting
• Experience with DBT
• Experience with dimensional data modeling
• Nice to have experience using git or other version control

Additional Information

• We are open to remote applicants for this position as long as you live in one of the states we are set up to do business in: AZ, CA, CO, FL, GA, IL, IN, KS, MI, NC, NJ, NV, NY, PA, TN, TX, VA, and WI
• Base salary range for this role is $100,000 - $130,000, based on experience, with a 10% annual bonus opportunity
• Yello is an Equal Opportunity Employer. All applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status
• You must be authorized to work in the United States. We are not offering visa sponsorship for this role.
• This role frequently communicates/interacts with individuals, must have strong written and oral communication skills