Business Data Analyst

Posted 
March 28, 2022

Overview

As the Business Data Analyst, you will create and maintain org-wide and departmental dashboards. You will ensure teams have access to self-service visualization and reporting tools as well as oversee maintenance of data governance principles within BI platform. You will collaborate with internal stakeholders on key business initiatives and manages on-going data projects. Demonstrates CPM’s values of integrity, community, innovation and diversity. 

Salary Range: $70,500-$80,000 annually

Benefits information can be found here

Seattle, hybrid schedule available, must reside in WA State

Proof of vaccination required for employment

Cascade Public Media is committed to building a team that represents a diversity of thought, experience and personal background.

KEY JOB RESPONSIBILITIES/DUTIES

  • Serves as product owner of CPM’s online data visualization solution, providing access, training, support, governance and end-to-end dashboard builds.
  • Builds and maintains dashboards using Tableau.
  • Conducts needs assessment with internal teams throughout the organization; audit reporting, iterate on report and dashboard builds, address reporting pain-points. 
  • Does data wrangling in Snowflake.
  • Maintains knowledge of audience trends in the media landscape, specifically trends around broadcast, video streaming habits, device use and PBS viewer behavior.
  • Experiments and performs tracking for projects and campaigns across the organization.  
  • Delivers occasional analysis related to Omni-channel audience performance, trends, and KPIs, both graphically (dashboards) and verbally (presentations), including delivery of clear, relevant and actionable insights — and in the form of data storytelling.
  • Collaborates with Digital Marketing, Audience Engagement, CRM Data, Digital Product and Technology and Philanthropy teams to maintain an aligned strategy for digital conversion and tracking across channels and platforms.
  • Works across the organization on adhoc data & research requests.
  • Interacts and works with external consultants on data discovery and implementation of data infrastructure.
  • Collaborate with other team members to foster a positive and productive culture and contribute toward the overall growth of the CPM.
  • Other duties, responsibilities and activities may change or be assigned at any time with or without notice.

REQUIRED SKILLS/ABILITIES

  • Strong data analysis and data storytelling skills.
  • Strong data visualization skills, specifically Tableau.
  • Familiarity with cloud computing.
  • Strong SQL skills & understanding of modern Cloud data platforms and architecture is required.
  • Familiarity with PM software like Jira is preferred.
  • Ability to project manage business intelligence projects; conduct needs assessment, UAT, stakeholder communication.
  • Excellent written and verbal communication skills.
  • Experience delivering presentations to stakeholders is desirable.
  • Ability to prioritize multiple projects and ad hoc requests. 
  • Strong independent thinking and problem solving abilities.
  • Ability to incorporate and synthesize feedback across the business to create Functional and Technical Specification Documents.
  • Comfortable multi-tasking and able to deliver insights in a fast paced environment.

EDUCATION AND EXPERIENCE

  • Bachelor's degree with 1-2 years of experience analyzing web, social media, advertising or digital marketing data.
  • Experience using audience measurement and performance tools, such as Nielsen, Google Analytics, Quant cast, parse.ly.
  • Strong SQL skills with experience in one or more programming languages like Python.
  • Experience building complex dashboards on data visualization platforms such as Tableau.
  • Experience working with cross functional teams internal and external.
  • Experience working with Offshore/Near Shore external teams is desirable. 
  • Some experience with predictive modeling is preferred.

PHYSICAL REQUIREMENTS

  • Ability to regularly type on a keyboard.
  • Ability to view data on a computer screen for long periods of time.
  • Ability to sit or stand for extended periods.
About the Department

Data

Our Diversity Commitment

We are committed to building a team that represents a diversity of thought, experience and personal background. Read our complete diversity commitment statement here.