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