Business Intelligence Developer - ICIT - 15349 - EXTENDED DEADLINE
This posting is no longer available.
ATTENTION:
The Department of Instructional Communication and Information Technology (iCIT) seeks a Senior Information Systems Specialist (Business Intelligence Developer).
JOB DETAILS:
Reporting to the Director of Applications Development, the Business Intelligence Developer will be responsible for creating, programing, maintaining and supporting the BI applications used on campus as well as documenting functional and technical requirements used to translate business requirements into reporting solutions.
QUALIFICATIONS:
Minimum Qualifications:
- Five (5) years of experience with business intelligence concepts working with BI products (e.g., Oracle, Tableau, Business Objects, etc.)
- Strong background in developing complex SQL inquiries.
- Experience with BI tool modeling layers including presentation, logical and physical mapping data elements from various data sources.
- Experience loading data warehouse objects including dimensions, hierarchies, fact tables, aggregates.
- Experience in designing, building, implementing, and deploying data universes/data models against Oracle and SQL Server databases.
- Experience with establishing the reporting framework and supporting the self-service reporting capability.
- Demonstrated experience in designing, building, implementing, and deploying enterprise reports, analytics, and dashboards.
- Excellent problem solving/analytical skills with high level of accuracy.
- Previous experience with OBIEE Answers & Dashboards, and BI Publisher (11g or above)
- Previous experience with ETL tools (Informatica).
- Experience in writing custom Java/Javascript code or XML, and XSL for advanced report features to customize OBIEE functionality.
- Experience in higher education environment, especially working with student and staff.
- Experience with PeopleSoft ERP's (Campus Solutions)
- Ability to extrapolate business requirements, practices, and procedures into design specifications.
- Ability to design reports in a logical, user friendly, and easy to understand format.
- Knowledge of Oracle database management systems principles, techniques and capabilities.
- Design/build OBIEE reports and dashboards using Answers and Dashboards, BI Publisher.
- Work closely to the ETL/Data Warehouse Specialist to design/develop the OBIEE repository.
- Define methods to successfully migrate legacy reporting business logic from Hyperion or other existing tool into OBIEE.
- Model, configure and optimize the RPD from Data Warehouse and databases.
- Develop, implement, and analyze data cubes, building dimensions as well as calculating data with aggregation techniques.
- Design, develop, and document OBIEE repository/metadata.
- Apply knowledge of custom database tables to design BI data models by developing simple to complex SQL queries.
- Translate business requirements and knowledge of data warehouse into modeling the physical layer, business layer and presentation layers.
- Follow university change control procedures and perform deployment of BI artifacts.
- Provide technical assistance and cross training to other team members as required.
- Design and implement best practices, guidelines and repeatable processes.
- Working in a team environment to develop reports and/or dashboards while working as a team member on an assigned project.
- Perform unit, system and integration testing.
- Maintain established standards throughout the process.
- Provide design and development mentorship/cross-training with fellow team members.
- Capable of guiding developers in order to troubleshoot issues with data modeling, RPD’s, reports, and answers/dashboards.
- Deliver solid, scalable, robust BI reporting/analytic solutions.
- Assists in OBIEE administration, system maintenance, security and upgrades.
- Prepare estimates of time for design and development.
- 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 will be reviewed starting June 24, 2019 and this recruitment will remain open until the position is filled. 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