Systems Reporting Analyst III

JOB GOAL:

To advance the college’s mission, vision, principles, values and strategic initiatives through activities that promote innovative, quality, clinical experiences that promote student clinical competence and maintain/improve community partnerships.

GENERAL JOB SUMMARY:

The Systems Reporting Analyst III is a technology professional responsible for helping to lead the College's reporting, analytics, and business intelligence initiatives. This role provides technical leadership in design, development, administration, and optimization of enterprise reporting solutions, including SQL Server Reporting Services (SSRS), Tableau Cloud, Entrinsik Informer, and related data systems.

Working closely with leadership, stakeholders, and technical teams, the position serves as a trusted advisor in transforming business needs into secure, scalable, and data-driven solutions. The Systems Reporting Analyst III leads complex projects, establishes reporting standards and best practices, drives data governance and quality initiatives, and supports strategic planning efforts to enhance informed decision-making.

The typical working schedule will be Monday through Friday from 8 am to 5 pm.

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.

DUTIES/RESPONSIBILITIES:

Lead and mentor reporting services team members, providing technical guidance, coaching, and support.

Manage and lead reporting and dashboard development projects, including planning, resource coordination, timeline management, and successful delivery of solutions.

Create, maintain, and enhance reports, dashboards, and analytics solutions using SSRS, Tableau, Entrinsik Informer and related reporting tools. Generate routine and ad hoc reports as needed.

Partner with stakeholders and senior leadership to gather business requirements, define objectives, and translate needs into technical solutions.

Serve as the technical lead and subject matter expert for reporting services, data architecture, and business intelligence solutions.

Design, develop, and maintain SQL Server database solutions, including queries, views, stored procedures, and data integrations.

In collaboration with others, develop and implement data collection systems and other strategies that optimize efficiency and data quality.

Perform data analysis, statistical analysis, and data interpretation to support operational and strategic decision-making.

Ability to lead a large and small project (Large is over 400hrs and more than 1 team member).

Assume ownership of project deliverables by independently planning and executing assigned work, regularly reporting progress to management, and proactively escalating risks, dependencies, and schedule variances to ensure successful project completion.

Collaborate with project management and cross-functional teams to ensure adherence to project methodologies, timelines, and organizational standards.

Provide technical support and problem resolution for reporting systems, user access issues, and reporting-related applications.

Develop and maintain technical documentation, reporting logic, workflows, and operational procedures.

Drive continuous improvement initiatives by identifying opportunities to optimize business processes, reporting capabilities, and system efficiencies.

Build and maintain strong collaborative relationships across the organization to support strategic initiatives, innovation, and effective service delivery.

PERFORMANCE EXPECTATIONS:

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.

Exceptional analytical, problem-solving, and conceptual thinking abilities.

Strong leadership, collaboration, and mentoring skills.

Bridge technical and non-technical audiences by clearly communicating complex technical concepts and analytical findings, facilitating stakeholder alignment on business requirements, solution design, and project outcomes.

Demonstrated ability to effectively prioritize and manage multiple tasks in a fast-paced environment, work independently with minimal supervision, and maintain productivity and quality despite competing demands and frequent interruptions.

Ensure data integrity, governance, security, and data quality standards are maintained across reporting systems, databases, and integrated applications.

Develop and execute testing, validation, and quality assurance processes to ensure reporting solutions are accurate and meet requirements.

Lead or support change management activities associated with new reporting solutions, system enhancements, and process improvements to promote successful adoption and utilization.

Research, evaluate, and recommend emerging technologies, reporting platforms, and industry best practices to enhance reporting capabilities, system performance, and organizational effectiveness.

Monitor and evaluate system, report, and data performance, proactively identifying opportunities for optimization, automation, and continuous improvement.

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. The position involves occasional (10-33%) driving to events and meetings away from KCC’s main campus.

MINIMUM QUALIFICATIONS:

Bachelor’s degree in Information Systems, Computer Science, Data Analytics, or a related field (or equivalent experience).

Minimum of 7+ years of experience in reporting, systems analysis, data analytics or business intelligence.

5+ years of experience in one of the following reporting tools such as Tableau, Power BI, Informer or SQL Server Reporting Services.

Strong proficiency in SQL, including the ability to extract, transform, validate, and analyze data from multiple enterprise systems and databases.

Experience translating business requirements into reporting solutions, metrics, dashboards, and actionable insights for business leaders and stakeholders.

Must be legally authorized to work in the United States.

PREFERRED QUALIFICATIONS, LICENSES, CERTIFICATIONS, OR REGISTRATIONS:

Experience with Python, R and data modeling a plus.

Experience in higher education or similar organization.

Additional Information:

• Sponsorship for employment authorization, including employment visa sponsorship or transfer of sponsorship, is not available for this position.
• This position is expected to be performed on-site for the initial six-month onboarding and training period. Upon successful completion of this period, eligibility for a hybrid work schedule may be considered in accordance with college policy and operational requirements.

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,equity@kirkwood.edu, 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: OCR.Denver@ed.gov.
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.