Hearst Magazines Logo

Hearst Magazines

Analytics Engineer

Posted 12 Hours Ago
Be an Early Applicant
In-Office
Charlotte, NC, USA
Senior level
In-Office
Charlotte, NC, USA
Senior level
Build and optimize Silver and Gold data layers using Spark and SQL; design Microsoft Fabric semantic models in Direct Lake mode; codify media sales and finance logic; prepare data for AI agents; implement row-level security and lineage; lead data model design; perform root cause analysis; and improve pipeline performance while collaborating with cross-functional stakeholders.
The summary above was generated by AI

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
Hearst Television (HTV) owns and/or operates 35 television and two radio stations serving 27 media markets across 39 states reaching over 22 million U.S. television households. HTV is recognized as one of the industry's premier broadcasting companies and has been honored with numerous awards for distinguished journalism, industry innovation, and community service.
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.

Similar Jobs

11 Hours Ago
Remote or Hybrid
United States
97K-146K Annually
Senior level
97K-146K Annually
Senior level
Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Analyze and automate supplier-quality data using ETL tools, dashboards, KPIs, and statistical techniques. Build actionable insights and predictive reporting for quality, engineering, production, and leadership teams. Collaborate cross-functionally on continuous improvement, coach employees on data-driven decision-making, deliver presentations, and document analytical processes. The role requires expertise in Alteryx or comparable ETL tools, Tableau or Power BI, SQL or Python, UX/UI design, and supplier-quality analytics.
Top Skills: AlteryxPower BIPythonReactSQLTableau
Yesterday
In-Office
Charlotte, NC, USA
Mid level
Mid level
Consulting
Develop and maintain ETL/ELT pipelines, integrate and transform enterprise data, and support data lakes, warehouses, BI platforms, semantic layers, dashboards, and reporting solutions. Perform data quality validation, metadata documentation, lineage tracking, pipeline monitoring, query troubleshooting, and production support. Collaborate with business and technical stakeholders to deliver scalable analytics solutions using Databricks, ODI, SQL, Python, Power BI, OAS, and Tableau.
Top Skills: DatabricksEtl/EltOracle Analytics Server (Oas)Oracle Data Integrator (Odi)Power BIPythonSemossSQLTableau
3 Days Ago
In-Office
79K-177K Annually
Senior level
79K-177K Annually
Senior level
Healthtech • Biotech
Develop and manage AVEVA PI data historian infrastructure, asset frameworks, dashboards, pipelines, and integrations in a GMP-regulated pharmaceutical manufacturing environment. Administer, secure, validate, patch, and monitor systems while supporting analytics, troubleshooting, investigations, and process optimization. Partner with IT and automation teams on high availability, disaster recovery, cybersecurity, projects, training, and technical support. The role includes onsite work, up to 30% project travel, and occasional on-call support.
Top Skills: 21 Cfr Part 11Aveva PiCgmp Annex 11EmersonErpGmpGxpHighbyteHivemqJSONLimsMosquittoMqttOpcOsi Pi SystemPharmasuitePi Analysis ServicePi Asset FrameworkPi Data ArchivePi VisionPlmPythonRdbmsRest ApiRockwellSAPSeeqSyncadeXML

What you need to know about the Charlotte Tech Scene

Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.

Key Facts About Charlotte Tech

  • Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
  • Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
  • Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
  • Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
  • Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account