Responsibilities

• Develop and enhance the data and analytics capabilities of Horizon Next – 70%
• Partner with senior BI team members on data modeling and reporting efforts to make data as accessible as possible throughout Horizon Next
• Bring together disparate data sources by building data models that can be used by both technical and non-technical stakeholders
• Create and maintain automated data tests to ensure high data quality across all data models
• Collaborate with Data Engineering team members to bring new data sources into our data warehouse and add them into new data models
• Drive education and adoption of data products across teams – 30%
• Act as a liaison between the Horizon Next Analytics team and other internal teams on matters related to data sources, data access, and reporting availability
• Educate non-technical team members on our data products and how best to use data to inform their decision-making process
• Work with Horizon Next clients to understand their data and create meaningful KPIs for media campaigns

Requirements

• A minimum of a Bachelor’s degree in a quantitative, analytics or business subject area
• 1-3 years of experience in analytics, business intelligence, or a similar field
• 1-2 years of experience in media, advertising, or similar industry
• 1-3 years using SQL in a work environment
• Experience with a cloud data warehouse like Amazon Redshift, Google BigQuery, or Snowflake
• You have a strong background in SQL
• You have a background in or knowledge of the media, advertising, or direct-response industries
• You have a background in data or analytics but are more interested in building processes, automation, and tooling than providing insights and recommendations
• You are comfortable having one foot in the “business” world and one foot in the “processes & code” world
• You enjoy creating reusable and automatable processes that can scale

Preferred

• Experience with Git or a similar version control system
• Experience with a query engine like Presto, Hive, or Spark SQL
• Experience with Python or a similar programming language
• Experience with BI or dashboard tools like Tableau, Looker, or Domo
• Experience with dbt (data build tool)

Benefits

• As an organization, we take an aptitude and competency-based hiring approach. We provide a competitive total rewards package including a discretionary bonus and a variety of benefits including health insurance coverage, life and disability insurance, retirement savings plans, company paid holidays and unlimited paid time off (PTO), mental health and wellness resources, pet insurance, childcare resources, identity theft insurance, fertility assistance programs, and fitness reimbursement.