Hearst Health

Data and Automation Analyst 2

Hearst Health

full-time

Posted on:

Location Type: Hybrid

Location: Dallas • Texas • United States

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

ETLSQL

About the role

  • Design, build, and maintain Dataverse tables (schema, relationships, data standards, and documentation) to support reporting and automation use cases
  • Develop and enhance Power BI dashboards (data modeling, DAX measures, visuals, performance tuning, and publishing)
  • Write and maintain custom SQL queries and reports to support operational and analytical needs
  • Support automation data flows (data movement, transformations, refresh reliability, and monitoring) in partnership with the Intelligent Automation team
  • Gather, clarify, and document requirements; translate them into scalable reporting and data solutions
  • Perform validation and testing to ensure accuracy, consistency, and usability of dashboards and reports
  • Create and maintain documentation (data definitions, report logic, refresh schedules, and support runbooks)
  • Collaborate cross-functionally with business partners, analysts, engineers, and automation developers to deliver end-to-end solutions
  • Demonstrate strong ownership, prioritize effectively, and meet delivery timelines while maintaining quality standards

Requirements

  • 3+ years of experience in analytics/reporting, BI, or data automation support roles
  • Strong SQL skills (joins, CTEs, aggregations, query optimization, validation)
  • Strong experience building dashboards in Power BI (data modeling and DAX)
  • Experience designing or working with Dataverse tables and relationships (or equivalent relational modeling experience with the ability to ramp quickly)
  • Ability to translate business requirements into data models, reports, and dashboards
  • Strong attention to detail and a consistent approach to testing and data validation
  • Clear communication skills and comfort working directly with stakeholders
  • Familiarity with data integration/ETL concepts and scheduled refresh patterns
  • Experience supporting automation initiatives (e.g., reporting for automation, operational metrics, data pipelines feeding automations)
Benefits
  • Competitive pay
  • Robust benefits
  • Professional development opportunities
  • Meaningful work
  • Flexibility in work-life balance
  • Opportunity to work remotely for qualified candidates
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLDAXdata modelingreportingdata automationdata validationETLdashboard developmentDataverseperformance tuning
Soft Skills
communicationattention to detailownershipprioritizationcollaborationrequirement gatheringdocumentationtestingstakeholder engagementproblem-solving