Analyst, Business Intelligence
Horizon Media
New York, New York
Full-Time
$70,000
HybridAssociate
Job Description
Who We Are
Horizon Media,founded in 1989 by Bill Koenigsberg, is recognized as one of the most innovative marketing and advertising firms. We are headquartered in New York City, with offices in Los Angeles and Toronto. A leader in driving business solutions for marketers, Horizon is known for its highly personal approach to client service. Renowned for its incredible culture, Horizon is consistently named to all the prestigious annual Best Places to Work lists published by Fortune,AdAge, Crain’s New York Business and Los Angeles Business Journal. Together we are building a place of belonging.
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.
WhatYou’llDo
Develop and enhance the data and analytics capabilities of Horizon – 70%
Partner with senior BI team members on data modeling and reporting efforts to make data as accessible as possible throughout Horizon
Bring together disparate data sources by building data models that can be used by both technical and non-technical stakeholders
Create andmaintainautomated 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 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 clients to understand their data and create meaningful KPIs for media campaigns
Who YouAre
You have a background in data analytics and are interested in building processes, automation, and tooling rather 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 reusableandautomatableprocesses that can scale
You have a strong background in SQL
A supporter of and advocate for diversity,equityand inclusion
Skills & Experience
Required
Bachelor’sdegree in a quantitative, analytics or business subject area.
At least 1 - 2 years of experience in data analytics, business intelligence, or a similar field related to querying large volumes of data.
At least 1 year using SQL in a work environment.
Experience with a cloud data warehouse like Amazon Redshift, GoogleBigQuery, 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 for automating QA processes.
Experience with BI or dashboard tools like Tableau, Looker, or Domo
Experience withdbt(data build tool)
1-2 years of experience in media, advertising, or similar industry
#LI-HYBRID
#LI-KG1
#HN
The statementshereinare 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 skillsrequired ofpersonnel so classified. Furthermore, they do notestablisha 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.
Salary Range
$70,000.00 - $85,000.00A 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.