Analyst, Business Intelligence

Horizon Media Inc.; New York, Northern (NY, KY); Hybrid; USD 70,000 - 85,000; Full time

Benefits offered by this job

Discretionary bonus

Health insurance

Paid holidays

Unlimited PTO

Job summary

Horizon Next, a Horizon Media analytics-driven unit, is seeking a data and analytics professional to expand our capabilities and empower media decision-making for clients. You will work with senior BI colleagues to model data, build accessible data products, and ensure data quality across models.

This role sits at the intersection of business and code, uniting disparate sources in a scalable data warehouse, driving adoption of data tools, and helping define meaningful KPIs for campaigns and

Qualifications

• Bachelor’s degree in a quantitative analytics or business field.
• 1–3 years of analytics, business intelligence, or a similar role.
• 1–2 years of experience in media, advertising, or a related industry.
• 1–3 years using SQL in a professional setting.
• Experience with cloud data warehouses such as Redshift, BigQuery, or Snowflake.

Responsibilities

• Develop and enhance Horizon Next data and analytics capabilities across teams (70%).
• Model data and build reusable data products for technical and non-technical stakeholders.
• Collaborate with Data Engineering to bring new data sources into the warehouse.
• Drive education and adoption of data products to inform campaign decisions.

Skills

SQL

Data analysis

Process automation

Python

Tableau

Looker

Domo

dbt

Git

BigQuery

Education

Bachelor's degree in a quantitative analytics or business field

Tools

Amazon Redshift

Google BigQuery

Snowflake

Presto

Hive

Spark SQL

Job description

Who We Are

Horizon Next is one of the industry's most innovative and data-driven marketing organizations and sits at the intersection of three constantly changing landscapes: people, data, and media. Our business provides strategic leadership to accelerate growth for our clients through brand strategy, media planning and investment, and best in class analytics across all channels. As the leader in innovative business solutions, we are always pushing ourselves to understand what’s next: our next innovation, our next advancement in analytics, the market’s next media evolution, and your next breakthrough idea. Horizon Next operates with the single goal that tomorrow must outperform today. At Horizon, we understand the value that different perspectives can bring to our clients and culture, so we strive for an environment where our employees feel welcomed, safe and empowered. We value YOU and believe that your authentic voice and unique perspective allows us to create a more rewarding culture, and experience, together. Our simple recipe for success? We hire talented people (thinkers, doers, dreamers, makers), challenge them and give them every opportunity to grow.

What You’ll Do

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

Who You Are

• You have a background in or knowledge of the media, advertising, or direct-response industries
• You have a background in data or analytics but are more interested in building processes, automation, and tooling than providing insights and recommendations
• You are comfortable having one foot in the “business” world and one foot in the “processes & code” world
• You enjoy creating reusable and automatable processes that can scale
• You have a strong background in SQL
• A supporter of and advocate for diversity, equity and inclusion

Preferred Skills & Experience Required

• 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
• Preferred 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)

#LI-KG1 #LI-HYBRID #HN Horizon Media is proud to be an equal opportunity workplace. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements.

Salary Range

$70,000.00 - $85,000.00 A successful applicant’s actual base salary may vary based on factors such as individual’s skill sets, experience, training, education, licensure/certifications, and qualifications for the role. As an organization, we take an aptitude and competency-based hiring approach.

Total Rewards Package

We provide a competitive total rewards package including a discretionary bonus and a variety of benefits including health insurance coverage, life and disability insurance, retirement savings plans, company paid holidays and unlimited paid time off (PTO), mental health and wellness resources, pet insurance, childcare resources, identity theft insurance, fertility assistance programs, and fitness reimbursement.

Culture & Community

Want to know what makes Horizon a great place to work? At Horizon, business is personal — and that means connecting with what matters. Horizon is powered by one of the industry’s most celebrated and inclusive workplace cultures. We believe in the talent of our people and the power of personal, with our passion and commitment to excellence driving our success. Follow up on Instagram and LinkedIn.