Analytics Engineer

Talentify; Charlotte (NC); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Health Benefits

Referral Program

Excellent growth opportunities

Job summary

Hearst is seeking an Analytics Engineer in Charlotte, NC, offering a hybrid work setup. You will architect data pipelines, build semantic models in Microsoft Fabric, and translate complex business needs into precise data definitions across Sales, Finance, and operations.

The role requires deep expertise in SQL, Power BI, Spark, and data modeling, with strong governance and DevOps experience. Collaboration with cross-functional teams is essential for scalable data solutions.

Qualifications

• 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.
• Experience translating complex business requirements into technical data definitions using Star Schema/Dimensional modeling.
• Familiarity with governance, security best practices, and performance tuning in a cloud environment.
• DevOps: Git, CI/CD, and modern development workflows.
• Excellent communication and ability to escalate data requirements effectively.

Responsibilities

• Architect Silver/Gold layers of a Lakehouse using Spark and SQL with rigorous testing and documentation.
• Design and maintain the Microsoft Fabric Semantic Model (Direct Lake mode) for a single source of truth.
• Translate business questions into precise technical data definitions with Sales and Finance stakeholders.
• Structure data for AI Data Agents and enable navigation of hierarchies of stations, advertisers, and categories.
• Implement Row-Level Security and maintain data lineage for governance and security.
• Lead data model designs, prepare design specs, and conduct feature estimations with cross-functional teams.
• Perform root cause analysis on data anomalies and optimize pipeline performance.

Skills

SQL

Power BI

DAX

Spark

Microsoft Fabric

Delta Lake

Relational modeling

Star schema

CI/CD

Git

Education

Master’s degree

Tools

PySpark

Scala

Spark SQL

Microsoft Fabric tools

Job description

Our client, a Media, Information and Services company, is looking for a Analytics Engineer for their Charlotte , NC/Hybrid location.

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.

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

Why Should You Apply?

• Health Benefits
• Referral Program
• Excellent growth and advancement opportunities