Posted in

Analyst – Business Intelligence

Analyst – Business Intelligence

CompanyHorizon media
LocationNew York, NY, USA
Salary$70000 – $85000
TypeFull-Time
DegreesBachelor’s
Experience LevelJunior, Mid Level

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
  • Strong background in SQL

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

Preferred Qualifications

  • 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)