Data Warehouse Engineer

The Workday Enterprise Solutions Team (WEST) is responsible for the administration and optimization of Workday and related systems for Finance, Human Resources, and Research Administration across the Universities of Wisconsin, while focusing on people, processes, and technology. The WEST Data and Reporting team supports data and reporting needs across the UW universities and the UW System through the development and maintenance of an enterprise data warehouse (the Enterprise Analytics Platform, EAP), Tableau dashboards, Workday reports, BIRT reports, Prism reports, Workday dashboards and discovery boards, and more.

We are seeking experienced Data Warehouse Engineers to contribute to the development, support and maintenance of our AWS Redshift-based data lake and corresponding data views. Familiarity with Workday data models is a bonus. The Data Warehouse Engineers will work closely with the Workday integration team, Workday report developers, and customers to gather requirements and create solutions that best serve their needs.

To be successful in this position, you will need to be a self-starter who seeks collaboration with customers and peers across the organization. You will need to actively foster a respectful, inclusive, positive, and safe team environment.

Since we review overnight processing every morning, a schedule of Monday - Friday beginning no later than 7:30AM CST and ending no earlier than 3:00PM CST is required. There are currently no on-call expectations. However, during a critical outage, off-hours and weekend work may be required.

• Conducts complex data exploration steps, such as profiling, understanding data quality, binning, pivoting, summarizing, and finding correlations on multiple data types and sources

• Collaborates closely with data engineers, business analysts, functional teams and development teams on the design, development, testing, and maintenance of robust and scalable data pipelines from Workday to AWS Redshift

• May provide code review, coaching, and oversight of the activities of lower level data modelers and data curation developers

• Conducts assessments and/or provides recommendations of source connections options for access and optimal data pipelines for development. Develops and unit tests high-complexity load and/or mappings across a suite of tools and deploys to production

• Presents the results of highly complex recommendations to address data quality issues, and coaches lower-level staff in performing data quality clean-up initiatives with metrics and reports

• Develops and documents the inventory of complex data warehouse assets including adding descriptions and making them discoverable for business use

• Designs, and/or builds, tests, and deploys the data cleansing, integration, and transformation of more complex data in accordance with the defined target data model, based on enterprise data definitions and quality measures provided by data stewards

• Designs and/or builds, tests, and deploys conceptual, logical, and physical data models according to specifications and standards for document naming, security, lifecycle, and retention architectures. May provide architecture options analysis

• Maintains understanding of the data landscape within Workday and the Enterprise Analytics Platform (EAP) to ensure that the data objects and design efficiently and effectively support business needs

• May consult with data subject matter experts to document and address data quality issues and ensure data is assured. May support data quality clean-up initiatives with metrics and reports

Workday and Enterprise Solutions Team (WEST)

Well qualified applicants can expect to earn between $87,000 - $115,000, with final salary based on experience and qualifications.

In addition to salary, 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. For a summary of benefits, please see: https://www.wisconsin.edu/ohrwd/benefits/download/fasl.pdf.

Required Qualifications:

• Minimum 5 years of hands-on experience in data engineering for an enterprise-level data lake or data warehouse with a strong understanding of ETL/ELT best practices, data integration, data modeling, and data transformation
• Ability to work collaboratively in a fast-paced, Agile environment
• Ability to effectively communicate technical concepts to non-technical stakeholders
• Solid coding and problem-solving skills, including a high-level of attention to detail and an understanding of the importance of validating data quality and accuracy
• Expertise in complex SQL programming
• Proficiency with AWS Redshift stored procedures for efficient data manipulation and transformation
• Hands-on experience working with other tools such as AWS Glue, S3, Athena and Apache Iceberg

• Experience developing with Workday Finance and HR as a source system for a data lake or data warehouse.
• Experience with version control systems such as Bitbucket or Git for maintaining a structured code repository
• Experience with complex ETL scenarios, such as CDC and SCD, and integrating data from multiple source systems
• Experience working in a highly complex Python / Pyspark object-oriented platform
• Experience with data modeling, table management, and query optimization.
• Ability to automate and optimize data delivery by improving existing processes and redesigning infrastructure for greater efficiency and scalability
• Certification(s) or formal training related to AWS products, data engineering or databases
• Experience with Tableau development and dashboard creation

To begin the application process, click the "apply now" button. Please submit a resume and cover letter detailing your related experiences and background as they relate to the qualifications and duties in this job description. Applications submitted without a cover letter will still be considered, but a cover letter is requested to more thoroughly demonstrate how your experience aligns with the qualifications outlined in the position description. Failure to adequately demonstrate experiences aligned with the required qualifications in either a cover letter or resume will result in your application not being considered for employment.

Please note that successful applicants are responsible for ensuring their 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 need of employer sponsorship) on or before the effective date of appointment.

Daniel McCusky, HR Generalist

daniel.mccusky@wisc.edu

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 Opportunity Employer.

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 backgrounds and 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 accommodation for 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 to. Please 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.