Advanced Analytics Engineer Intermediate

What We Offer

As an Advanced Analytics Engineer Intermediate, you will design, build, deploy, and support analytics-ready data products that power reporting, analytics, and data-driven decision-making across Novant Health. Working within our enterprise data environment, you will transform structured data into trusted, reusable assets, including dimensional models, curated datasets, and data marts delivered through Databricks Unity Catalog.

In this role, you will independently own assigned data solutions, make design and implementation decisions using established engineering standards, and collaborate with senior Analytics Engineers on more complex or cross-domain solutions. You will also ensure your data products meet high standards for quality, security, documentation, and production reliability.

Schedule: 8:00AM – 5:00PM

Location: Remote

Department: SPX Governance

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

What You'll Bring:

• Experience with data warehousing, dimensional modeling, and data engineering.
• Strong SQL skills and experience with cloud-based data platforms.
• Hands-on experience with Databricks, Unity Catalog, and Power BI preferred.
• Passion for solving complex data challenges and delivering business value.

What We're Looking For

• Education: 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.
• Experience: Three years, 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.
• Additional Skills/Requirements (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
• Additional Skills/Requirements (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