Senior Analyst, Business Intelligence

Horizon Media; United States; On-site; USD 95,000 - 115,000; Full time

Job summary

Horizon Media is seeking a Senior BI Analyst to empower Horizon Next with broader data access and scalable data products. You will enable both technical and non-technical teams to leverage data for informed decision-making across client campaigns.

Responsibilities include leading data modeling, building dashboards, and collaborating with engineering to bring new data sources into scalable models. Emphasis on education and adoption of data products across teams.

Qualifications

• 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 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.

Responsibilities

• Lead and own data modeling and reporting efforts for individual clients to ensure data access for planning and optimization of media campaigns.
• Collaborate with senior BI team members on cross-client data modeling and reporting to make data accessible across Horizon Next.
• Integrate disparate data sources by building data models usable by both technical and non-technical stakeholders.
• Create and maintain automated data tests to ensure high data quality across models.
• Work with Data Engineering to bring new data sources into the data warehouse and models.
• Build and prototype new data products to enhance BI offerings and capabilities.
• Create dashboards and visualizations to surface trends and insights for business teams and clients.
• Mentor teammates and share expertise to raise team skills.

Skills

SQL

Python

Data modeling

Amazon Redshift

Google BigQuery

Snowflake

Education

Undergraduate degree in Mathematics, Statistics, or comparable experience

Tools

Tableau

Looker

Domo

dbt

Presto

Hive

Spark SQL

Job description

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.

Job Summary

TheSeniorAnalyst, Business Intelligence willempower team members across Horizon Next with increased access to the data. They will ensure both technical and non-technical team members have access to the data they need to inform their decision-making processes. TheSeniorAnalystcontribute to the BI team goal ofcreating data products and solutions that scale across our portfolio of clients.

What You’ll Do

Develop andenhancethedata and analytics capabilitiesof Horizon Next – 70%

• Lead and own data modeling and reporting efforts for individual clients toensure internal and client teams have the data they need to plan and optimize their media campaigns
• Partner with senior BI team members oncross-clientdata modeling and reporting efforts tomake 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 theHorizon NextAnalyticsteamandotherinternalteams 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 haveexperience inthe 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 have a history of automating and improving processes to reduce time spent on manual work
• You have a strong background in SQLand some experience with Python in a work environment
• You have a proven history of working effectively with both business andengineering/technicalteams

Skills & Experience

Required

• Undergraduate degree in Mathematics, Statistics, or comparable experience
• 2-4years of experience in analytics, business intelligence, or a similar field
• 2-3years 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 witha query engine likePresto, Hive, or Spark SQL
• Experience with BI or dashboard tools like Tableau, Looker, or Domo
• Experience with dbt (data build tool)

Certificates, Licenses and Registrations

No requirements for certificates, licenses and registrations.

Physical Activity and Work Environment

Prefer candidate whocan work east-coast hours. Nootherrequirements for physical activity and work environment.

The statements herein are intended to describe the general nature and level of work being performed by employees and are not to be construed as an exhaustive list of responsibilities, duties and skills required of personnel so classified. Furthermore, they do not establish a contract for employment and are subject to change at the discretion of the employer.

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.

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

$95,000.00 - $115,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. 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.