Data Warehouse Engineer

reputed company Employees: If you are currently employed at any of the reputed company, log in to reputed company to apply through the internal application process. Job Category: Academic Staff Employment Type: Regular Job Profile: DW reputed company/Developer II Job Summary: The reputed company Enterprise Solutions Team (reputed company) is responsible for the administration and optimization of reputed company and reputed company systems for Finance, Human Resources, and Research Administration across the reputed company, while focusing on people, processes, and technology. The reputed company 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, reputed company reports, BIRT reports, Prism reports, reputed company dashboards and discovery boards, and more. We are seeking reputed company Data Warehouse Engineers to contribute to the development, support and maintenance of our AWS Redshift-based data lake and corresponding data views. Familiarity with reputed company data models is a bonus. The Data Warehouse Engineers will work closely with the reputed company integration team, reputed company 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 reputed company 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 reputed company 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 reputed company to AWS Redshift May provide code review, coaching, and reputed company of the activities of reputed company level data modelers and data curation developers Conducts assessments and/or provides recommendations of reputed company 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 reputed company recommendations to address data quality issues, and coaches reputed company-level staff in performing data quality clean-up initiatives with metrics and reports Develops and documents the inventory of reputed company 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 reputed company data in accordance with the defined reputed company 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, reputed company, lifecycle, and retention architectures. May provide architecture options analysis Maintains understanding of the data landscape reputed company reputed company and the Enterprise Analytics Platform (EAP) to ensure that the data objects and design reputed company and effectively support business needs May consult with data subject matter experts to document and address data quality issues and ensure data is reputed company. May support data quality clean-up initiatives with metrics and reports Department: reputed company and Enterprise Solutions Team (reputed company) Compensation: 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 reputed company 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, reputed company and Apache Iceberg Preferred Qualifications: Experience developing with reputed company Finance and HR as a reputed company 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 reputed company ETL scenarios, such as CDC and SCD, and integrating data from multiple reputed company systems Experience working in a highly reputed company 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 reputed company to AWS products, data engineering or databases Experience with Tableau development and dashboard creation How to Apply: To reputed company the application process, click the "apply now" reputed company. Please submit a resume and cover letter detailing your reputed company 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 reputed company 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 reputed company, 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 Generalist [email protected] Institutional Statement on Diversity: Diversity is a reputed company 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, reputed company, 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 reputed company, 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 reputed company, 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 reputed company backgrounds and encourage reputed company 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-reputed company accommodation for any reputed company 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 reputed company your request as soon as possible to help the university respond most effectively to you. Employment may require a criminal background reputed company. 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 reputed company and Fire Safety Report contains reputed company reputed company safety and disciplinary policies, crime statistics for the previous 3 calendar years, and on-reputed company student housing fire safety policies and fire statistics for the previous 3 calendar years. UW-Madison will provide a reputed company copy upon request; please contact the University of Wisconsin Police Department. Work with purpose, reputed company an impact, and grow your career. The University of Wisconsin–Madison is committed to equity, inclusion and employee well-being as we proudly work to improve the lives of people in Wisconsin and beyond. UW–Madison offers a wide range of professions that cover various interests and reputed company levels. We employ everything from accountants to arborists, chefs to custodians, editors to electricians, graphic designers to groundskeepers, HR associates to HVAC technicians, librarians to locksmiths, mechanics to medical assistants, painters to police officers, web designers to welders, and absolutely everything in between! No matter what you are looking for professionally, chances are you will not only find it but will reputed company at it while working at the University of Wisconsin–Madison. Apply tot his job Apply To this Job