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 (https://hr.wisc.edu/benefits/). SMPH Academic Staff Benefits flyer: (https://uwmadison.box.com/s/r50myohfvfd15bqltljn0g4laubuz7t0) 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 croeklewisc.edu 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 The University of Wisconsin-Madison is an Equal Opportunity and Affirmative Action Employer. Qualified applicants will receive consideration for employment without regard to, including but not limited to, race, color, religion, sex, sexual orientation, gender identity, 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 through diversity and encourage all qualified individuals to apply. For more information regarding applicant and employee rights and to view federal and state required postings, click here If you need to request an accommodation because of a disability, you can find information about how to make a request at the following website: https://employeedisabilities.wisc.edu/disability-accommodation-information-for-applicants/ Employment may require a criminal background check. It may also require you and your references to answer questions regarding 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.