Data Systems Engineer

Current Employees: If you are currently employed at any of the Universities of Wisconsin log in to Workday to apply through the internal application process.

Job Category:

Employment Type:

Job Profile:

Job Summary:

The Data Systems Administrator position is located within the Office of Data Academic Planning & Institutional Research (DAPIR). DAPIR includes Academic Planning Institutional Research & Decision Support Data Governance and Enterprise Data Management.
The Data Systems Engineer will be on the Enterprise Data Management team within DAPIR and will be instrumental in helping shape the future of UW-Madisons data landscape. Enterprise Data Management is in the process of modernizing several elements of the UW-Madison data platform and is looking for an experienced data professional to help us grow beyond traditional databases into new technologies and methodologies (data lakes data lakehouse data fabric etc.)
This role will be central to helping design build and maintain physical and virtual database systems and related data systems (AWS S3 data applications etc.) in a hybrid cloud and on-premises environment and will assist with the overall UW-Madison data platform to ensure data security and integrity. This position will play a large role in improving business processes and SDLC by helping to implement new DevOps and CI/CD automations.
The Data Systems Engineer will support the Data Systems Administrator in monitoring system performance and configuration performing troubleshooting and performing system administration duties. The Data Systems Engineer role will also take a more active role in developing new data projects performing data warehousing tasks such as data modeling and ETL development.

Key Job Responsibilities:

• Serves as a subject matter expert on database systems and procedures for new projects and facilitates planning (5%)

• Implements complex security measures to safeguard digital information (10%)

• Develops data architectures and database management policies and standards (10%)

• Monitors and analyzes database audit tables and logs and provides complex data warehousing support and data extraction (30%)

• Identifies and resolves data issues and upholds database-use guidelines (10%)

• Identifies develops and facilitates unit staff training opportunities in the effective utilization of databases (5%)

• Provides technical leadership in data models and standards for large complex enterprise analytics initiatives (10%)

• Provides technical leadership in enterprise data quality master data transformation and preparation for large complex enterprise analytics initiatives (10%)

• Installs configures maintains backs up restores and performance-tunes databases (10%)

Department:

Data Academic Planning & Institutional Research Enterprise Data Management

Compensation:

The minimum annual salary for this position is $120000. Actual starting salary is negotiable based on experience and qualifications.

This position offers a comprehensive benefits package including generous paid time off competitively priced health/dental/vision/life insurance tax-advantaged savings accounts and participation in the nationally recognized Wisconsin Retirement System (WRS) pension fund. Learn more here.

Required Qualifications:

• 5 years of professional work experience in database administration data management or related field

• Experience with database design security documentation and coding in a cloud or cloud-hybrid environment

Preferred Qualifications:

• Strong preference for data engineering experience (data modeling ETL etc.)

• Experience working in higher education

• Experience in implementing new data systems and platforms

• Experience implementing and managing DevOps/CI/CD automations

• Cloud certifications (AWS/Microsoft/Google)

• Experience migrating on-premises and legacy systems into cloud services and integrating cloud services into existing infrastructure

• Experience managing cloud databases (Snowflake Redshift etc.)

• Experience managing cloud tools related to data management (AWS S3 ADLS MPP clusters etc.)

• Experience managing logical databases or lakehouses (Denodo Dremio etc.)

Education:

Bachelors degree preferred

How to Apply:

To apply for this position click on the I am a current employee button or I am not a current employee button under Apply Now. Please upload a cover letter and resume.

University sponsorship is not available for this position including transfers of sponsorship and TN 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 position is an ongoing position that will require continuous work you are selected for this position you must provide proof of work authorization and eligibility to work.

Contact Information:

Kory Breuer HR Manager

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.

The University of Wisconsin-Madison is an Equal OpportunityEmployer.

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 backgroundsand 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 accommodationfor 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 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.