Data Engineer II

The Office of Informatics and Information Technology (IIT) is seeking an outstanding candidate for a Data Engineer II position to manage and fulfill research data needs for a grant funded project. The responsibilities of the incumbent will include gathering requirements, developing code, retrieving data from Epic's reporting databases, transforming data, and maintaining documentation. The ideal candidate will demonstrate a strong work ethic and a professional, enthusiastic attitude. This role is contingent upon external grant funding and is expected to last for two years.

We are currently seeking to fill two open positions: one with a primary focus on Radiological image analysis and the other centered on data science. Each role offers unique opportunities to contribute to innovative research and development within our team.

• It is anticipated that this position will be remote and requires work be performed at an offsite, non-campus work location.
• Terminal, 24 month position.
• This position has the possibility to be extended or converted to an ongoing appointment based on need and/or funding.

• Implements data analysis steps in collaboration with data scientists, statisticians, and/or other researchers and may use technologies that support data at scale

• Selects appropriate technologies and optimizes pipelines for performance

• Serves as an institutional subject matter expert and liaison to key internal and external stakeholders regarding automated data management and analysis at scale for research and represents the interests of large-scale data management and analysis for research

• Organizes both data preparation and analysis steps into reproducible pipelines that can process similar data sets automatically

• Prepares data sets for current and future analysis including cleaning/quality assurance, transformations, restructuring, and integration of multiple data sources and may use technologies that support data at scale

• Develops, constructs, tests, and maintains architectures for large-scale data management and analysis

School of Medicine and Public Health, Office of Informatics and Information Technology, Research Data Services.

This position is within the School of Medicine and Public Health's Office of Informatics and Information Technology (IIT). IIT is a multidisciplinary team of data scientists, engineers, developers, and IT support staff. We offer a variety of Informatics and IT services to departments and research staff within the School of Medicine and Public Health and beyond to support the conduct of high-quality clinical and translational research.

• Informatics: We provide innovative solutions and training for a broad spectrum of clinical and translational research utilizing real-world data to facilitate rapid translation of research findings into clinical practice, with an emphasis on precision medicine, healthcare delivery, and population health.

• Technology Solutions: We provide technology solutions to the School of Medicine and Public Health including cybersecurity, educational technology, and IT support.

This role is part of the Clinical Research Data Services (CRDS) team within SMPH-IIT. The CRDS team plays a critical role in advancing clinical research across SMPH by providing comprehensive data and computational support to investigators and research teams. CRDS team members provide support with research design, data extractions, data transformation and compute needs.

CRDS is dedicated to enabling high-quality, data-driven research. The CRDS team collaborates with faculty, staff, and research partners to ensure studies are designed and executed using robust data strategies. Services include support for research design, data extraction and integration from sources such as electronic health records, data transformation and analysis to create research ready datasets.

This position and the CRDS team offer the opportunity to work in a collaborative, interdisciplinary environment that values innovation, precision, and impact in clinical research.

The starting salary for the position is $80,000; but is negotiable based on experience and qualifications.

Employees in this position can expect to receive benefits such as generous vacation, holidays, and sick leave; competitive insurances and savings accounts; retirement benefits. For more information, refer to the campus benefits webpage and the SMPH Academic Staff Benefits Flyer

• Experience writing SQL code to extract and manipulate data from large relational databases
• Experience writing Python code to manipulate and analyze datasets
• Experience developing analytics dashboards
• Strong organizational, analytical, verbal and written communication skills, and interpersonal skills
• Experience working with Electronic Medical Records (EMR)/Electronic Health Records (EHR)

• Certified in Epic Cogito / Clarity / Caboodle
• Data science or biostatistics experience
• Experience working with medical images and associated reports
• Experience designing, building, and maintaining databases
• Experience with clinical vocabularies (ICD, LOINC, SNOMED, CPT, etc.)
• Experience with clinical research common data models (OMOP, i2b2, PCORNet)
• Experience working with web APIs
• Experience with FHIR and HL7 data feeds
• Knowledge of HIPAA and other regulations governing PHI
• Experience reviewing other team members' technical work and providing constructive feedback

Bachelor's degree preferred

For the best experience completing your application, we recommend using Chrome or Firefox as your web browser.

To apply for this position, select either "I am a current employee" or "I am not a current employee" under Apply Now. You will then be prompted to upload your application materials.

Important: The application has only one attachment field. Upload all required documents in that field, either as a single combined file or as multiple files in the same upload area.

Upload required documents:
* Cover letter
* Resume

Your cover letter should address how your training and experience align with the required and preferred qualifications listed above. Application reviewers will rely on these written materials to determine which applicants move forward in the process. References will be requested from final candidates. All applicants will be notified once the search concludes and a candidate is selected

University sponsorship is not available for this position, including transfers of sponsorship and TN visas. The selected applicant will be responsible for ensuring their continuous eligibility to work in the United States (i.e. a citizen or national of the United States, a lawful permanent resident, a foreign national authorized to work in the United States without the need of an employer sponsorship) on or before the effective date of appointment. This position is an ongoing position that will require continuous work eligibility. If you are selected for this position you must provide proof of work authorization and eligibility to work.

Cody Roekle, croekle@wisc.edu 608-263-7676

Relay Access (WTRS): 7-1-1. See RELAY_SERVICE for further information.

Diversity is a source of strength, creativity, and innovation for UW-Madison. We value the contributions of each person and respect the profound ways their identity, culture, background, experience, status, abilities, and opinion enrich the university community. We commit ourselves to the pursuit of excellence in teaching, research, outreach, and diversity as inextricably linked goals.

The University of Wisconsin-Madison fulfills its public mission by creating a welcoming and inclusive community for people from every background - people who as students, faculty, and staff serve Wisconsin and the world.

The University of Wisconsin-Madison is an Equal Opportunity Employer.

Qualified applicants will receive consideration for employment without regard to, including but not limited to, race, color, religion, sex, sexual orientation, national origin, age, pregnancy, disability, or status as a protected veteran and other bases as defined by federal regulations and UW System policies. We promote excellence by acknowledging skills and expertise from all backgrounds and encourage all qualified individuals to apply. For more information regarding applicant and employee rights and to view federal and state required postings, visit the Human Resources Workplace Poster website.

To request a disability or pregnancy-related accommodation for any step in the hiring process (e.g., application, interview, pre-employment testing, etc.), please contact the Divisional Disability Representative (DDR) in the division you are applying to. Please make your request as soon as possible to help the university respond most effectively to you.

Employment may require a criminal background check. It may also require your references to answer questions regarding misconduct, including sexual violence and sexual harassment.

The University of Wisconsin System will not reveal the identities of applicants who request confidentiality in writing, except that the identity of the successful candidate will be released. See Wis. Stat. sec. 19.36(7).

The Annual Security and Fire Safety Report contains current campus safety and disciplinary policies, crime statistics for the previous 3 calendar years, and on-campus student housing fire safety policies and fire statistics for the previous 3 calendar years. UW-Madison will provide a paper copy upon request; please contact the University of Wisconsin Police Department.