Kirkwood Community College Compliance Reporting Analyst I in Cedar Rapids, Iowa
Compliance Reporting Analyst I
Compliance Reporting Analyst I
Cedar Rapids, IA
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 Compliance Reporting Manager and support Institutional Research. This position will be responsible for compliance reporting and supporting information needs for Kirkwood’s mission and vision.
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.
Adhere to Compliance Reporting Team SQL coding standards.
Test reporting logic against business rules and develop data validation audits.
Thoroughly 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.
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.
Participate and collaborate with team on scrum agile processes.
Assist Compliance Reporting Manager in reviewing requirements and technical specifications.
Perform other related work duties as assigned.
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.
PHYSICAL ACTIVITIES WITH/WITHOUT REASONABLE ACCOMMODATION:
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. Proficiency in Microsoft SQL Database environment or its equivalent. Good understanding of the development life cycle and processes. 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.
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.
Prior experience in state, federal, and accreditation reporting.
Prior experience with Ellucian Colleague.
Experience using integrated databases in an educational environment.
Working knowledge of report building in Tableau.
Kirkwood Community College shall not engage in nor allow unlawful discrimination against any employee or applicant for employment. This includes all employment practices, hiring practices, and unwelcome harassment of applicants or employees based on race, color, national origin, creed, religion, sex, sexual orientation, gender identity, age, disability, genetic information or actual or potential parental, family, marital status or veteran status. If you have questions or complaints related to compliance with the policy, please contact the Vice President of Human Resources at Kirkwood Community College, 313 Kirkwood Hall, 6301 Kirkwood Blvd., SW, Cedar Rapids, IA 52404, Telephone: 319-398-5572, Email: equity@Kirkwood.edu or the Director of the Office for Civil Rights U.S. Department of Education, Citigroup Center, 500 W. Madison St., Suite 1475, Chicago, IL 60661-7204, Telephone: 312-730-1560, Fax: 312-730-1576, Email: OCR.Chicago@ed.gov.
Kirkwood offers a wide range of employee benefits. Read more about them here (http://www.kirkwood.edu/humanres/employees/benefits) !
Do you have an Associate's or Bachelor's Degree in computer science, information systems, related field OR 2 years of programming experience in a professional capacity?
Kirkwood Community College
6301 Kirkwood Blvd SW Cedar Rapids, Iowa, 52404