Programmer Analyst IV

610 Wake Forest University Baptist Medical Center; Winston-Salem (NC); Hybrid; USD 72,000 - 119,000; Full time

Benefits offered by this job

Health benefits

Educational Assistance Program

Flexible spending accounts

Retirement plan with employer match

Job summary

Wake Forest University Health Sciences is seeking an Analytics Engineer to build analytics-ready data products within a modern data stack. You will develop datasets with dbt and SQL, model data for downstream analysts, and ensure data quality across enterprise systems.

You will collaborate with stakeholders, analysts, and engineers to translate requirements into scalable solutions, contributing to data platform improvements and governance.

Qualifications

• Bachelor's degree in computer course and four years' experience in computer programming or operations research required; Or an equivalent combination of education and experience in computer programming.
• Experience with installation and maintenance of personal computers.

Responsibilities

• Develop and maintain analytics-ready datasets using dbt and SQL.
• Design dimensional models and semantic data structures that support downstream analysts.
• Implement data quality testing, documentation, and governance standards.
• Explore and model data across numerous enterprise systems, gaining visibility into intersections of domains.
• Partner with business stakeholders, analysts, and data engineers to translate requirements into scalable data solutions.
• Contribute to analytics engineering standards and data platform improvements.

Skills

SQL

Data modeling

dbt

Cloud data warehouses

Data quality

Git/CI-CD

Communication

Independent work

Education

Bachelor's degree in computer course

Tools

dbt

Snowflake

BigQuery

Databricks

Redshift

Git

CI/CD

Job description

Department: 85126 Wake Forest University Health Sciences - Academic Office of Informatics

Status: Full time

Benefits Eligible: Yes

Hours Per Week: 40

Schedule Details/Additional Information: 1st shift, Hybrid/remote eligible

Pay Range: $38.20 - $57.30

The Wake Forest University School of Medicine and the Office of Institutional Learning and Transformation is seeking an Analytics Engineer to work on their CAPTURE initiative to enable our faculty, staff, and leadership to continuously monitor and improve performance and effectiveness at the School and across the clinical enterprise. Working within a modern data stack, you will build and maintain trusted, analytics-ready data products that support reporting, decision-making, and advanced analytics initiatives. This role combines strong SQL and data modeling expertise with a focus on data quality, automation, and scalable design.

Job Summary

Under limited supervision, designs and implements large and complicated research information systems. Exhibits ability to learn to use a variety of research computer software tools and operating system environments. Provides computer systems maintenance support for an assigned department/section.

What You'll Do

• Develop and maintain analytics-ready datasets using dbt and SQL.
• Design dimensional models and semantic data structures that support downstream analysts.
• Implement data quality testing, documentation, and governance standards.
• Explore and model data across numerous enterprise systems, gaining unique visibility into how academic, clinical, financial, research, and operational domains intersect.
• Partner with business stakeholders, analysts, and data engineers to translate requirements into scalable data solutions.
• Contribute to analytics engineering standards and data platform improvements.

What We're Looking For

• Strong SQL and data modeling skills.
• Experience with dbt and cloud data warehouses such as Snowflake, BigQuery, Databricks, or Redshift.
• Experience with data quality testing, Git-based development, and CI/CD practices.
• Clear and direct communication skills about complex, technical topics.
• Demonstrated ability to work independently, take ownership of deliverables, and drive projects to completion with minimal supervision.

Education/Experience

Bachelor's degree in computer course and four years' experience in computer programming or operations research required; Or an equivalent combination of education and experience in computer programming. Experience with the installation and maintenance of personal computers.

Our Commitment to You

• Compensation Base compensation listed within the listed pay range based on factors such as qualifications, skills, relevant experience, and/or training
• Premium pay such as shift, on call, and more based on a teammate's job
• Incentive pay for select positions
• Opportunity for annual increases based on performance
• Benefits and more Paid Time Off programs
• Health and welfare benefits such as medical, dental, vision, life, and Short- and Long-Term Disability
• Flexible Spending Accounts for eligible health care and dependent care expenses
• Family benefits such as adoption assistance and paid parental leave
• Defined contribution retirement plans with employer match and other financial wellness programs
• Educational Assistance Program Note: Eligibility for programs listed above may depend on your FTE or status (e.g., full-time, part-time, per diem, temporary, etc.); please ask a Recruiter for more information during an interview.

About Advocate Health

Advocate Health is the third-largest nonprofit, integrated health system in the United States, created from the combination of Advocate Aurora Health and Atrium Health. Providing care under the names Advocate Health Care in Illinois; Atrium Health in the Carolinas, Georgia and Alabama; and Aurora Health Care in Wisconsin, Advocate Health is a national leader in clinical innovation, health outcomes, consumer experience and value-based care. Headquartered in Charlotte, North Carolina, Advocate Health services nearly 6 million patients and is engaged in hundreds of clinical trials and research studies, with Wake Forest University School of Medicine serving as the academic core of the enterprise. It is nationally recognized for its expertise in cardiology, neurosciences, oncology, pediatrics and rehabilitation, as well as organ transplants, burn treatments and specialized musculoskeletal programs. Advocate Health employs 155,000 teammates across 69 hospitals and over 1,000 care locations, and offers one of the nation’s largest graduate medical education programs with over 2,000 residents and fellows across more than 200 programs. Committed to providing equitable care for all, Advocate Health provides more than $6 billion in annual community benefits. This is Transformation One shared purpose brought us together. Now, as one of the 10 largest not-for-profit, integrated health systems in the United States, our combined strength and stability drives us forward. Starting with You Caring for nearly 3 million people has inspired a transformation. One in which the patient’s experience guides our vision and empowers us to offer new possibilities in our communities. Reshaping Access What is access? It's offering more sites of care than any other health system in the Midwest. But there's a new frontier. Access is exploring the latest technologies to deliver care to patients exactly where they are and exactly when they need it Inspiring Professionals With our dynamically inclusive workforce and strong connections to the places where we live and work, we'll touch more lives and contribute to stronger and more vibrant communities. Transforming Care We're redefining the standard for care with world-class doctors and caregivers, innovative solutions, outstanding outcomes, and leading-edge research and clinical trials. Combined, Advocate and Aurora are recognized for clinical excellence in: Cardiovascular Care Neurosciences Gynecology Oncology Pediatrics Primary Care Neurology Geriatrics Trauma Care