Advanced Analytics Engineer Senior

What We Offer

Join Novant Health's Enterprise Analytics team and help build scalable data solutions that drive smarter healthcare decisions. As an Advanced Analytics Engineer Senior, you will design, develop, and support enterprise data products that transform complex data into trusted, analytics-ready assets for reporting, dashboards, and advanced analytics.

Schedule: 8:00AM – 5:00PM

Location: Remote

Department: SPX Governance

Key Responsibilities:

• Design, build, test, and maintain scalable data products and dimensional data models.
• Develop curated datasets, data marts, and reusable analytics solutions.
• Optimize data for Power BI and other reporting and analytics platforms.
• Collaborate with business and technical teams to deliver high-quality data solutions.
• Ensure data quality, governance, security, performance, and reliability.
• Mentor junior team members and promote data engineering best practices.

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. Graduate Degree, preferred. Master’s degree in computer science or information systems
• Experience: Minimum five years of analytics engineering, data engineering, data warehousing, analytics development, and/or business intelligence experience, required.
• Additional Skills/Requirements (required):
  • Proficiency in SQL, Python, PySpark, Spark SQL, Delta Lake, and Databricks for data transformation and analytics engineering
  • Strong knowledge of dimensional modeling, including facts, dimensions, conformed dimensions, bridges, aggregates, surrogate keys, slowly changing dimensions, and data grain
  • Experience developing curated data marts and reusable analytics assets using medallion architecture patterns
  • Experience building modular, maintainable transformation code for batch and incremental processing
  • Experience with orchestration and scheduling technologies such as Apache Airflow, Databricks Workflows, or similar tools, including dependency management and exception handling
  • Experience with Azure DevOps, Git, pull requests, code review, and CI/CD across development, UAT, and production
  • Understanding of data quality engineering, including unit testing, reconciliation, referential-integrity validation, and regression testing
  • Experience applying Databricks Unity Catalog, lineage, metadata, and secure access patterns to data products
  • Understanding of PHI/PII protection and healthcare privacy and security requirements
  • Ability to translate clinical, operational, and financial requirements into models, transformation rules, and acceptance criteria
  • Strong documentation, problem-solving, and communication skills
• Additional Skills/Requirements (preferred):
  • Experience with Epic source data, including Clarity and Caboodle, and understanding of healthcare workflows and data domains
  • Experience supporting Power BI semantic models and DirectQuery performance
  • Experience with Delta Live Tables, APIs, or Azure Data Lake Storage
  • Experience with healthcare interoperability formats and standards such as HL7, FHIR, JSON, XML, and Parquet
  • Experience with dbt or comparable analytics engineering transformation and testing frameworks