Data Analyst - Advertiser

TEGNA Inc. • Tysons, VA

10h • $110,000 - $140,000

About The Position

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 the b, you will be the technical architect of our revenue truth. Sitting within the Data & AI workstream, you will lead the integration of our CRM and Traffic systems into a unified Revenue Semantic Layer in Snowflake.
A core component of this role involves managing and evolving our custom Master Data Application built on Salesforce, ensuring that data flowing from Wide Orbit and our CRM remains clean, socialized, and actionable for the entire Sales organization.

Requirements

• Experience: Approx. 5 years in revenue analytics or analytics engineering within the media industry.
• System Expertise: Significant experience with Salesforce data structures and Wide Orbit (Traffic/Network/Sellers) data outputs.
• Technical Mastery: Advanced SQL (Snowflake) and expert-level dbt skills. High proficiency in Tableau Cloud.
• Communication: Proven ability to "socialize" data and manage master data hygiene across multiple platforms.

Responsibilities

• Master Data Stewardship: Manage, socialize, and evolve our proprietary Master Data Application (Salesforce-based). Ensure account hierarchies, advertiser mapping, and agency relationships are synchronized across all platforms.
• System Integration: Use dbt to model and join complex data sets from Salesforce (CRM) and Wide Orbit (Traffic/Media Sales) into Snowflake.
• Semantic Modeling: Maintain the "Single Source of Truth" for revenue metrics, ensuring that a "booked" dollar in Wide Orbit matches the "closed-won" opportunity in Salesforce.
• End-to-End Analytics: Build Tableau Cloud dashboards that track the full sales lifecycle—from pipeline health in Salesforce to execution and pacing in Wide Orbit.
• Yield & Inventory Optimization: Analyze fill rates and sell-through levels to help the Yield team maximize the value of every spot and impression.
• Requirement Engineering: Partner with Ad Ops, Finance, and Sales leadership to translate business needs into technical user stories.
• Application Evangelism: Act as the primary advocate for our Master Data Application, training business users on its importance and gathering feedback for its continuous evolution.
• Cross-Functional Training: "Socialize" unified revenue data across departments, ensuring Sales and Finance are aligned on definitions for net vs. gross revenue.

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed