• Reporting Services Designer - Limited Term Employee

    Posting Date: 1 month ago(3/16/2018 3:27 PM)
    Job ID:
    2018-1386
    Category:
    Support Staff
    # of Openings:
    1
    Status:
    Limited Term
    Location(s):
    Appleton Main Campus
    City
    Appleton
    State
    WI
    Hours Per Week:
    40
    Weeks Per Year:
    52
    Work Schedule:
    8:00am - 4:30pm Monday - Friday. Flexibility in schedule may be required.
    Salary/Rate:
    Labor Grade/Zone: E2 - $25.50 per hour
    Anticipated Start Date:
    April 2018
    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
  • Basic Functions & Responsibilities

    This position is located at the Appleton Main Campus and is not a remote position.

    The Reporting Services Designer 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. Demonstrated high level skills 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 in Microsoft Office products including SharePoint deployment.
    9. Ensure compliance with FERPA and other federal and State required data policies/best practices.
    10. Possess ability to multi-task and perform duties with moderate to low supervision.

    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 demonstrate ethical conduct all aspects of the work environment.
    2. Exceptional customer service skills and the ability to maintain an excellent working relationship with internal and external customers.
    3. Excellent oral and written communications skills, as well as good listening skills.
    4. Ability to identify needed action and meet detail-oriented deadlines without continual direction.
    5. Excellent organizational skills and ability to work under pressure.
    6. Neatness in work and appearance.
    7. Ability to demonstrate a positive attitude, maturity, initiative and integrity with a professional image contributing to the success of the college.
    8. Work effectively in a team environment.
    9. Ability to work with diverse student, staff, and community populations.
    10. Ability to maintain confidentiality and professionalism.
    11. Acceptance of responsibility for professional growth.
    12. Dependable, punctual, and committed to following through on tasks.
    13. Flexibility in work schedule. Strong analytical and problem solving skills.
    14. Ability to document technical information and assist in user training sessions.
    15. Detail oriented with strong organizational skills with the ability to multi task.
    16. 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, Group Legal Benefits, 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, Pet Health Insurance, Short Term Disability Insurance, Sick Leave, Spousal and Child Life Insurance, Supplemental Employee Life Insurance, Term Life & AD&D Insurance, Vision Insurance, Wellness Program, Wisconsin Retirement System Pension Benefit (plan eligibility requirements apply)

    Special Instructions to Applicants

    The expected duration of this position is one year and will be re-evaluated at that time.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed