Note: The job is a remote job and is open to candidates in USA. Novant Health is hiring an Advanced Analytics Engineer Intermediate to build and support analytics-ready data products that enable reporting and data-driven decision-making. The role develops trusted, reusable datasets and dimensional models, makes design decisions within established standards, and ensures data quality, security, documentation, and production reliability.

Responsibilities

• Design, build, test, and maintain scalable data products and dimensional data models
• Build curated datasets, fact and dimension tables, and data marts using modern data engineering practices
• Transform structured data into trusted, reusable assets for analytics and reporting
• Make design and implementation decisions within established engineering frameworks
• Collaborate with senior Analytics Engineers on complex and cross-domain solutions
• Ensure data quality, security, documentation, and production reliability

Skills

• Experience with data warehousing, dimensional modeling, and data engineering
• Strong SQL skills and experience with cloud-based data platforms
• Passion for solving complex data challenges and delivering business value
• 4 Year / Bachelors Degree, required
• Bachelor's degree in computer science or information systems required
• In lieu of a bachelor's degree, four (4) years of additional relevant experience, beyond the minimum experience requirement, will be considered
• Three years, required
• Working experience in SQL and Python, with exposure to PySpark, Spark SQL, Delta Lake, and Databricks
• Understanding of dimensional modeling concepts, including facts, dimensions, surrogate keys, slowly changing dimensions, and data grain
• Familiarity with medallion architecture patterns and curated data marts
• Exposure to orchestration and scheduling tools such as Apache Airflow, Databricks Workflows, or similar
• Familiarity with Git, pull requests, code review, and CI/CD practices
• Understanding of data quality practices, including unit testing, reconciliation, and completeness checks
• Awareness of PHI/PII protection and healthcare privacy and security requirements
• Ability to analyze requirements and determine appropriate transformation logic, data structures, and test approaches
• Strong documentation, problem-solving, and communication skills
• Hands-on experience with Databricks, Unity Catalog, and Power BI preferred
• Exposure to Epic source data, including Clarity and Caboodle, and healthcare data domains
• Familiarity with Databricks Unity Catalog, lineage, and metadata concepts
• Exposure to Power BI semantic models and DirectQuery
• Familiarity with dbt or comparable analytics engineering transformation and testing frameworks

Benefits

• Remote work

Company Overview

Company H1B Sponsorship