Analytics Engineer

Department
85000 Wake Forest University Health Sciences - Academic Deans Office

Status
Full time

Benefits Eligible
Yes

Hours Per Week
40

Schedule Details/Additional Information
1st shift

Pay Range
$33.05 - $49.60

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  
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.

• Oversees all phases of database design, development, management and reporting for medium-sized projects.
• Consults with users on project design needs. Maintains a professional relationship with project personnel.
• Maintains software and troubleshoot simple software products.
• Performs a range of ad hoc queries to databases and the implementation of automated reporting schemes. Analyzes quality control needs of moderate sized projects.
• Performs a wide variety of data transfers and conversions.
• Creates and maintains user manuals and documentation of software products.
• Designs and implements a comprehensive software testing plan for software products.
• Performs other related duties incidental to work described herein.

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.

N/A

• 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.

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

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:

• 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

• 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

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…