Business Intelligence Analyst

About the role

Horizon Next, part of Horizon Media, is a data-driven marketing organization focused on brand strategy, media planning and investment, and analytics across channels. It is looking for a Business Intelligence Analyst in New York who will strengthen the company's data and analytics capabilities, working closely with senior BI team members and the Data Engineering team.

Key responsibilities

• Develop and enhance data and analytics capabilities (about 70% of the role)
• Partner with senior BI team members on data modeling and reporting, making data as accessible as possible
• Build data models that combine disparate data sources and serve both technical and non-technical stakeholders
• Create and maintain automated data tests to ensure high data quality across data models
• Work with Data Engineering to bring new data sources into the data warehouse and add them to new data models
• Drive education and adoption of data products across teams (about 30% of the role)
• Act as a liaison between the Analytics team and other internal teams on data sources, access and reporting availability
• Educate non-technical team members on data products and how to use data for decisions
• Work with clients to understand their data and create meaningful KPIs for media campaigns

Required profile

• 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 a similar industry
• Background in data or analytics, with a focus on building processes, automation and tooling rather than insights and recommendations
• Strong background in SQL
• Advocate for diversity, equity and inclusion

Required skills

• SQL (required)
• Cloud data warehouse such as Amazon Redshift, Google BigQuery or Snowflake (required)
• Preferred: Git or similar version control
• Preferred: Presto, Hive or Spark SQL
• Preferred: Python or similar programming language
• Preferred: Tableau, Looker or Domo
• Preferred: dbt

What we offer

• Salary range of $70,000 - $85,000, depending on skills, experience and qualifications
• Discretionary bonus
• Health, life and disability insurance, retirement savings plans
• Company-paid holidays and unlimited PTO
• Mental health and wellness resources, pet insurance, childcare resources, identity theft insurance, fertility assistance and fitness reimbursement