Data Engineer II

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 for the UW Institute for Clinical and Translational Research and the Clinical and Translational Science Award. Reporting to the Research Data Service Director, the Data Engineer II will be responsible for contributing to building the UW Real World Data Commons (UW-RWDC) mapping data across platforms and common data models including OMOP, i2b2, TriNetX, and mCODE . These resources contribute to investigator self-service and deriving meaningful insights from data, which is an increasing focus for research at UW SMPH. As part of the Informatics Data Service Team, the role of this Data Engineer will also be responsible for data quality assurance and quality control. Additionally, the incumbent will work with to develop queries that translate research objectives into datasets retrieved from the UW-RWDC. The successful candidate will have a solid work ethic and bring an enthusiastic and professional attitude to the workplace.

• 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

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

Preferred
Bachelor's Degree

Required qualifications:
- 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:
- Experience developing data pipelines with Microsoft Azure Data Factory
- Experience Designing, Building & Maintaining Databases
- Experience with FHIR and HL7 data feeds
- Experience with clinical vocabularies (ICD, LOINC, SNOMED, CPT, etc.)
- Experience with clinical research common data models (OMOP, i2b2, PCORNet)
- Certified in Epic Cogito Clinical Data Model
- Experience developing Natural Language Processing algorithms
- Experience working with web APIs
- Knowledge of HIPAA and other regulations governing PHI
- Experience reviewing other team member's technical work and providing constructive feedback

Strong people and communication 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.

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.

Ongoing/Renewable

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 (https://hr.wisc.edu/benefits/).

SMPH Academic Staff Benefits flyer: (https://uwmadison.box.com/s/r50myohfvfd15bqltljn0g4laubuz7t0)

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 STEM OPT Extension participants. If you are selected for this position you must provide proof of work authorization and eligibility to work.

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.

Cody Roekle
croekle@wisc.edu
608-263-7676
Relay Access (WTRS): 7-1-1. See RELAY_SERVICE for further information.

Data Engineer II(RE065)

A53-MEDICAL SCHOOL/Informatics and IT

Academic Staff-Renewable

308203-AS