University of Wisconsin - Milwaukee

Data Warehouse Engineer

University of Wisconsin Milwaukee

No sponsorship$85k-$93kDetected 8 days ago

Code ReviewSQLRedshiftData EngineeringStatisticsHRISMentoring

About the role

Job Description The University of Wisconsin-Milwaukee is seeking a skilled Data Warehouse Engineer to join our Enterprise Data Warehouse team.
You'll work with Informatica, SQL, Oracle, and modern data warehousing tools to translate business needs into effective technical solutions.
Key Job Responsibilities: - Conducts assessments and/or provides recommendations of source connections options for access and optimal data pipelines for development.

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
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
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
Develops and documents the inventory of complex data warehouse assets including adding descriptions and making them discoverable for business use
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
Additional documents submitted beyond a cover letter and resume will not be reviewed.

Bachelor's degree by date of hire
3+ years of professional experience in data engineering, data warehousing, or a closely related discipline
Proficiency in SQL, including experience writing and optimizing complex queries
Working knowledge of data warehousing concepts, data modeling techniques, and standard development methodologies
Applicants must be legally authorized to work in the United States at the time of hire.
Selected candidates will be required to complete an I-9 form to verify eligibility to work in the U.S.
Applicants must complete all required fields and attach all required documents before submitting the online application.
Applications missing any required documents at the time of the deadline will be marked as incomplete and will not be considered.
Note: Applicants must complete all required fields and attach all required documents before submitting the online application.
UWM will not, however, reveal the identities of applicants who request confidentiality in writing except as may be required by Wisconsin's Open Records law.

Bachelor's degree in Information Technology, Computer Science, or a closely related field
Experience with Oracle, PL/SQL, and/or Amazon Redshift data warehouse environments
3+ years of experience designing, building, and optimizing ETL workflows and data pipelines preferably using Informatica Intelligent Cloud Services
Experience with data profiling, data quality assessment, and data cleansing practices
Applications Instructions
All applicants are required to apply online and submit both a cover letter and a resume that clearly describe their professional-level experience as it relates to the required and preferred qualifications.

$85,000-$93,000 annually
Please visit this link to view summary benefits information. (Compensation figures are for example purposes only.) UWM Benefits to Benefit You and Your Life
Annual Security and Fire Safety Report (Clery Act)

As part of UWM's commitment to supporting the success of our team members through positive experiences, employees are provided with Benefits to Benefit You and Your Life.
UWM offers a comprehensive benefits package and contributes towards the cost of several benefit plans.
Employees with a qualifying position also receive an extensive leave package including vacation, sick leave (with no expiration), personal holiday, and paid legal holidays.
Please visit this link to view summary benefits information. (Compensation figures are for example purposes only.) UWM Benefits to Benefit You and Your Life
Benefits and Total Rewards
Employment opportunities will not be denied because of the need to make reasonable accommodations for a qualified individual with a disability.
This job announcement and other material on this site will be made available in alternate formats upon request to an individual with a disability.
Employees at UWM in the Department of University IT Services work in an innovative, collaborative, and casual-work environment with flexible work/life balance schedules.

If you need assistance or accommodation in applying because of a disability, please contact uwm-jobs@uwm.edu or 414-229-4463.

This listing is sourced directly from University of Wisconsin - Milwaukee's careers page and normalized into a canonical job model.