Analyst, Business Intelligence
Horizon Media is a leading marketing and advertising firm known for its innovative approach and commitment to diversity and inclusion. The Analyst, Business Intelligence will develop and enhance data and analytics capabilities, partnering with teams to improve data accessibility and drive the education of data products across the organization.
Responsibilities
- 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 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 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
Skills
- Bachelor's degree 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, Google BigQuery, or Snowflake
- 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 with dbt (data build tool)
- 1-2 years of experience in media, advertising, or similar industry
Benefits
- Discretionary bonus
- 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
Company Overview