Responsibilities

• Develop and enhance the data and analytics capabilities of Horizon Next – 70%
• Lead and own data modeling and reporting efforts for individual clients to ensure internal and client teams have the data they need to plan and optimize their media campaigns
• Partner with senior BI team members on cross-client 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
• Build and prototype new data products that can increase the BI team’s offerings and capabilities
• Build data visualizations and dashboards to surface trends and insights to business teams and clients
• Mentor and level up the skills of your teammates through collaboration and by sharing your expertise
• Drive education and adoption of data products across teams – 30%

Requirements

• You have experience in 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 have a history of automating and improving processes to reduce time spent on manual work
• You have a strong background in SQL and some experience with Python in a work environment
• You have a proven history of working effectively with both business and engineering/technical teams
• Undergraduate degree in Mathematics, Statistics, or comparable experience
• 2-4 years of experience in analytics, business intelligence, or a similar field
• 2-3 years of experience in media, advertising, or similar industry
• 2-3 years using SQL in a work environment
• 1-2 years of experience using Python or a similar programming language in a work environment

Preferred

• 1-2 years of experience with a cloud data warehouse like Amazon Redshift, Google BigQuery, or Snowflake
• Experience with Git or a similar version control system
• Experience with a query engine like Presto, Hive, or Spark SQL
• Experience with BI or dashboard tools like Tableau, Looker, or Domo
• Experience with dbt (data build tool)

Benefits

• 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
• fitness reimbursement