Analytics Engineer

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 stake...