Job Category

Regular Support Staff

FVTC Worksite

Appleton Main Campus

Hours Per Week

40

Note to internal applicants: Do not apply via this portal. Login to your Workday Account and Find Internal Career Opportunities through the Internal Portal.

Job Description Summary

This position is responsible for the data and reporting functions relative to College institutional research including the development testing initial analysis and delivery of data-driven reporting solutions. The Data and Reporting Analyst oversees and participates in all aspects of the reporting development cycle including requirements design testing and implementation of reports as well as enhancement and maintenance of existing projects. This role also collaborates with IT Report Analysts/Developers and Data Analysts/Developers on recommendations related to 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 good working relationships with all areas of the College is essential.

Job Description

Essential Functions and Responsibilities

The following duties are primarily performed and are essential for this position. Employees are expected to be able to perform each of these job duties satisfactorily to be qualified for the position. Other duties may be required and assigned.

• Develop maintain and update procedures and associated resources for assigned systems.

• Complete data collection and initial analysis of College statistical information for strategic planning performance monitoring reports division and program scorecards grant reports and national/institutional reporting.

• Source information from Workday FVTCs data warehouse WTCS data systems labor market software and other data repositories. Share data reports and related documents to FVTC collaboration sites (i.e. Teams and SharePoint).

• Provide highly developed Transact-SQL skills with the Colleges data warehouse and enterprise reporting system.

• Possess strong understanding of Business Intelligence specifically SSRS/BIDS.
  Demonstrated high level skills in Visual Studio reporting solutions.

• Produce accurate consistent and timely reporting by extracting information from multiple systems manipulating data and developing user friendly final outputs.

• Assist in the data gathering and production of summary resources for College surveys.

• Collaborate with administration and faculty to provide data resources that support meaningful actionable information for effective interventions toward college program and student success.

• Provide research consultation to design and deploy data collection systems for grants and other research projects in collaboration with other College departments. Serve as FVTCs administrator for licensed survey software.

• Ensure compliance with FERPA and other federal and State required data policies/best practices.

• Provide technical and reporting oversight to the WTCS client reporting process using multiple technology systems to gather data clean and correct reporting and ensure accurate and timely submittal of data to correctly reflect accurate representation of student populations and data alignment for outcomes based funding.

• Serve as Workday Reporting Analyst for College Effectiveness to develop and edit reports in Workday for state federal and college planning data and reports.

• Act as District liaison with WTCS IR and external research consultants.

• Coordinate specific research or evaluation projects.

• Involvement with College Effectiveness team projects such as environmental scanning.

• Act as back-up for other College Effectiveness staff.

Minimum Qualifications

Education and/or Experience Requirements:

• Associate Degree in CIS required (Bachelors Degree in MIS preferred) AND

• Minimum of three years of related CIS and/or MIS experience required.

Licenses Certifications and Other Requirements:

• Advanced skills SQL language and query optimization Microsoft SQL Server Reporting Services or other related business intelligence software experience required.

• Strong experience with Microsoft Office Products including SharePoint. Advanced skills in Microsoft Excel required.

• Working knowledge of Windows operating systems system design and development and Workday or equivalent required.

• Knowledge or experience in extracting business information and creating reports required.

• Experience in Data Modeling preferred.

• Experience with prism software preferred.

In evaluating candidates for this position Fox Valley Technical College may consider a combination of education training and experience which provides the necessary knowledge skills and abilities to perform the duties of this position.

Work Environment

• Work will be completed in a hybrid environment both in person and virtually.

• A significant portion of each workday is spent on the computer.

• Deadlines for compliance reports are driven by external agencies and require strict adherence to reporting requirements and submission dates.

Work environment may change based upon college needs.

Physical Requirements

• Sitting: This role requires extended periods of sitting while performing tasks and utilizing computer systems.

• Mobility: While much of the work is desk-based occasional mobility may be necessary for attending meetings or events within the workplace.

• Fine Motor Skills: This role requires precise hand movements or manual dexterity for activities such as demonstrations presentations or using reporting technologies.

• Repetitive Motions: Capacity to perform repetitive motions such as typing without discomfort or injury.

• Communication: Clear verbal and written communication skills are essential for interacting with employees and stakeholders both in-person and through electronic means.

EOE/ADA Statement

Fox Valley Technical College (FVTC) is an Equal Opportunity Employer (EOE). In compliance with the Americans with Disabilities Act (ADA) FVTC will provide reasonable accommodations to qualified individuals with disabilities and encourages both prospective and current employees to discuss potential accommodations with the employer.

Nothing in this job description limits managements right to assign or reassign duties and responsibilities to this job at any time. The duties listed above are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar related or a logical assignment to the position. The job description does not constitute an employment agreement or affect the at-will nature of the employment arrangement between the employee and company and is subject to change by the employer as the needs of the employer and requirements of the job change.

Additional Information

Pay Rate: $30.72 per hour.
Pay is based on a multitude of factors including experience qualifications education relevant certifications internal equity and market data. Note: Internal applicants wage will be based upon the applicable compensation guidelines.

At Fox Valley Technical College we recognize employees as key contributors to our mission and are committed to fostering a culture of fairness transparency and excellence. Our total rewards philosophy ensures equitable compensation and benefits supporting a highly engaged workforce. Our comprehensive benefits package includes medical dental and vision insurance along with retirement contributions to the Wisconsin Retirement System and 403(b)/457 plan options. Employees enjoy paid vacation sick leave holidays bereavement leave and recess periods. We offer life and disability insurance with options for additional coverage. Work-life balance is supported through flexible schedules or remote work options (for some positions) and wellbeing programs. Professional development opportunities include training certifications and tuition reimbursement. Additional perks at the Appleton Main Campus include an onsite health and wellbeing clinic dental clinic fitness center Parent/Child Center (onsite child care) library caf printing services Trilogy Salon & Spa and more.

Fox Valley Technical College is an Equal Opportunity/Affirmative Action institution providing equal opportunity to all persons including members of underrepresented racial and ethnic backgrounds females veterans and individuals of all abilities.
For questions regarding the Colleges nondiscrimination policy contact: Rayon Brown - (Affirmative Action) (sex-based discrimination or harassment) or Dan Squires - (Disability related discrimination).