Note: The job is a remote job and is open to candidates in USA. Novant Health is hiring an Advanced Analytics Engineer Senior for its Enterprise Analytics team. The role designs, develops, and supports enterprise data products that turn complex healthcare data into trusted assets for reporting, dashboards, and advanced analytics.
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
Skills
- 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
- Minimum five years of analytics engineering, data engineering, data warehousing, analytics development, and/or business intelligence experience, 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
- Graduate Degree, preferred. Master's degree in computer science or information systems
- 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
Benefits
- Remote work
Company Overview
Company H1B Sponsorship