Systems Reporting Analyst III

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.

About the Role

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.

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 large and small projects (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.
• 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.

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.

Physical Activities

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.

Requirements

• 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

• Experience with Python, R and data modeling.
• Experience in higher education or similar organization.

Schedule

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

Additional Information

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.