Analyst, Business Intelligence

Horizon Media•New York, NY

12d•$70,000 - $85,000•Hybrid

About The Position

Horizon Media, founded in 1989, is a leading marketing and advertising firm headquartered in New York City with offices in Los Angeles and Toronto. Known for its innovative approach and personal client service, Horizon is consistently recognized as a top workplace. The company fosters an environment of belonging, valuing diverse perspectives and empowering employees. They hire talented individuals, challenge them, and provide opportunities for growth. This role focuses on developing and enhancing data and analytics capabilities, partnering with senior BI team members on data modeling and reporting, and bringing together disparate data sources. The position also involves educating non-technical team members on data products and working with clients to define KPIs for media campaigns.

Requirements

Bachelor’s degree in a quantitative, analytics or business subject area.
At least 1 - 2 years of experience in data analytics, business intelligence, or a similar field related to querying large volumes of data.
At least 1 year using SQL in a work environment.
Experience with a cloud data warehouse like Amazon Redshift, Google BigQuery, or Snowflake

Nice To Haves

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 for automating QA processes.
Experience with BI or dashboard tools like Tableau, Looker, or Domo
Experience with dbt (data build tool)
1-2 years of experience in media, advertising, or similar industry

Responsibilities

Develop and enhance the data and analytics capabilities of Horizon
Partner with senior BI team members on data modeling and reporting efforts to make data as accessible as possible throughout Horizon
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
Act as a liaison between the Horizon 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 clients to understand their data and create meaningful KPIs for media campaigns