Analytics Engineer
Location: Charlotte, NC, United States
Hearst Television (HTV) is hiring an Analytics Engineer. The ideal candidate will act as the vital bridge between raw data and executive insights. You will take "Bronze" data and transform it into high-value Silver (Cleansed) and Gold (Aggregated) layers. Your primary goal is to codify complex media sales logic such as Revenue Pacing, Share of Wallet, and Yield into high-performance Semantic Models that power our Power BI dashboards and AI Data Agents. This role ensures our data is not just accessible, but actionable and intelligent.
What You’ll Do
· Medallion Transformation: Use Spark and SQL to architect the Silver and Gold layers of our Lakehouse, ensuring all data is rigorously tested, clean, and documented.
· Semantic Modeling: Design and maintain the Microsoft Fabric Semantic Model (Direct Lake mode) to provide a "Single Source of Truth" across the entire organization.
· Business Logic Codification: Partner closely with Sales and Finance stakeholders to translate "What" and "Why" business questions into precise technical data definitions.
· AI Data Readiness: Structure data specifically for LLM consumption, enabling our AI Data Agents to accurately navigate complex hierarchies of stations, advertisers, and categories.
· Data Governance & Security: Implement Row-Level Security (RLS) and maintain data lineage to ensure compliance with Hearst’s unified data strategy.
· Technical Leadership: Lead the design of project-specific data models, prepare design specifications, and conduct feature estimations in collaboration with cross-functional teams.
· Optimization & RCA: Perform root cause analysis on anomalies and implement solutions to minimize points of failure and optimize data pipeline performance.
Requirements
· Experience: 7+ years in business analytics, data modeling, or data engineering (or a Master’s degree with 5+ years of experience).
· Modeling Expertise: 5+ years of deep experience with relational modeling concepts and Microsoft tabular semantic models.
· Technical Proficiency: Expert-level SQL skills and 5+ years of experience with Power BI, DAX, and Spark (Spark SQL/PySpark/Scala).
· Platform Knowledge: Strong hands-on experience with Microsoft Fabric tools and the Delta Lake format.
· Logic & Design: Demonstrated experience translating complex business requirements into technical requirements using Star Schema/Dimensional modeling.
· DevOps: Familiarity with Git, CI/CD, and modern development workflows.
· Communication: Proven ability to collaborate with stakeholders and escalate data requirements or constraints effectively.
Preferred Qualifications
· Familiarity with governance, security best practices, and performance tuning in a cloud environment.
· Experience in the media or broadcasting industry is a plus.
· Knowledge of serverless architectures and containerized deployment.
Values in Action
At Hearst Television we tell stories every day. Stories about people of all backgrounds, perspectives, and identities. That’s why, behind the scenes, we believe in being an organization that fosters collaboration and open communication, ensuring that the content we create is authentic, accurate, and connected to the communities we serve.
Benefits
Hearst's benefit programs are modern, flexible and designed to focus on you. As a Hearst employee, you and your spouse or partner or dependents would have access to the following benefits:
· Medical | Dental | Vision
· 401(k) matching
· Emotional Wellness Support
· Paid Time Off & Parental Leave
· LGBTQ+ Health Services
About Us
We are an Equal Opportunity Employer. we do not discriminate in hiring on the basis of sex, gender identity, sexual orientation, race, color, religion, creed, national, origin, physical or mental disability, protected veteran status, or any other characteristic protected by federal, state, or local law.
There are more than 50,000 engineering jobs:
Subscribe to membership and unlock all jobs
Engineering Jobs
60,000+ jobs from 4,500+ well-funded companies
Updated Daily
New jobs are added every day as companies post them
Refined Search
Use filters like skill, location, etc to narrow results
Become a member
🥳🥳🥳 452 happy customers and counting...
Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.
To try it out
For active job seekers
For those who are passive looking
Cancel anytime
Frequently Asked Questions
- We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
- We've got over 200,000 jobs from 15,000+ vetted companies. No fake or sleazy jobs here!
- We aggregate jobs from 15,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
- We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
- Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
- Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
- Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅
What Fellow Engineers Say