Skip to content

Analyst – Business Intelligence
Company | Horizon media |
---|
Location | New York, NY, USA |
---|
Salary | $70000 – $85000 |
---|
Type | Full-Time |
---|
Degrees | Bachelor’s |
---|
Experience Level | Junior, 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)