{"schemaVersion":"jobsearcher.job.v1","id":"c7449886d2bb7b359ffddee3","url":"https://jobsearcher.com/jobs/c7449886d2bb7b359ffddee3","canonicalUrl":"https://jobsearcher.com/jobs/c7449886d2bb7b359ffddee3","title":"Analytics Engineer","description":"Analytics EngineerOur client, a Media, Information and Services company, is looking for an Analytics Engineer for their Charlotte, NC/Hybrid location.\r\nResponsibilities: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.\r\nSemantic Modeling: Design and maintain the Microsoft Fabric Semantic Model (Direct Lake mode) to provide a \"Single Source of Truth\" across the entire organization.\r\nBusiness Logic Codification: Partner closely with Sales and Finance stakeholders to translate \"What\" and \"Why\" business questions into precise technical data definitions.\r\nAI Data Readiness: Structure data specifically for LLM consumption, enabling our AI Data Agents to accurately navigate complex hierarchies of stations, advertisers, and categories.\r\nData Governance & Security: Implement Row-Level Security (RLS) and maintain data lineage to ensure compliance with Hearst's unified data strategy.\r\nTechnical Leadership: Lead the design of project-specific data models, prepare design specifications, and conduct feature estimations in collaboration with cross-functional teams.\r\nOptimization & RCA: Perform root cause analysis on anomalies and implement solutions to minimize points of failure and optimize data pipeline performance.\r\nRequirements:Experience: 7+ years in business analytics, data modeling, or data engineering (or a Master's degree with 5+ years of experience).\r\nModeling Expertise: 5+ years of deep experience with relational modeling concepts and Microsoft tabular semantic models.\r\nTechnical Proficiency: Expert-level SQL skills and 5+ years of experience with Power BI, DAX, and Spark (Spark SQL/PySpark/Scala).\r\nPlatform Knowledge: Strong hands-on experience with Microsoft Fabric tools and the Delta Lake format.\r\nLogic & Design: Demonstrated experience translating complex business requirements into technical requirements using Star Schema/Dimensional modeling.\r\nDevOps: Familiarity with Git, CI/CD, and modern development workflows.\r\nCommunication: Proven ability to collaborate with stakeholders and escalate data requirements or constraints effectively.\r\nFamiliarity with governance, security best practices, and performance tuning in a cloud environment.\r\nExperience in the media or broadcasting industry is a plus.\r\nKnowledge of serverless architectures and containerized deployment.\r\nWhy Should You Apply?Health Benefits\r\nReferral Program\r\nExcellent growth and advancement opportunities","company":"ICONMA","rawCompany":"iconma","city":"Charlotte","state":"NC","isRemote":false,"isActive":false,"createdAt":"2026-08-07T01:30:37.380Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-2051.00","title":"Data Scientists","slug":"data-scientists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"541690","title":"Other Scientific and Technical Consulting Services","slug":"other-scientific-and-technical-consulting-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Analytics Engineer","description":"Analytics EngineerOur client, a Media, Information and Services company, is looking for an Analytics Engineer for their Charlotte, NC/Hybrid location.\r\nResponsibilities: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.\r\nSemantic Modeling: Design and maintain the Microsoft Fabric Semantic Model (Direct Lake mode) to provide a \"Single Source of Truth\" across the entire organization.\r\nBusiness Logic Codification: Partner closely with Sales and Finance stakeholders to translate \"What\" and \"Why\" business questions into precise technical data definitions.\r\nAI Data Readiness: Structure data specifically for LLM consumption, enabling our AI Data Agents to accurately navigate complex hierarchies of stations, advertisers, and categories.\r\nData Governance & Security: Implement Row-Level Security (RLS) and maintain data lineage to ensure compliance with Hearst's unified data strategy.\r\nTechnical Leadership: Lead the design of project-specific data models, prepare design specifications, and conduct feature estimations in collaboration with cross-functional teams.\r\nOptimization & RCA: Perform root cause analysis on anomalies and implement solutions to minimize points of failure and optimize data pipeline performance.\r\nRequirements:Experience: 7+ years in business analytics, data modeling, or data engineering (or a Master's degree with 5+ years of experience).\r\nModeling Expertise: 5+ years of deep experience with relational modeling concepts and Microsoft tabular semantic models.\r\nTechnical Proficiency: Expert-level SQL skills and 5+ years of experience with Power BI, DAX, and Spark (Spark SQL/PySpark/Scala).\r\nPlatform Knowledge: Strong hands-on experience with Microsoft Fabric tools and the Delta Lake format.\r\nLogic & Design: Demonstrated experience translating complex business requirements into technical requirements using Star Schema/Dimensional modeling.\r\nDevOps: Familiarity with Git, CI/CD, and modern development workflows.\r\nCommunication: Proven ability to collaborate with stakeholders and escalate data requirements or constraints effectively.\r\nFamiliarity with governance, security best practices, and performance tuning in a cloud environment.\r\nExperience in the media or broadcasting industry is a plus.\r\nKnowledge of serverless architectures and containerized deployment.\r\nWhy Should You Apply?Health Benefits\r\nReferral Program\r\nExcellent growth and advancement opportunities","datePosted":"2026-08-07T01:30:37.380Z","dateModified":"2026-08-07T01:30:37.380Z","hiringOrganization":{"@type":"Organization","name":"ICONMA","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Charlotte","addressRegion":"NC","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"c7449886d2bb7b359ffddee3"},"url":"https://jobsearcher.com/jobs/c7449886d2bb7b359ffddee3"}}