Programmer Analyst IV
About The Position
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. 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.
Requirements
- 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.
- 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.
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 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.
Benefits
- Comprehensive suite of Total Rewards: benefits and well-being programs
- Competitive compensation
- Generous retirement offerings
- Programs that invest in your career development
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
