Position Summary

KQED is seeking an Analytics Manager who will be responsible for our data engineering and reporting practices. This is an exciting opportunity for someone who would enjoy the challenge of building an analytics practice while also meaningfully translating audience data into insights and strategy.

This person will play an integral role in defining and managing most elements of our analytics work: vendor/tool selection, budget management, data cataloging, ELT pipelines, orchestration, dashboarding, and modeling. They will also regularly work with stakeholders from other departments to help define key metrics and respond to a modest volume of ad-hoc reporting requests.

The ideal candidate is a strong generalist with 3-5 years of experience - preferably helping build and manage an analytics function - who brings a bias for simplicity and informed opinions about tools, processes, and budget management. On any given day, they may be reporting on marketing analytics, meeting with stakeholders, creating a dashboard, building an ELT connector in Python, digging into a table with 250M rows, or trying to figure out how to align 4 different social media platforms' definitions of what a "video view" is.

This is a hybrid position working three days a week in our San Francisco headquarters. It is an individual contributor position with potential for people management, sitting within the Audience Intelligence team and reporting to the Director of Audience Intelligence.

Salary Information: $95,500-$119,400 Annually

KQED envisions a public media organization with a culture that centers on human dignity, equity, and belonging. This will enable us to better serve and reflect the Bay Area through diverse and inclusive storytelling.

We value the contributions of marginalized people in society - including Black, Indigenous, and all people of color, people with disabilities, and LGBTQIA+ people - and we believe that these communities must be centered in the work we do, and we strongly encourage members of these communities to apply.

KQED Code of Ethics https://www.kqed.org/about/code-ethics

The mission that drives us

KQED provide citizens of Northern California with a community-supported alternative to commercial media. We provide citizens with the knowledge they need to make informed decisions; convene community dialogue; bring the arts to everyone and engage audiences to share their stories. We help students and teachers thrive in 21st-century classrooms, and take people of all ages on journeys of exploration- exposing them to new people, places and ideas.

This role will work hybrid between working in KQED's newly renovated headquarters and working remotely. KQED requires employees to be fully vaccinated against COVID-19.

Essential Functions

Design, build, and manage data consolidation processes and systems, including ELT pipelines and orchestration workflows

Maintain our data warehouse

Partner with the department head and other stakeholders to define and report on key organizational metrics

Create and socialize reports/dashboards to effectively communicate trends in key metrics

Analyze data to identify important patterns and drivers of change, and develop insights that can be translated into business strategy

Prepare and present reports to other teams and the organization as a whole

Maintain existing manual reporting processes until they can be automated

Respond to ad-hoc data and analysis requests from other departments

Other duties as assigned

Candidate qualifications

Demonstrable experience managing moderately complex ELT and data orchestration work

Strong SQL skills, including solid familiarity with columnar databases

Proficiency in Python (ability to build moderately complex applications outside of a notebook environment, spanning multiple scripts, utilizing appropriate data structures and packages)

Experience building executive-level dashboards

Interest in or experience with data science (especially linear models, classification, clustering, time-series analysis, or personalization/recommendation engines)

Excellent LLM prompting skills

Exceptional interpersonal and communication skills, and ability to communicate complex concepts to senior and non-analytical audiences

Physical Demands

Ability to lift a minimum of fifteen (15) pounds;

Ability to exert maximum muscle force to lift, push, pull or carry;

Ability to use abdominal and lower back muscles over time without fatigue;

Ability to stand and/or sit for extended periods;

Ability to bend, stoop, stretch, twist, sit, and reach;

Fine motor skills;

Good visual and auditory acuity.

The physical demands described here represent those that an employee must meet to perform the essential functions of this job successfully.

NOTE: This job description is not intended to be all-inclusive. Employees may be required to perform other related duties as necessary to meet the ongoing needs of this organization.

KQED jobs

Analytics Manager