Returning Candidate?

Report Analyst/Developer

Report Analyst/Developer

Posting Date: 
8/31/2017
Job ID: 
2017-1311
Category: 
Support Staff
# of Openings: 
1
Status: 
Full-Time
Location(s): 
Appleton Main Campus
City 
Appleton
State 
WI
Hours Per Week: 
40
Weeks Per Year: 
52
Work Schedule: 
8am - 4:30pm Monday - Friday. Flexibility in schedule may be required.
Salary/Rate: 
Labor Grade/Zone: E2 - $25.50 per hour
Anticipated Start Date: 
10/02/2017
Internal Applicant Salary/Rate: 
Based upon the applicable compensation structure
Posting Duration: 
Position will be posted for a minimum of five days and will remain open until the needs of the position are met
Shift Differential: 
N/A

More information about this job

Basic Functions & Responsibilities

The Report Analyst/Developer is responsible for developing, testing, and delivering data-driven reporting solutions for multiple areas across the College including Student Records, Finance, Human Resources, and other third-party internal systems.  The Analyst/Developer oversees and participates in all aspects of the development cycle including requirements, design, testing and implementation of new reports as well as enhancement and maintenance of existing projects.  This role also collaborates with the Data Analyst/Developer on new data warehouse tables/fields and performance enhancement.  Business Intelligence tools used to perform the job include Microsoft SQL Server to write T-SQL stored procedures and functions, and Microsoft Visual Studio to create end user reports.  Understanding of a wide-range of business processes across the College and a good working relationship with all areas including other IT departments is essential. 

Essential Job Functions/Secondary Job Functions

 

 

  1. Provide highly developed Transact-SQL skills with the College’s data warehouse and enterprise reporting system.
  2. Possess strong understanding of Business Intelligence, specifically SSRS/BIDS.
  3. Demonstrate a high level of skill and expertise in Visual Studio reporting solutions.
  4. Collaborate with internal customers to analyze user requirements and translate them into high-performance, high value reporting solutions.
  5. Produce accurate, consistent and timely reporting by extracting information from multiple systems, manipulating data and developing user friendly final outputs.
  6. Develop in-depth knowledge of operational processes in the business areas of Student, Finance, and Human Resources.
  7. Possess experience with Data Modeling and Data Warehouse design.
  8. Maintain strong background and provide expertise in Microsoft Office products including SharePoint deployment.
  9. Ensure compliance with FERPA and other federal and State required data policies/best practices.

 

 

Qualifications, Training and Experience

 

  1. Associate Degree in CIS is required (Bachelor’s Degree in MIS preferred), AND,
  2. Minimum of three years of related CIS and/or MIS experience, OR,
  3. Equivalent combination of education and experience.
  4. Advanced skills SQL language and query optimization, Microsoft SQL Server Reporting Services or other related business intelligence software experience is required.
  5. Advanced skills in Microsoft Excel are required.
  6. Working knowledge of Windows operating systems, system design and development, (especially data warehouse), and PeopleSoft or equivalent is required.
  7. Knowledge of accounting principles or experience in extracting business information and creating reports is required.

Essential Aptitudes, Skills, Knowledge and Personal Characteristics

 

 

  1. Ability to multi-task and perform duties with moderate to low supervision.
  2. Ability to demonstrate ethical conduct all aspects of the work environment.
  3. Exceptional customer service skills and the ability to maintain an excellent working relationship with internal and external customers.
  4. Excellent oral and written communications skills, as well as good listening skills.
  5. Ability to identify needed action and meet detail-oriented deadlines without continual direction.
  6. Excellent organizational skills and ability to work under pressure.
  7. Neatness in work and appearance.
  8. Ability to demonstrate a positive attitude, maturity, initiative and integrity with a professional image contributing to the success of the college.
  9. Work effectively in a team environment.
  10. Ability to work with diverse student, staff, and community populations.
  11. Ability to maintain confidentiality and professionalism.
  12. Acceptance of responsibility for professional growth.
  13. Dependable, punctual, and committed to following through on tasks.
  14. Flexibility in work schedule. Strong analytical and problem solving skills.
  15. Ability to document technical information and assist in user training sessions.
  16. Detail oriented with strong organizational skills with the ability to multi task.
  17. Results-Driven with ability to take initiatives and meet deadlines.

 

Benefits (eligibility requirements may apply)

403B and 457 Retirement Plans, Bereavement Leave, Dental Insurance, Emergency Leave, Employee Assistance Program, Fitness Center at Appleton Main Campus, Flexible Spending Account, Health Insurance or if applicable Cash Option Plan, Health Savings Account, Long Term Disability Insurance, On-Site Child Care Facility at Appleton Main Campus, Paid Holidays, Paid Vacation, Short Term Disability Insurance, Sick Leave, Spousal and Child Life Insurance, Supplemental Employee Life Insurance, Term Life & AD&D Insurance, Tuition Reimbursement, Vision Insurance, Wellness Program, Wisconsin Retirement System Pension Benefit (plan eligibility requirements apply)

Special Instructions to Applicants

This position is located in Appleton, WI and is not a remote position.