Data Analytics Engineer
- Location:
- Remote
- 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 UX to produce analytics products that drive meaningful change in the recruiting experience.
What will I learn in this role?
- Modern data stack
- Product analytics & the enhancement of your technical skill set
- How to implement robust reporting solutions within a multi-tenant environment
- About the recruiting industry and challenges companies face in hiring talent
Why is this role important?
- 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
- Internal teams, from Customer Success to Growth Marketing, rely on thoughtfully-crafted internal dashboards to better help our customers
- 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
- Dashboarding: Sisense/Periscope, Looker
- Code versioning: Git
- Preferred languages: SQL, Python
- How You'll Make An Impact:
- Maintain Data Loads and Orchestration in Dagster to ensure data freshness and availability
- Manage CI/CD Pipelines for consistent flow of data
- Ensure Data Lakehouse in Starburst remains performant with minimal disruptions
- Develop data models and schemas that enable intuitive analysis in a Data Lake/Warehouse setting
- 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 lead the definition, collection, documentation of our data sources
- 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
- What We're Looking For:
- Minimum Qualifications
- A bachelor’s degree or higher in Economics, Computer Science, Statistics, Mathematics, another quantitative discipline or equivalent work experience required
- 1 to 3 years of python experience
- 1 to 3 years of data lake/warehouse experience in Cloud technologies (Starburst, Snowflake, Azure, Redshift)
- Data Orchestration experience (jobs, tasks, schedules)
- Experience maintaining CI/CD pipelines
- 1+ years of experience with data modeling in dbt (preferably in a daily capacity)
- 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
- 1 to 3 years working experience with data visualization tools, such as Tableau, Looker, or Sisense
- 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- 3 to 5 years of experience working in customer-facing analytics reporting
- Experience with Dagster
- Infrastructure as Code experience (Terraform)
- Experience generating customer-facing reports (specifically, using tools such as Looker / Sisense)
- Experience with dimensional data modeling
- Nice to have: experience using git or other version control, JIRA
- 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, MA, MI, NC, NJ, NV, NY, PA, TN, TX, VA, and WI
- Base salary range for this role is $120,000 - $140,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.
- Must be able to sit or stand for continuous periods of time
- This role frequently communicates/interacts with individuals, must have strong written and oral communication skills
