Senior Analyst, Business Intelligence

Horizon Media•New York, NY

1d•$95,000 - $115,000

About The Position

The Senior Analyst, Business Intelligence empowers Horizon Next team members by increasing access to data and ensuring technical and non-technical stakeholders can obtain the information they need for decision-making. The role contributes to the BI team’s work building data products and scalable solutions across the client portfolio. The position develops and enhances Horizon Next’s data and analytics capabilities, leading data modeling and reporting for individual clients and partnering with senior BI colleagues on cross-client efforts. It brings disparate data sources together, maintains automated data quality tests, collaborates with Data Engineering to incorporate new sources into the data warehouse, prototypes data products, and creates visualizations and dashboards. The Senior Analyst also mentors teammates and encourages adoption of data products by educating internal teams and helping clients define meaningful media-campaign KPIs. The role is suited to someone with media, advertising, or direct-response experience who is focused on building processes, automation, and tooling. It requires strong SQL skills, work experience with Python or a similar language, and the ability to work effectively with both business and technical teams. The candidate is preferably able to work East Coast hours. The stated salary range is $95,000–$115,000. Horizon offers a competitive total rewards package including a discretionary bonus and various benefits.

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 experience using Python or a similar programming language in a work environment.
1–2 years of experience with a cloud data warehouse such as Amazon Redshift, Google BigQuery, or Snowflake.
Strong background in SQL and some Python experience in a work environment.
Experience in media, advertising, or direct-response industries.
History of automating and improving processes to reduce manual work.
Proven ability to work effectively with business and engineering or technical teams.

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).
Ability to work East Coast hours.

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 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 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.
Build data visualizations and dashboards to surface trends and insights to business teams and clients.
Mentor teammates and help develop their skills through collaboration and knowledge sharing.
Act as a liaison between Horizon Next Analytics and other internal teams on data sources, data access, and reporting availability.
Educate non-technical team members about data products and using data to inform decisions.
Work with clients to understand their data and create meaningful KPIs for media campaigns.