Analyst, Business Intelligence

About the Role

Key Responsibilities

• Develop and enhance the data and analytics capabilities of Horizon Next
• Partner with senior BI team members on data modeling and reporting efforts to make data accessible throughout Horizon Next
• Bring together disparate data sources by building data models for 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 the data warehouse and incorporate them into data models
• Drive education and adoption of data products across teams
• Act as a liaison between the Horizon Next Analytics team and other internal teams regarding data sources, access, and reporting
• Educate non-technical team members on data products and their use in decision-making
• Work with clients to understand their data and create meaningful KPIs for media campaigns

Requirements

• 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 a similar industry
• 1-3 years using SQL in a work environment
• Experience with a cloud data warehouse like Amazon Redshift, Google BigQuery, or Snowflake
• Strong background in SQL
• Comfortable working in both business and technical/processes environments
• Enjoy creating reusable and automatable processes that can scale
• Supporter of and advocate for diversity, equity, and inclusion

Nice to Have

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

Qualifications

• Experience with cloud data warehouses such as Amazon Redshift, Google BigQuery, or Snowflake
• Proficiency in SQL

Benefits & Perks

• Competitive salary range of $70,000.00 - $85,000.00
• 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