About the role
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 Monday - Friday (On call support required as needed)
Location: Remote
Department: SPX Governance
**No immigration sponsorship available for this role.**
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 Do
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
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
196702Originally posted on Himalayas