Über
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.
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klicken Sie auf „Jetzt Bewerben“, um Ihre Bewerbung direkt auf deren Website einzureichen.