Data Analyst - Audience
About TEGNA
TEGNA Inc. (NYSE: TGNA) helps people thrive in their local communities by providing the trusted local news and services that matter most. With 64 television stations in 51 U.S. markets, TEGNA reaches more than 100 million people monthly across the web, mobile apps, streaming, and linear television. Together, we are building a sustainable future for local news.
As a Data Analyst for Audience & Content Insights, you will be the architectural bridge between our raw data infrastructure and our creative strategy. You will sit within the Data & AI workstream, focusing on transforming complex datasets into a unified "truth" for the entire organization.
Your mission is twofold: technically, you will build and maintain a robust semantic layer within Snowflake; culturally, you will socialize this data with business users to ensure that every programming and content decision is backed by high-quality, consistent insights.
________________________________________
Responsibilities:
1. Data Architecture & Semantic Modeling
• Semantic Layer Ownership: Design, develop, and maintain the semantic layer in Snowflake, ensuring standardized definitions for all Audience and Content KPIs.
• Data Transformation: Build and optimize modular, production-grade data pipelines using dbt to turn raw logs into business-ready models.
• Single Source of Truth: Guarantee that metrics (e.g., "Active Viewer" or "Content Engagement") remain consistent across all reporting tools and departments.
2. Insight Generation & Visualization
• Reporting Strategy: Develop high-impact, interactive dashboards in Tableau Cloud that provide real-time visibility into content performance.
• Requirement Gathering: Lead discovery sessions with stakeholders to translate ambiguous business questions into technical user stories and actionable data requirements.
3. Data Socialization & Enablement
• Stakeholder Partnership: Act as the primary data consultant for Marketing, Editorial, and Executive teams to help them interpret and act on insights.
• Data Literacy: Host "Socialization" workshops to train business users on how to navigate the semantic layer and build their own self-service reports.
• Feedback Loops: Work closely with business users to iterate on the data model based on evolving content trends and user needs.
________________________________________
The Technical Stack
• Cloud Data Warehouse: Snowflake
• Transformation & Modeling: dbt (data build tool)
• BI & Analytics: Tableau Cloud / Tableau Desktop
________________________________________
Requirements:
• Experience: Approximately 5 years of experience in data analytics or analytics engineering, preferably within a Media, Streaming, or Digital Publishing environment.
• Snowflake Mastery: Advanced SQL skills and experience managing large-scale, high-concurrency data environments.
• dbt Expertise: Proven ability to build version-controlled data models and manage a dbt project lifecycle.
• Visualization: Expert proficiency in Tableau Cloud, with a focus on UX-driven dashboard design.
• Analytical Mindset: Strong ability to understand the "Why" behind the data and translate it into a narrative for non-technical audiences.
________________________________________
Preferred Qualifications
• Certifications: SnowPro Core, dbt Analytics Engineering Certification, or Tableau Desktop Specialist/Associate.
• Semantic Layer Tech: Experience with dbt Semantic Layer, MetricFlow, or similar governance frameworks.
• Agile Methodology: Experience working in an Agile/Scrum environment using Jira or similar tools for tracking user stories.
________________________________________
Why Join Us?
In this role, you aren't just "running queries"—you are shaping the data culture of a leading media company. You will have the autonomy to build a world-class semantic layer and the influence to see your insights turn into the next hit series or viral content strategy.
________________________________________
Pay Range
$110,000 - $140,000 USD
Benefits:
TEGNA offers comprehensive benefits designed to safeguard the physical, mental and financial health of our employees and their families. TEGNA offers two medical plan options for full and part-time employees through Blue Cross Blue Shield of Texas, as well as access to dental and eye care coverage; fertility, surrogacy and adoption assistance; disability and life insurance.
Our 401(k) program offers full, part-time and temporary employees the opportunity to contribute 1% - 80% of their pay on a pre-tax basis to TEGNA’s 401(k). Contributions made up to the first 4% of pay are eligible for a 100% match from the company and are 100% vested from day one.
Regardless of participation in TEGNA medical plans, ALL employees and their eligible family members receive nine free virtual doctor’s appointments with a physician through Teladoc, and 12 free annual therapy sessions with a licensed clinician through Spring Health.
TEGNA offers a generous Paid Time Off (PTO) benefit as well as nine paid holidays per year.
* Some jobs are covered by a collective bargaining agreement and thus some or all of the benefits described herein may not apply. For example, some newsroom bargaining unit employees receive health and retirement benefits under plans administered by the union.
EEO statement :
TEGNA Inc. is a proud equal opportunity employer. We are proud to be an equal opportunity employer, hiring and developing individuals from diverse backgrounds and experiences to add to our collaborative culture. We value and consider applications from all qualified candidates without regard to actual or perceived race, color, religion, national origin, sex, gender, age, marital status, personal appearance, sexual orientation, gender identity or expression, family responsibilities, disability, medical condition, enrollment in college or vocational school, political affiliation, military or veteran status, citizenship status, genetic information, or any other basis protected by federal, state or local law. TEGNA will reasonably accommodate qualified individuals with disabilities in accordance with applicable law. If you are in need of an accommodation in order to submit your application, please email [email protected]
Recruiting Fraud Alert:
To all candidates: your personal information and online safety are important to us. Only TEGNA Recruiters or Hiring Managers will reach out to you regarding consideration of your application or background. Communications with TEGNA employees will either come from a TEGNA email address with a domain of tegna.com or one of our affiliate station domains. Recruiters or Hiring Managers will never request payments, ask for financial account information or sensitive information such as social security numbers.
Recommended Jobs
Architectural Project Manager
We are currently seeking an Architectural Project Manager with a minimum of 10 years of experience with design for our Rochester, NY office. The candidate should have experience in Municipal / Public…
Part-Time Shift Supervisor, The Landing Family Shelter
Who We Are: CAMBA is a community of staff, volunteers, clients, donors, neighbors and partners who work together to build an inclusive New York City, where all children and adults have access to the…
Social Media Coordinator
Job Overview We are hiring a talented and creative individual to join our team as a Social Media Coordinator. Your main goal will be to supervise as well as coordinating with the social media ca…
Bus Operator TOP RATE $31.96/HR
You will start off with our training program where we will teach you how to drive our entire fleet! During this paid training at $27.17 pr hour and full benefits from day one, you will learn to driv…
Localytics | Enterprise Sales Lead
Mission of the Role Create and close Localytics’ next generation of enterprise customers. The Enterprise Sales Lead owns new enterprise revenue generation. This role is accountable for sourcing…
Fiber Sales Advisor
This isn’t your average sales gig. As a Fiber Sales Advisor for Frontier Communications, you’ll own your territory like a boss: pitching smarter, closing faster, and building client relationships tha…
Vice President, Global Capital Markets
Company Profile: Morgan Stanley is a leading global financial services firm providing a wide range of investment banking, securities, investment, and wealth management services. The Firm's emplo…
Assimilation & STC Coordinator, Sandy Springs Campus
About the role This is a full-time, Sunday–Thursday position at Christ Covenant. The purpose of this role is to oversee and execute the assimilation process at Christ Covenant Sandy Springs, guidi…
EMT Security agent - Part Time
EMT Security agent - Part Time » »
Technical Support Engineer - New York City
Location New York Office Employment Type Full time Location Type Hybrid Department Customer Success Compensation ~$110K – $150K • Offers Equity About Orb: Orb is tra…