BI Developer

CCC Reporting & Dashboard Development

SCOPE OF WORK

THE CITY COLLEGES OF CHICAGO

5/22/2026

OVERVIEW

City Colleges of Chicago (CCC) is seeking an experienced BI Developer to support the development of interactive dashboards, reports, and analytical solutions that provide centralized access to key institutional metrics. These solutions will support data-informed decision making, operational planning, and student success initiatives in alignment with institutional priorities, including 55 for All. The consultant will support multiple reporting and analytics initiatives across departments by developing scalable, user-friendly reporting solutions and improving access to institutional data. The ideal consultant will have expertise in Tableau dashboard development, data visualization, and reporting tools, along with experience translating business and operational needs into technical solutions. CCC's Decision Support and Business Intelligence teams will provide the necessary data access, licenses, and institutional support. The consultant may work on multiple reporting projects, dashboards, and analytical initiatives that support institutional health, operational effectiveness, strategic planning, and continuous improvement efforts across the organization.

SCOPE OF WORK

The selected consultant will be responsible for:

Dashboard Design and Development
• Designing, developing, and maintaining interactive dashboards, reports, and visual analytics solutions for institutional and operational reporting needs
• Creating standardized and reusable dashboard templates and reporting frameworks that can support multiple initiatives and departments
• Developing intuitive navigation, filtering, and self-service functionality for end users
• Supporting reporting initiatives related to institutional effectiveness, student success, compliance, operations, and strategic planning
• Applying data visualization best practices and accessibility standards across reporting solutions

Data Integration and Automation
• Connecting dashboards and reports to institutional data systems and data sources for scheduled or real-time updates
• Supporting automated data refresh processes, validation procedures, and quality assurance activities
• Collaborating with internal teams to establish appropriate data governance, security, and reporting standards
• Assisting with integration of reporting tools with databases, APIs, SharePoint lists, and other enterprise systems

Content Organization
• Collaborating with stakeholders to standardize metric definitions, calculations, and reporting methodologies
• Ensuring consistency in reporting structures, dashboard layouts, and visualization practices across projects
• Supporting documentation of reporting processes, governance standards, and technical workflows

Testing and Continuous Improvement
• Conducting usability testing and gathering stakeholder feedback to improve reporting solutions
• Developing sustainable maintenance and support processes for long-term reporting initiatives

User Training and Documentation
• Creating Developing training materials and guides for end users and administrators

Timeline

Proposals should include a clear timeline, but we aim to begin this work in mid-July 2026 and end in late-August with the possibility of extending based on institutional needs.

Preferred Qualifications

Technical Expertise
• Expert proficiency in Tableau Desktop, Prep and Cloud with demonstrated experience creating interactive dashboards, is required
• Experience in dashboard development, including interactive features and automated data pipelines
• Strong knowledge of higher education data structures and common metrics
• Ability to integrate Tableau with institutional data systems and databases, including PeopleSoft CS9, SharePoint, OpenBook, and application programming interfaces (APIs).
• Strong background in data visualization best practices and accessibility standards
• Proficiency in SQL, ETL processes, and relevant programming languages

Collaboration & Communication Skills
• Ability to work collaboratively with stakeholders across multiple departments
• Strong problem-solving skills and ability to translate user needs into technical solutions
• Experience creating clear documentation and training materials
• Excellent verbal and written communication skills

Preferred Experience & Certifications
• Tableau dashboard development experience in a higher education environment
• Previous work with community college data systems and metrics
• Tableau certifications such as:

o Tableau Desktop Certified Professional

o Tableau Server Certified Professional

o Tableau Data Management Certified