Senior Analyst, Business Intelligence

Horizon Media•New York, NY

20h

About The Position

The Senior Analyst, Business Intelligence helps Horizon Next team members—both technical and non-technical—access the data they need to make informed decisions. The role contributes to the BI team’s goal of building scalable data products and solutions across the client portfolio. It focuses on developing and improving data and analytics capabilities, with most of the work devoted to client-specific and cross-client data modeling, reporting, data quality, automation, and visualization. The remaining focus is on educating teams and encouraging adoption of data products. The position works with Analytics, Data Engineering, business teams, and clients. Candidates are preferred who can work East Coast hours.

Requirements

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 a similar industry.
2–3 years of SQL experience in a work environment.
1–2 years of Python or similar programming-language experience in a work environment.
1–2 years of experience with a cloud data warehouse such as Amazon Redshift, Google BigQuery, or Snowflake.
Strong SQL background and some Python experience in a work environment.
History of effectively working with both business and engineering or technical teams.
Experience automating and improving processes to reduce manual work.
Background in data or analytics, with an interest in building processes, automation, and tooling.

Nice To Haves

Experience with Git or a similar version control system.
Experience with a query engine such as Presto, Hive, or Spark SQL.
Experience with BI or dashboard tools such as Tableau, Looker, or Domo.
Experience with dbt (data build tool).

Responsibilities

Lead and own data modeling and reporting efforts for individual clients so internal and client teams have the data needed to plan and optimize media campaigns.
Partner with senior BI team members on cross-client data modeling and reporting to make data more accessible throughout Horizon Next.
Build data models that bring together disparate data sources for technical and non-technical stakeholders.
Create and maintain automated data tests to ensure high data quality across data models.
Collaborate with Data Engineering team members to bring new data sources into the data warehouse and incorporate them into data models.
Build and prototype data products that expand the BI team’s offerings and capabilities.
Create data visualizations and dashboards to surface trends and insights to business teams and clients.
Mentor teammates and develop their skills through collaboration and sharing expertise.
Act as a liaison between the Horizon Next Analytics team and other internal teams on data sources, data access, and reporting availability.
Educate non-technical team members about data products and how to use data in decision-making.
Work with Horizon Next clients to understand their data and create meaningful KPIs for media campaigns.