Data Engineer Ii

Job Summary:
The Office of Informatics and Information Technology is looking for an outstanding candidate for a Data Engineer II position to contribute to the innovative informatics efforts of the School of Medicine and Public Health's Informatics group. Reporting to the Director of Research Data Services, the Data Engineer II will be responsible for supporting the clinical informatics needs of the Department of Anesthesiology. As part of the informatics team, the role of this data engineer will also be responsible for data quality assurance and quality control. Additionally, the incumbent will work to develop queries and data pipelines that translate research objectives into datasets. The successful candidate will have a solid work ethic and bring an enthusiastic and professional attitude to the workplace.
Responsibilities: Contributes to a research agenda set by a lead researcher by creating automated processes for preparing and analyzing data at scale. Plays a leadership role and may lead a team and/or personnel.

• 30% 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
• 15% Implements data analysis steps in collaboration with data scientists, statisticians, and/or other researchers and may use technologies that support data at scale
• 15% Organizes both data preparation and analysis steps into reproducible pipelines that can process similar data sets automatically
• 5% Selects appropriate technologies and optimizes pipelines for performance
• 20% Develops, constructs, tests, and maintains architectures for large-scale data management and analysis
• 15% 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

Institutional Statement on Diversity:
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.
For more information on diversity and inclusion on campus, please visit: Diversity and Inclusion
Education:
Preferred
Bachelor's Degree
Qualifications:
Required:
- 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
Preferred:
- Certified in Epic Cogito Clinical Data Model
- Experience with clinical vocabularies (ICD, LOINC, SNOMED, CPT, etc.)
- Experience Designing, Building & Maintaining Databases
- Experience with clinical research common data models (OMOP, i2b2, PCORNet)
- Knowledge of HIPAA and other regulations governing PHI
- Experience developing data pipelines with Microsoft Azure Data Factory
- Experience with FHIR and HL7 data feeds
- Experience developing Natural Language Processing algorithms
- Experience working with web APIs
- Experience reviewing other team member's technical work and providing constructive feedback
Strong communication and people skills are required. The ideal candidate is curious, self-motivated, and able to work with minimal supervision.The selected candidate must be committed to providing quality customer service and uphold SMPH core values of respect, integrity, teamwork, excellence, leadership, inclusivity, innovation, collaboration, accountability, and communication.
Work Type:
Full Time: 100%
It is anticipated this position will be remote and requires work be performed at an offsite, non-campus work location. An on campus location will be provided should a candidate prefer to work partially or fully onsite.
Appointment Type, Duration:
Ongoing/Renewable
Salary:
Minimum $80,000 ANNUAL (12 months)
Depending on Qualifications
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. Benefits information can be found at (
SMPH Academic Staff Benefits flyer: ( Additional Information:
University sponsorship is not available for this position, including transfers of sponsorship. 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. UW-Madison is not an E-Verify employer, and therefore, is not eligible to employ F1-OPT STEM Extension participants. If you are selected for this position you must provide proof of work authorization and eligibility to work.
How to Apply:
To apply for this position, please click on the "Apply Now" button. You will be asked to upload a current resume/CV and a cover letter briefly describing your qualifications and experience.
Contact:
Cody Roekle
608-263-7676
Relay Access (WTRS): 7-1-1. See RELAY_SERVICE for further information.
Official Title:
Data Engineer II(RE065)
Department(s):
A53-MEDICAL SCHOOL/Informatics and IT
Employment Class:
Academic Staff-Renewable
Job Number:
306510-AS