Fox Valley Technical College | Data and Reporting Analyst/Developer – College Effectiveness | Appleton, WI | United States | BigDataKB.com | 17 Oct 2022

Job Category
Regular Support Staff
FVTC Worksite
Appleton Main Campus
Hourly Rate
$37.95
Hours Per Week
40

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 JOB FUNCTIONS

• 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 FVTC’s 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 College’s 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 FVTC’s administrator for licensed survey software.
• Ensure compliance with FERPA and other federal and State required data policies/best practices.

SECONDARY JOB FUNCTIONS

• 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.

QUALIFICATIONS, TRAINING, AND EXPERIENCE

• Associate Degree in CIS is required (Bachelor’s Degree in MIS preferred), AND,
• Minimum of three years of related CIS and/or MIS experience, OR,
• Equivalent combination of education and experience.
• Advanced skills SQL language and query optimization, Microsoft SQL Server Reporting Services or other related business intelligence software experience is required.
• Strong experience with Microsoft Office Products, including SharePoint. Advanced skills in Microsoft Excel are required.
• Working knowledge of Windows operating systems, system design and development, (especially data warehouse), and PeopleSoft or equivalent is required.
• Knowledge or experience in extracting business information and creating reports is required.
• Experience in Data Modeling and Data Warehouse design.
• Experience with prism software.

ESSENTIAL APTITUDES, SKILLS, KNOWLEDGE, AND PERSONAL CHARACTERISTICS

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

Pay Rate: $37.95 per hour.

Additional Information

FVTC strongly and actively strives to increase diversity and provide equal opportunity within its community. FVTC does not discriminate against persons based on age, color, disability, ethnicity, gender, gender expression, gender identity, genetic information, height, marital status, national origin, political persuasion, pregnancy, childbirth or related medical conditions, race, religion, sex, sexual orientation, transgender status, veteran status, weight or any other protected class.

To apply, please visit: https://fvtc.wd1.myworkdayjobs.com/en-US/FVTC/job/Appleton-WI/Data-and-Reporting-Analyst-Developer-College-Effectiveness_JR2022-227

Fox Valley Technical College celebrates diversity, supports equity and inclusiveness, and encourages individual expression in our workplace.

jeid-14b242b6b6003148b9cf1a481c6b85b8