ETL/Data Warehouse Specialist - ICIT - 15350 - EXTENDED DEADLINE
This posting is no longer available.
ATTENTION:
The Department of Instructional Communication and Information Technology (iCIT) seeks a Senior Database Administrator (ETL/Data Warehouse Specialist).
JOB DETAILS:
Reporting to the Director of Applications Development, the ETL/Data Warehouse Specialist will be responsible for architecture and management of the UW - Whitewater data warehouse solutions. Responsibilities include design and development of the data models, design and support of the data warehouse environments, as well as development and execution of ETL processes. Implement enterprise content and data management solutions to reduce cost and complexity, increase trust and integrity in order to improve operational efficiencies.
QUALIFICATIONS:
Minimum Qualifications:
- Two (2) + years of experience with ETL tools or an equivalent combination of training and/or experience with other data warehouse data extract methods.
- Experience with data warehousing techniques, data modeling, star schema design and implementation.
- A Bachelor’s Degree in a technology area of study; Computer Science, Management Information Systems or Analytics.
- Two (2) + years of experience with SQL programming and relational database management systems such as Oracle, Microsoft SQL Server.
- Experience in designing data models for BI/DW environments employing dimensional modeling techniques and concepts such as star schemas and slowly changing dimensions.
- Experience building ETL processes with Informatica PowerCenter or equivalent tools.
- Experience in higher education environment, especially working with student and staff.
- Experience with PeopleSoft ERPs.
- Experience with BI data visualization tools, data profiling tools/strategies, data virtualization, and/or data migration strategies.
- Effectively discussing technical concepts and issues with both IT professionals and others.
- Knowledge of Oracle database management systems principles, techniques and capabilities.
- Ability to document procedures, processes, guidelines, and data dictionaries for technical and non-technical users.
- Ability to handle multiple tasks, set priorities, schedule and meet deadlines.
- Excellent oral and written communication skills. Ability to communicate technical subject matter to non-technical users.
- Strong analytical, organizational and problem-solving skills.
- Manage time effectively
- Interface with functional areas to understand data and reporting needs.
- Facilitate requirements gathering and develop solutions to meet the immediate and long-term needs of internal customers.
- Assure data quality and integrity for the information residing in the data warehouse.
- Plan, design, create, and deploy data warehouses in coordination with the NOC, Middleware and Applications Development teams.
- Design, build and deploy data models.
- Apply best practices for data loading and extraction.
- Develop and document data architecture as well as data modeling.
- Develop reporting applications for data warehouse consistency.
- Manage design throughout implementation process.
- Design end user interfaces and build cubes.
- Develop and implement ETL routines according to the DWH design and architecture.
- Support the development and validation required through the lifecycle of the DWH and Business Intelligence systems, maintain user connectivity, and provide adequate security for data warehouse.
- Monitor the DWH and BI systems performance and integrity. Provide corrective and preventative maintenance as required.
- Willingness and ability to be an active participant in following applicable safety rules and regulations including necessary training and skills.
- Ability to interact respectfully with people from diverse socioeconomic, cultural and ethnic backgrounds.
- Other duties as assigned
Founded in 1868, UW–Whitewater is one of eleven comprehensive universities in a public higher education system that also includes two doctoral institutions, 13 freshman-sophomore branch colleges, and a statewide Extension. In the fall of 2018, as a result of the University of Wisconsin System’s restructuring of the state’s 13 two-year campuses formerly known as UW Colleges, UW–Rock County began operating as a branch campus of UW–Whitewater under the new name of University of Wisconsin–Whitewater at Rock County. Together, these campuses form a preeminent academic institution driven by the pursuit of knowledge, powered by a spirit of innovation, and focused on transforming lives. The University of Wisconsin-Whitewater Campus and Rock Campus are located conveniently near Milwaukee, Madison, and Chicago, and thus offers the advantage of beautiful small-town environments with easy access to the cultural and commercial opportunities of major metropolitan areas.
The Warhawk family — led by caring faculty and staff — is devoted to student success within a broad range of academic programs. UW-Whitewater has a special mission within the UW System to serve students with disabilities and, as such, embraces the principles of universal design and is one of the most accessible campuses in the state. The campuses have more than 200 student organizations and UW-Whitewater is a Division III NCAA university. UW-Whitewater is committed to seeking and sustaining a culturally and ethnically diverse campus environment, building a diverse faculty and staff with expertise and interest in serving students with diverse needs, backgrounds, ethnicities, abilities and other distinct characteristics in respectful, sensitive and understanding ways. The University of Wisconsin-Whitewater is an Equal Opportunity and Affirmative Action Employer, and actively seeks and encourages applications from women, people of color, persons with disabilities, and veterans.
ORGANIZATION INFORMATION:
The University of Wisconsin-Whitewater is part of the 26-campus University of Wisconsin System (https://www.wisconsin.edu).
Wisconsin Statute 19.36(7)(b) provides that applicants may indicate in writing that their identity should be kept confidential. In response to a public records request, the University will not reveal the identities of applicants who request confidentiality in writing, except that the identity of the successful final candidate will be released. See Wisconsin Statute 19.36(7)(a).
UW-Whitewater requires criminal background checks as a contingency to employment. A criminal background check will be conducted prior to an offer of employment.
All final candidates must be asked, prior to hire, whether they have been found to have engaged in, are currently under investigation for, or left employment during an active investigation in which they were accused of sexual violence or sexual harassment. When obtaining employment reference checks, these same sexual violence or sexual harassment questions must also be asked.
The University of Wisconsin-Whitewater requires that all employees be active participants in following applicable safety rules and regulations including necessary training and drills.
For UW-Whitewater Campus safety information and crime statistics/annual Security Report, see http://www.uww.edu/asfr. If you would like a paper copy of the report please contact the UW-Whitewater Police at 262-472-4660.
To learn more about UW-Whitewater's competitive benefits packages go to our: ALEX webpage, which is our interactive benefits decision support tool.
SPECIAL NOTES:
UW-Whitewater embraces AAC&U’s LEAP principles (http://www.uww.edu/leap) and emphasizes student, staff and faculty participation in High-Impact Practices (https://www.aacu.org/resources/high-impact-practices). The Office of Research and Sponsored Programs (http://www.uww.edu/orsp) provides support for faculty scholarly and creative activities as well as other opportunities to apply for reassigned time and/or other resources to support research activities. UW-Whitewater faculty and staff also have access to technology transfer and research resources provided by WiSys (https://www.wisys.org).
CONDITIONS OF APPOINTMENT:
University of Wisconsin-Whitewater does not offer H-1B or other work authorization visa sponsorship for this position. Candidates must be legally authorized to work in the United States at the time of hire and maintain work authorization throughout the employment term. If you have questions regarding this, please contact Human Resources.
TO ENSURE CONSIDERATION:
Applications received by October 31, 2019 are ensured full consideration. Applications received after that date may be given consideration at the discretion of the search committee. Application materials will be evaluated and the most qualified applicants will be invited to participate in the next step of the selection process.
If you have questions regarding this recruitment, or if you are not able to complete the application online due to a disability or system problem, please contact us at 262-472-1024 or hrstudent@uww.edu.
For questions regarding the position, please contact:
Nicole Cervantes
Office Operations Associate
icithr@uww.edu
(262)472-7790
TO APPLY:
Only complete application packages will be considered. A complete application includes online submission of the following documents:
- Resume/CV
- Cover Letter/Letter of Interest
- Three Professional/Supervisory References
Who Are You?
A potential applicant who is NOT currently employed by the University of Wisconsin System, click here and type in the Job ID: UW-Whitewater External Applicants
A current employee of the University of Wisconsin System, click here and type in the Job ID: UW-Whitewater Internal Applicants
Before you get started with the online application process, we recommend you preview the frequently asked questions (FAQs) by selecting the link below.
Apply Online FAQs