Data Warehouse Engineer at University of Wisconsin Madison

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:Academic StaffEmployment Type:RegularJob Profile:DW Eng/Developer IIJob Summary: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.Key Job Responsibilities:Conducts complex data exploration steps such as profiling understanding data quality binning pivoting summarizing and finding correlations on multiple data types and sourcesCollaborates 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 RedshiftMay provide code review coaching and oversight of the activities of lower level data modelers and data curation developersConducts 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 productionPresents 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 reportsDevelops and documents the inventory of complex data warehouse assets including adding descriptions and making them discoverable for business useDesigns 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 stewardsDesigns 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 analysisMaintains 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 needsMay 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 reportsDepartment:Workday and Enterprise Solutions Team (WEST)Compensation:Well qualified applicants can expect to earn between $87000 - $115000 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: 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 transformationAbility to work collaboratively in a fast-paced Agile environmentAbility to effectively communicate technical concepts to non-technical stakeholdersSolid coding and problem-solving skills including a high-level of attention to detail and an understanding of the importance of validating data quality and accuracyExpertise in complex SQL programmingProficiency with AWS Redshift stored procedures for efficient data manipulation and transformationHands-on experience working with other tools such as AWS Glue S3 Athena and Apache IcebergPreferred Qualifications: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 repositoryExperience with complex ETL scenarios such as CDC and SCD and integrating data from multiple source systemsExperience working in a highly complex Python / Pyspark object-oriented platformExperience 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 scalabilityCertification(s) or formal training related to AWS products data engineering or databasesExperience with Tableau development and dashboard creationHow to Apply: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.Contact Information:Daniel McCusky HR GeneralistInstitutional 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. Key Skills Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala Experience: years Vacancy: 1 Monthly Salary Salary: 87000 - 115000