This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
As a Senior Analytics Engineer, you are responsible for bridging the gap between Data Engineering and Data Analysts. At SpotHero, this role will focus on modeling complex data sets with an eye towards data quality, timeliness, and re-use. Day-to-day tasks include but are not limited to writing performant SQL queries and always seeking to improve high-use queries, building up reusable pipelines, identifying useful and less than useful data-sets within the existing data warehouses, and building relationships between Data Engineering and its stakeholders and being an advocate for them.
Job Responsibility:
Bridging the gap between Data Engineering and Data Analysts
Modeling complex data sets with an eye towards data quality, timeliness, and re-use
Writing performant SQL queries and always seeking to improve high-use queries
Building up reusable pipelines
Identifying useful and less than useful data-sets within the existing data warehouses
Building relationships between Data Engineering and its stakeholders and being an advocate for them
Data Modeling/Architecting
Pipelining
Deriving Business Insights
Stakeholder Enablement
Requirements:
Minimum of 4 years of related experience with a Bachelor’s degree, or 2 years and a Master’s degree
1-2 years of experience working with Dbt cloud (or Dbt core)
Strong SQL and data modeling skills
Knowledgeable of object-oriented and/or functional programming patterns and paradigms
Hands-on experience with multiple data platforms and tools (eg, S3, Redshift, Airflow, Spark, Presto, Hive)
Demonstrated experience with small teams that move fast - all members are expected to be able to achieve maximum results with minimal direction
Demonstrated experience measuring the impact of technical products across multiple domains through experimentation and statistical analysis
Strong ability to communicate on both business and technical subjects
Nice to have:
Bonus: Strong Python experience
What we offer:
We cover a generous portion of Medical Premiums, 50% of Dental and Vision Premiums, company-sponsored Life Insurance, STD, and AD&D coverage, a 401(k) with match and immediate vesting, and comprehensive leave policies
Flexible PTO policy and outstanding work/life balance
Grubhub weekly lunch stipend for in-office days (UberEats for Canada)
Udemy License and Personal Learning Budget
Annual parking stipend
The opportunity to collaborate with fun, innovative, and passionate people in a casual yet highly productive atmosphere
Our commitment to allyship
Employee programs to grow and support our people such as Discovery Days for Product and Engineering, Gearing up for Aspiring Leaders, and Mentorship Program