HI
Client: City College of Chicago
Job Title: BI Developer and Data Architect
Location: Remote
Duration: 4–6 weeks (Possible extension)
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
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:
- Tableau Desktop Certified Professional
- Tableau Server Certified Professional
- Tableau Data Management Certified