Job Description

Job ID
16310
Location
UW Stout;Menomonie, WI
Full/Part Time
Full-Time
Regular/Temporary
Regular

JOB DETAILS:


Data Warehouse Developer

Software Engineer/Developer II

DEPARTMENT: Learning and Information Technology (LIT)

ANTICIPATED START DATE: May 15, 2020

This vacancy announcement is for 2 separate full-time, annual year, on-site Systems Programmer positions: a Data Warehouse Developer and a Software Engineer/Developer II. Although separate, these positions have some skills and responsibilities that overlap.

UW-Stout is unable to provide green card or H1B sponsorship for these positions. The position we are currently seeking requires successful applicants to be 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.

JOB DETAILS

These positions work under general supervision of the Enterprise Information Systems (EIS) team in Learning and Information Technology at the University of Wisconsin-Stout. These positions follow and perform work on projects identified by priority setting guidelines within the department, and report status of projects that are under development. Positions provide software support to staff using PeopleSoft Campus Solutions (the college’s student information system), Salesforce, and UW-Stout’s Data Warehouse environment. Tools include Oracle database, Informatica (both PowerCenter and Cloud), Salesforce, PL/SQL and Oracle’s OBIEE for Data Warehouse reporting.

These positions serve system users especially in administrative and academic departments as an authority for initiating all systems changes and problems, by providing direction, guidance and consultation on Information Systems technical issues; helping to determine the most feasible solution to customer problems.

Candidates selected will work in a team environment, managing multiple tasks, accept responsibility for mission critical systems, meet deadlines and be able to respond to ever changing business needs and technology to meet the general goals of the University.

QUALIFICATIONS

Minimum / Required

Data Warehouse Developer

  • Data warehouse development and reporting experience

Software Engineer/Developer II

  • Experience with developing and supporting enterprise application software such as PeopleSoft

Preferred (both positions)

  • Oracle database query/reporting experience
  • Reporting from PeopleSoft tools and tables, particularly Campus Solutions
    • Oracle Business Intelligence Enterprise Edition development and reporting experience, including RPD development, data modeling and familiarity with physical-logical-presentation layers
    • Data warehouse development and reporting experience
    • Ability to diagnose and solve highly complex problems with application and database management system infrastructure
    • Experience leading large projects in an enterprise technology environment with emphasis on communication to customers and team members
    • Experience working with higher education
    • Strong written and oral communication skills
    • Strong interpersonal skills and the ability to work effectively with a wide range of constituencies in a diverse community, both independently and on team assignments
    • Strong organizational, time management, and project management skills
    • Willingness to work some holidays, evenings, and weekends
    • Degree in Computer Science, Management Information Systems or a related field

RESPONSIBILITIES

Data Warehouse Developer (95%)

Software Engineer/Developer II (30%)

  • Design, develop and maintain Data Warehousing Systems and Reporting Data System (RDS).
  • Create and develop/modify program documentation by following department standards.
  • Perform detailed analysis and design for specialized, business related, complex automated systems; develop specifications, develop test conditions and monitor and troubleshoot the developed systems.
  • Develop and maintain reporting solutions as identified by end-user departments.

Software Engineer/Developer II (65%)

  • Consult/coordinate with end users; analyze features and functions of each software release to determine the impact on existing modules, particularly custom reports, process and screens.
  • Work with end users in an effort to understand their needs and troubleshoot software related issues.
  • Maintain and develop difficult and complex program logic and instructions/code. Including on-line transaction processing by using appropriate tools to accomplish system/project objectives.
  • Test, debug and verify the software and interfaces with applications/system software per system/project specification.
  • Create and develop/modify program documentation by following department standards.
  • Perform detailed analysis and design for specialized, business related, complex automated systems, develop specifications, develop test conditions and monitor and troubleshoot the developed systems.
  • Develop, direct and monitor progress of project plans, which impact all phases of the System Development Life Cycle.
  • Develop and direct system/project definition, specifications, and plans ensuring compliance with all university, UW-System, State of Wisconsin and federal policies/regulations.
  • Interact with vendors for software/hardware procedural specifications and problem resolution.
  • Serve on inter-campus study and/or advisory groups representing the interests of Learning and Information Technology and/or the interest of the user units/systems position, having primary responsibility.

Both positions (5%)

  • Attend appropriate seminars and classes to maintain and enhance levels of information technology, communication and customer service skills.
  • Read appropriate trade journals and professional publications regarding current learning and information technology developments.
  • Accept assignments as required by the Director of Enterprise Information Systems to actively participate in work teams providing learning and information technology customer support and other campus technology needs.
  • Comply with recognized environmental health and safety practices.

DEPARTMENT INFORMATION

Enterprise Information Systems (EIS), Learning Technology Services (LTS), Client Technology Services (CTS), and Telecommunications and Networking (T&N), make up the Learning and Information Technology Department (LIT). LIT is UW-Stout’s steward of technology in support of education. In particular, EIS provides data and enterprise resource planning services including PeopleSoft Campus Solutions student information system application development, support, and maintenance; data warehouse and reporting development and support; campus website technical support, development, and maintenance; development, support, and maintenance for a variety of web-based applications for the campus; and operation, support, and administration of servers for those applications.

CAMPUS INFORMATION

The University of Wisconsin-Stout offers a rich, dynamic and collaborative environment in which to work and grow. A member of the University of Wisconsin system, UW-Stout is unique within the system--it is named after its founder, James Huff Stout, and holds the distinction of being Wisconsin’s Polytechnic University, a designation which highlights our combination of applied learning, real-world experiences and a solid liberal arts foundation. UW-Stout offers 50 undergraduate and 24 graduate degrees, including two terminal degrees. Average student enrollment is 9,000.

UW-Stout faculty enjoy opportunities for cross-disciplinary collaboration, state-of-the-art facilities, and a modern digital environment. UW-Stout values innovative approaches to solving problems in society and industry, and faculty are encouraged to maintain strong ties and seek collaborative projects within their disciplines and industries.

All undergraduate students participating in traditional, on campus-based programs are issued laptops. Faculty use the university’s online course delivery system and must be available for online interactions and/or alternate time frames for teaching. Faculty members teach, advise students, conduct research, assess student learning and engage in service activities.

Menomonie, Wisconsin, is a town of 16,000 located in the beautiful Chippewa River Valley, 25 miles west of Eau Claire and 60 miles east of the Twin Cities of Minneapolis and Saint Paul.

More information about the UW-Stout community and region: https://www.uwstout.edu/about-us/our-community

Facts and data about the university: https://www.uwstout.edu/about-us/meet-our-leadership/institutional-accreditation/fact-book

ADDITIONAL INFORMATION

Competitive salary commensurate with qualifications and experience. The UW System provides an excellent benefits package including participation in the Wisconsin State retirement plan.

As an equal employment opportunity and affirmative action employer, UW-Stout is committed to inclusive excellence and is actively seeking applications from individuals from diverse groups; veterans and individuals with disabilities.

An offer of employment is contingent upon the final candidate passing a criminal background check and a reference check process. The reference check process includes asking the final candidate and most recent supervisor questions regarding sexual violence and sexual harassment. Final candidates with previous employment within the UW System and State of WI agencies will be subject to additional reference checks.

A successful applicant will be responsible for ensuring eligibility for employment in the United States on or before the effective date of the appointment and maintain work authorization throughout the employment term. If you have questions regarding this, please contact our Human Resources office at 715.232.1279.

In response to a public records request, the University of Wisconsin System will not reveal the identities of applicants who request confidentiality in their online application, except that the identity of the successful final candidate will be released. See Wis. Stat. sec. 19.36(7).

For campus safety information and crime statistics visit: https://www.uwstout.edu/life-stout/police-and-parking/clery-information

TO APPLY

Applicants will need to complete all required fields and attach all required documents prior to submitting the online application.

Note: Once you have attached your materials and submitted your application you will not be able to go into the system and change them.

Required application materials:

  • Cover letter
    • Please indicate which position you are applying for or both.
    • Specifically address how you meet the minimum and preferred qualifications.
  • Resume
  • Names, email and phone contact information for a minimum of three (3) professional references

Official transcripts required at time of hire.

To ensure consideration complete applications must be submitted online by Sunday, March 15, 2020 – 12:00 AM CST. Screening of applications may continue until positions are filled.

It is the policy of UW-Stout to provide reasonable accommodations to qualified applicants with disabilities. If you need assistance, or accommodation in applying because of a disability, please contact us using the information below. Employment opportunities will not be denied because of the need to make reasonable accommodations for a qualified individual's disability.

For questions regarding this position or recruitment, please contact:

If you need assistance with the online application process or if you submitted your application prior to uploading all of the required application materials, please contact:

Before starting the online application process we recommend you preview the frequently asked questions (FAQs) available at: https://kb.wisc.edu/hrs/page.php?id=21900

The University of Wisconsin System is engaged in a Title and Total Compensation (TTC) project to redesign job titles and compensation structures. As a result of the TTC project, official job titles on current job postings may change in Spring 2020. Job duties and responsibilities will remain the same. For more information please visit: https://www.wisconsin.edu/ohrwd/title-and-total-compensation-study/

Job Family: Staff