This job offer is no longer available
About
Hearst Television (HTV) is hiring an Analytics Engineer who will serve as the crucial link between raw data and executive insights. The primary responsibilities include transforming data into high-value layers, designing semantic models, and ensuring data governance and security.
Responsibilities : • 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.
Qualifications : Required : • 7+ years in business analytics, data modeling, or data engineering (or a Master’s degree with 5+ years of experience). • 5+ years of deep experience with relational modeling concepts and Microsoft tabular semantic models. • Expert-level SQL skills and 5+ years of experience with Power BI, DAX, and Spark (Spark SQL/PySpark/Scala). • Strong hands-on experience with Microsoft Fabric tools and the Delta Lake format. • Demonstrated experience translating complex business requirements into technical requirements using Star Schema/Dimensional modeling. • Familiarity with Git, CI/CD, and modern development workflows. • Proven ability to collaborate with stakeholders and escalate data requirements or constraints effectively.
Preferred : • 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.
Company :
We’re ambitious. We’re smart. We want to be the best, to put our mark on every story we tell and every project we take on. Founded in , the company is headquartered in Charlotte, North Carolina, US, , with a team of 51-200 employees. The company is currently Growth Stage.
Languages
- English
Notice for Users
This job was posted by one of our partners. You can view the original job source here.