Analytics Engineer

85000 Wake Forest University Health Sciences - Academic Deans Office

Full time

Yes

40

1st shift

Pay Range

$32.45 - $48.70

To achieve excellence and guide strategy, Wake Forest University School of Medicine (WFUSM) seeks to have measurable, transparent, and scalable indicators of our growth and performance in core missions of education, research, and academically integrated clinical care. The CAPTURE (Centralized Analytic Platform for Performance, Transparency, Utilization, and Real-Time Excellence) initiative will develop a series of integrated data dashboards across our core missions, enabling faculty, staff, and leadership to continuously monitor and improve their performance and effectiveness at the School and across the clinical enterprise. 

 

The DIVE team (Data, Integration, Visualization, Evaluation) is seeking an analytics engineer to drive growth and maintenance of education and research data warehouses, academic applications, and the informatics components of strategic projects. This role will specifically support the CAPTURE initiative under the leadership of the inaugural Office of Institutional Learning and Transformation at WFUSM.

 

The analytics engineer will be responsible for transforming raw data into robust, high-level models that support reporting and dashboard creation. This role emphasizes model design and implementation, data quality, standardization, and documentation. The analytics engineer will collaborate closely with data engineers and BI/reporting teams, apply strong SQL and dimensional modeling skills, and may develop subject matter expertise in specific data domains while maintaining broad familiarity to ensure cross-team support and avoid silos.

 

EDUCATION/EXPERIENCE:

Bachelor's degree with computer courses and three years' experience in computer programming or operations research; or, an equivalent combination of education and experience in computer programming.

 

LICENSURE, CERTIFICATION, and/or REGISTRATION: N/A ESSENTIAL FUNCTIONS:

1. Oversees all phases of database design, development, management and reporting for medium-sized projects.

2. Consults with users on project design needs. Maintains a professional relationship with project personnel.

3. Maintains software and troubleshoot simple software products.

4. Performs a range of ad hoc queries to databases and the implementation of automated reporting schemes. Analyzes quality control needs of moderate sized projects.

5. Performs a wide variety of data transfers and conversions.

6. Creates and maintains user manuals and documentation of software products.

7. Design and implements a comprehensive software testing plan for software products.

8. Performs other related duties incidental to work described herein.

 

SKILLS/QUALIFICATIONS:

• Strong initiative and proven ability to work independently.

• Ability to communicate on a professional level with customers and staff.

• Superior problem solving skills.

• Proficiency in Python required, Snowflake and dbt core preferred.

 

WORK ENVIRONMENT:

Comfortable, well-lit office setting Occasionally subject to long and/or irregular hours Subject to interruptions.

Our Commitment to You:

Advocate Health offers a comprehensive suite of Total Rewards: benefits and well-being programs, competitive compensation, generous retirement offerings, programs that invest in your career development and so much more – so you can live fully at and away from work, including:

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