Data Systems Engineer
About The Position
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-Madison's 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.
Requirements
- 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
Nice To Haves
- 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.)
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%)
Benefits
- 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
251-500 employees
