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