To advance the college’s mission, vision, principles, values and strategic initiatives through continuous improvement decisions.
GENERAL JOB SUMMARY:
The Compliance Reporting Analyst I position will be a part of the Compliance Reporting team. This position will help design, test, and deliver on time and accurate reports. The compliance reports and data support internal and external requirements. The analyst will report to the Director of Compliance Reporting and support Institutional Research. This position will be responsible for compliance reporting and supporting information needs for Kirkwood’s mission and vision.
The work schedule for this position is Monday through Friday from 8 am to 5 pm with an option to work a hybrid schedule (3 days on campus and 2 days remote).
UNIVERSAL CORE COMPETENCIES:
-
Advocate for Continual Improvement- empowering each other to identify opportunities for excellence.
-
Collaborate with Mutual Accountability- working together with a willingness to take ownership and account for our actions.
-
Champion Service- anticipating needs and create a welcoming, diverse, and inclusive environment.
-
Perseverance- commitment to excellence even in the face of adversity or delay in achieving success.
-
Lead- regardless of title, through positive influence.
- Develop, modify, and maintain SQL stored procedures with guidance.
-
Adhere to Compliance Reporting Team SQL coding standards.
-
Test reporting logic against business rules and develop data validation audits.
-
Assist in resolving data and reporting logic errors.
-
Document database objects and stored procedures.
-
Actively participate and present/explain queries as part of team code walk-throughs.
-
Create and modify reports in SSRS development environment.
-
Import/Export data via SSMS.
-
Generate routine and ad hoc reports.
-
Acquire primary or secondary data from existing internal or external data sources.
-
Develop and implement data collection systems and other strategies that ensure data quality.
-
Run data trends and check variances.
-
Participate and collaborate with team on scrum agile processes.
-
Assist the Director of Compliance Reporting in reviewing requirements and technical specifications.
-
Perform other related work duties as assigned.
PERFORMANCE EXPECTATIONS:
-
Welcome, value, and nurture people of all backgrounds, perspectives, and experiences, as well as support and promote an environment that accepts differences.
-
Be able and willing to represent the College in the most positive manner with prospective, former and current students, clients, suppliers and the community we serve.
-
Be a creative, energetic, and self-motivated individual who demonstrates leadership and collaborative work habits within the department and in active participation in college committees.
-
Must be able to work independently, accept responsibility with limited supervision, manage multiple tasks to completion, and work with frequent interruptions.
-
Attention to detail and an ability to complete complex tasks without errors.
-
Be able to work within a team environment and gain cooperation across departments.
-
Possess excellent communication and problem solving skills.
-
Be able to work effectively in both an individual role involving independent judgment, as well as in a team role involving shared input and decision-making.
The statements contained herein reflect general details as necessary to describe the essential job duties/responsibilities and performance expectations of the job, which should not be considered an all-inclusive listing of work requirements. Individuals may perform other duties as assigned.
Position involves working in an office setting. Occasional (10-33%) standing, pushing, pulling and grasping. Frequent (34-66%) reaching and viewing a computer and other types of close visual work. Constant (67-100%) sitting, walking, repetitive motion, talking and hearing.
- Associate’s or Bachelor’s Degree in computer science, information systems or related field or 2 years of programming experience in a professional capacity.
-
Experience in Microsoft SQL Database environment or its equivalent.
-
Communicate technical information effectively in both oral and written format
-
Able to interpret questions or requirements, identify problems and propose solutions.
-
Strong customer service orientation, including excellent planning, organizational, communication, and interpersonal skills.
-
Knowledge and experience of Microsoft Excel, Word, and Outlook.
PREFERRED QUALIFICATIONS, LICENSES, CERTIFICATIONS, OR REGISTRATIONS:
-
Bachelor’s Degree or higher in computer science or related field.
-
Good understanding of the development life cycle and processes.
-
Knowledge and experience with relational databases management and manipulation.
-
Knowledge and experience with Microsoft SQL Server Management Studio (SSMS) and Visual Studio SQL Server Reporting Services (SSRS).
-
Ability to import/export spreadsheet data via Microsoft SQL Server Management Studio (SSMS).
-
Working knowledge of scrum agile development methodology.
-
Knowledge and experience with project management.
-
Prior experience in state, federal, and accreditation reporting.
-
Prior experience with Ellucian Colleague.
-
Experience using integrated databases in an educational environment.
-
Knowledge of report building in Tableau.
EEO/AA STATEMENT:
It is the policy of Kirkwood Community College not to discriminate in its programs, activities, or employment on the basis of race, color, national origin, sex, disability, age, sexual orientation, gender identity, creed, religion, and actual or potential family, parental or marital status. If you have questions or complaints related to compliance with this policy, please contact the Vice President, Human Resources and Institutional Effectiveness (employees) or the Vice President of Student Services (students), 6301 Kirkwood Blvd. SW, Cedar Rapids, IA 52404, 319-398-5572,
[email protected], or the Director of the Office for Civil Rights, U.S. Department of Education, Cesar E. Chavez Memorial Building, 1244 Speer Boulevard, Suite 310, Denver, CO 80204-3582, Telephone: (303) 844-5695 FAX: (303) 844-4303, TDD 800-877-8339 Email:
[email protected].
WHY KIRKWOOD:
Kirkwood Community College prides itself on fostering a diverse workforce and values unique perspectives throughout its campus community. The college is a convenient, innovative, visionary educational leader striving to remain affordable and accessible. With more than 140 majors and programs, Kirkwood boasts 16,000 annual college-credit students while maintaining one of the lowest tuitions in the state. All degree-seeking students are eligible for federal financial aid and the college offers more than $3 million in scholarships each year to students from all walks of life.
Review of applications will continue until the position is filled.