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 DatabricksUnderstanding of dimensional modeling concepts, including facts, dimensions, surrogate keys, slowly changing dimensions, and data grainFamiliarity with medallion architecture patterns and curated data martsExposure to orchestration and scheduling tools such as Apache Airflow, Databricks Workflows, or similarFamiliarity with Git, pull requests, code review, and CI/CD practicesUnderstanding of data quality practices, including unit testing, reconciliation, and completeness checksAwareness of PHI/PII protection and healthcare privacy and security requirementsAbility to analyze requirements and determine appropriate transformation logic, data structures, and test approachesStrong documentation, problem-solving, and communication skillsAdditional Skills/Requirements (preferred):Exposure to Epic source data, including Clarity and Caboodle, and healthcare data domainsFamiliarity with Databricks Unity Catalog, lineage, and metadata conceptsExposure to Power BI semantic models and DirectQueryFamiliarity with dbt or comparable analytics engineering transformation and testing frameworks Why Choose Novant Health? At Novant Health, we believe remarkable care starts with compassion for our patients, our communities, and each other. We value belonging, courage, personal growth, and teamwork, creating a space where everyone is respected, supported, and safe to show up as their full selves. Job Opening ID 196702