Senior Analyst, Business Intelligence

Horizon Media • New York, NY

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

About The Position

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.

Requirements

• Experience in the media, advertising, or direct-response industries
• Background in data or analytics but more interested in building processes, automation, and tooling than providing insights and recommendations
• History of automating and improving processes to reduce time spent on manual work
• Strong background in SQL and some experience with Python in a work environment
• Proven history of working effectively with both business and engineering/technical teams

Nice To Haves

• Undergraduate degrees 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 similar industry
• 2-3 years using SQL 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 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 BI or dashboard tools like Tableau, Looker, or Domo
• Experience with dbt (data build tool)

Responsibilities

• Develop and enhance the data and analytics capabilities of Horizon Next - 70%
• Lead and own data modeling and reporting efforts for individual clients to ensure internal and client teams have the data they need to plan and optimize their media campaigns
• Partner with senior BI team members on cross-client 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
• Build and prototype new data products that can increase the BI team's offerings and capabilities
• Build data visualizations and dashboards to surface trends and insights to business teams and clients
• Mentor and level up the skills of your teammates through collaboration and by sharing your expertise
• 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

Benefits

• Health insurance coverage
• Life and disability insurance
• Retirement savings plans
• Company paid holidays
• Unlimited paid time off (PTO)
• Mental health and wellness resources
• Pet insurance
• Childcare resources
• Identity theft insurance
• Fertility assistance programs
• Fitness reimbursement

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Professional, Scientific, and Technical Services
• Education Level: Bachelor's degree