Analytics Engineer: Data Models, SQL & DW

Atrium Health Wake Forest Baptist; Winston-Salem (NC); Hybrid; USD 52,000 - 79,000; Full time

Benefits offered by this job

Paid Time Off

Health and welfare benefits

Flexible Spending Accounts

Family benefits and parental leave

Retirement plans with employer match

Educational Assistance Program

Job summary

Advocate Health is seeking an Analytics Engineer to build analytics-ready datasets using dbt and SQL within a hybrid/remote-friendly environment. You will design dimensional models and governance practices while collaborating with analysts, data engineers, and business stakeholders to deliver scalable data solutions across academic, clinical, and operational domains.

The role emphasizes data quality, automation, and a modern data stack to support reporting and advanced analytics across the

Qualifications

• Bachelor's degree in computer science or related field with 4+ years of programming or related experience.

Responsibilities

• Develop and maintain analytics-ready datasets using dbt and SQL.
• Design dimensional models and semantic data structures to support downstream analysts.
• Implement data quality testing, documentation, and governance standards.
• Model data across enterprise systems to connect academic, clinical, financial, research, and operations domains.
• Partner with stakeholders and data engineers to translate requirements into scalable data solutions.
• Contribute to analytics engineering standards and data platform improvements.

Skills

SQL

Data modeling

Data quality testing

Git-based development

CI/CD

Communication

Independent work

Education

Bachelor's degree in computer science or related field

Tools

dbt

Snowflake

BigQuery

Databricks

Redshift

Job description

Advocate Health is seeking an Analytics Engineer to build analytics-ready datasets using dbt and SQL within a hybrid/remote-friendly environment. You will design dimensional models and governance practices while collaborating with analysts, data engineers, and business stakeholders to deliver scalable data solutions across academic, clinical, and operational domains.

The role emphasizes data quality, automation, and a modern data stack to support reporting and advanced analytics across the