Ryan R. Johnson
Muncie,United States
Summary
Accomplished Executive Director with Ivy Tech Community College, pioneering statewide data governance frameworks and driving strategic initiatives. Expert in Tableau and SQL, delivering actionable insights for senior leadership. Proven leader in fostering collaboration and innovation, enhancing data-driven decision-making. Successfully managed projects, achieving efficiency and cost savings, while cultivating talent pipelines and maintaining high team morale.
Overview
33
33
years of professional experience
Work History
Executive Director of Business Intelligence
Ivy Tech Community College
Indianapolis, United States
02.2023 - Current
- Established Ivy Tech's first statewide Data Governance framework, bringing together Policy Council, Campus Chancellors, and Executive Leadership to formalize policy, establish accountability, and standardize data stewardship practices.
- Partner with Campus and Systems Office leadership to assess institutional reporting needs and deliver actionable insights that support informed decision-making at the senior leadership level, guiding both operational improvements and strategic planning.
- Led cross-functional teams in executing strategic initiatives to enhance operational effectiveness and drive innovation across the college, providing vision and structure to ensure successful project outcomes.
- Lead the team in creating and delivering custom analytics training for college leaders and staff-focused on Tableau and data literacy-to strengthen data-driven decision-making across the organization.
- Guide the team in building expertise in Tableau, SQL, Git, and ETL development, promoting best practices and maintaining high standards for quality, performance, and efficiency.
- Fostered strong culture of recognition and team cohesion, creating environment that supports collaboration and high morale, resulting in impactful presentations at national, state, and Ivy Tech conferences.
- Proactively build talent pipelines by identifying, recruiting, and cultivating relationships with prospective team members to meet future staffing needs.
- Managed project and ticket workflows in ServiceNow to streamline operations and enhance team coordination.
- Manage external contractors on time-sensitive projects, ensuring all deliverables are completed on schedule and within budget.
Director of Business Intelligence
Ivy Tech Community College
Indianapolis, United States
03.2022 - 02.2023
- Led and managed a team of developers responsible for the statewide implementation of Tableau Online, overseeing a user base of 1,200 individuals.
- Collaborated closely with leadership teams across Campus and Systems Office to identify and address reporting needs, providing critical insights and guidance on both operational and strategic issues.
- Managed implementation aspects, including site administration, security, development, and staff training, yielding a functional and efficient system.
- Spearheaded on-site optimization efforts to streamline reporting and enhance site organization, leading to improvements in productivity.
- Oversaw 40 Campus Data Leads statewide, providing support, consulting on requests and projects, and hosting monthly meetings to reinforce standards.
- Developed statewide training program, leveraging videos, synchronous online training, and knowledge base articles.
- Directed and oversaw the work of external contractors on various short-term projects.
Business Intelligence Analyst/Team Lead
Ivy Tech Community College
Indianapolis, United States
09.2020 - 03.2022
- Led the successful statewide implementation of Tableau as Project Lead, managing a team of developers and contractors to deliver the project on time and within budget. Oversaw all aspects of change management, communication, training, and platform development.
- Partnered with cross-functional teams and key stakeholders to align on project goals and requirements, proactively mitigating risks and resolving issues to ensure seamless execution.
- Directed daily workflow of seven-member contractor team for design, development, and rollout of Tableau Online, delivering end-user training and support.
- Designed and launched statewide Campus Data Lead program, enhancing data literacy and best practice sharing among 40 data leads across multiple campuses.
- Developed and delivered training programs to enhance staff capabilities in SQL, Git, Python, and Tableau.
Business Intelligence Analyst
Ivy Tech Community College
Indianapolis, United States
07.2019 - 09.2020
- Partnered with business stakeholders to gather and document comprehensive requirements for software development and data projects.
- Developed efficient, well-structured code using Python and SQL in Jupyter Notebooks to support data analysis and automation workflows.
- Built and optimized ETL processes using Apache Airflow, AWS, Redshift, and Snowflake, applying best practices for data integrity, warehousing, and performance.
- Developed dashboards and data visualizations using Tableau, Looker, Pentaho, and Excel, enabling data-informed decision-making.
- Generated custom reports in Pentaho Report Designer, applying SQL expertise to ensure data accuracy and deliver actionable insights.
- Facilitated training sessions on ad hoc reporting with Jupyter Notebooks and Git, enhancing data self-service and technical skills among staff.
- Managed data and analytics platforms on Linux servers, including JupyterLab and Pentaho.
Assistant Director of Institutional Research, Central Office
Ivy Tech Community College
Indianapolis, United States
12.2013 - 07.2019
- Provided data-driven insights to senior leadership through advanced data mining, statistical analysis, and trend identification, leading to actionable strategies for institutional improvement.
- Led the data team for a statewide campus reorganization initiative, redesigning the reporting structure and redefining campus responsibilities to support strategic alignment across all locations.
- Oversaw institutional data reporting for external partnerships and initiatives, including InsideTrack's 21st Century Scholar coaching, Stanford's PERTS initiative, and Harvard's Study Supporter project.
- Acted as Shared Services Liaison for East Central and Richmond regions, collecting and analyzing data to enhance instruction, student support, marketing, and metrics for graduation and retention.
- Developed and delivered training materials for Ivy Tech's enterprise data warehouse rollout, conducting in-person and virtual sessions across most campuses statewide.
Director of Institutional Research, East Central/Richmond Region
Ivy Tech Community College
Muncie, United States
11.2011 - 12.2017
- Established inaugural Regional Director of Institutional Research role and Shared Services model with Central Office, enabling data-informed leadership across the institution.
- Led the development, presentation, and execution of regional strategic plans, aligning term-based and annual goals with institutional priorities.
- Collaborated with regional leadership to define and report on key performance indicators (KPIs), guiding strategic planning efforts to enhance instructional quality, student support services, graduation and retention rates, and recruitment initiatives.
- Applied regression analysis on historical data to generate forecasts that informed long-term planning.
- Designed and evaluated test and control groups to measure the effectiveness of new initiatives and drive data-informed decision-making.
- Oversaw staff engaged in SQL and R development, ensuring delivery of high-quality data products and fostering professional growth.
- Delivered technical and strategic presentations across the region, translating complex reports into actionable insights and improvement strategies for a variety of audiences.
- Acted as Shared Services Liaison for Central Office since 2013, providing regional leadership with strategic planning, data collection, and analytics support to align regional goals with statewide initiatives.
Adjunct Faculty, School of Business and School of Liberal Arts
Ivy Tech Community College
East Central Region
01.2010 - 12.2016
- Delivered engaging instruction across traditional, online, and hybrid modalities, enhancing student learning experiences.
- Successfully taught 414 students across 25 course sections, consistently driving strong engagement, retention, and academic performance.
- Developed and taught diverse curriculum portfolio, including Business Statistics, Principles of Management, Introduction to Business, Principles of Marketing, Data Communications, Introduction to Microcomputers, World Geography, and First Year Seminar.
- Incorporated real-world case studies, hands-on data tools, and interactive learning strategies, facilitating comprehension of complex concepts.
Student Advisor
Ivy Tech Community College
New Castle, United States
01.2011 - 11.2011
- Developed personalized academic plans tailored to each student's skills, interests, and career goals, fostering student success and retention.
- Guided students at New Castle campus in course selection, program planning, and goal setting to enhance academic pathways.
- Administered Accuplacer placement assessments to evaluate student readiness and determine appropriate course placements.
Owner
TJ's Screen Printing
Indianapolis, United States
10.2009 - 01.2011
- Founder and owner of a custom design and print business specializing in screen printing, vinyl graphics, and signage.
- Managed end-to-end operations, driving marketing, sales, procurement, production, and digital strategy.
- Directed creative and brand development, designing impactful client assets using Adobe Illustrator, Inkscape, and GIMP.
- Sourced, contracted, and coordinated external printers and designers, scaling production while ensuring quality delivery.
- Grew a loyal client base by delivering bespoke design solutions, fast turnaround, and exceptional craftsmanship.
Front End Project Manager/Estimator
Redirections Sign & Design
Indianapolis, United States
07.2007 - 10.2009
- Oversaw full-cycle estimating, procurement, and production planning using Shoptech's E2 ERP system, creating custom quoting models for complex signage products such as electrical signs and vehicle wraps, enabling a sales force operating across four states to provide accurate and timely quotes.
- Cultivated trusted relationships with sales teams, suppliers, and clients through expert guidance on material selection and fabrication strategies, enhancing overall project success and cost efficiency.
- Managed field operations for a 3-7 person installation team, leading scheduling, client coordination, site readiness, safety compliance, and utility clearances to ensure high-quality, on-time delivery.
- Directed a rotating workforce of 15 contractors to execute high-volume weekend signage campaigns for real estate and commercial clients throughout the Indianapolis region.
- Consistently surpassed performance expectations, earning quarterly bonuses during every eligible period.
GIS Analyst
City of Indianapolis
Indianapolis, United States
01.2004 - 07.2007
- Served as a technical lead on high-impact municipal initiatives-including police beat restructuring, fire station consolidation planning, neighborhood boundary redesign, and DigSmart utility coordination-providing geospatial analysis to guide policy and operational decisions.
- Architected automated Python-based geoprocessing pipelines, transitioning manual workflows into scalable, repeatable processes used by multiple agencies.
- Designed and deployed custom ArcGIS/ArcPad tools using VBA to extend platform capabilities and optimize field workflows for public safety and infrastructure teams.
- Supported enterprise GIS infrastructure using ESRI ArcGIS, ArcPad, and ArcIMS platforms, establishing standards for tool deployment, data integrity, and automation that enhanced inter-departmental collaboration.
- Administered and governed a centralized SDE geodatabase of 180+ feature classes for Marion County, implementing version control, QA workflows, and metadata standards.
- Developed internal enablement resources, including technical documentation, FAQs, and troubleshooting systems, to empower GIS analysts and non-technical end users in utilizing GIS tools effectively.
MIS Specialist
Muncie Indiana Transit System
Muncie, United States
07.1998 - 12.2003
- Administered and optimized Trapeze TransCAD Midas-PT (demand response routing) and Midas-CIS (fixed-route itinerary planning), ensuring reliability and efficiency of core public transit scheduling systems.
- Authored technical specifications and oversaw deployment of transit technologies-including network infrastructure, digital video systems, infrared passenger counters, mobile data terminals, GPS/GIS tracking, and fare collection systems, enhancing operational capabilities.
- Led governance and maintenance of all GIS layers and spatial databases-including street networks, pedestrian paths, route alignments, transfer hubs, and fleet infrastructure-to support daily operations and strategic planning.
- Directed GIS-based analysis of passenger flow, routing efficiency, trip demand, and fare data using ArcView and ArcLogistics Route, enabling data-informed service adjustments.
- Managed organization's IT systems budget, overseeing forecasting, procurement, implementation, and lifecycle management of hardware and software to align with strategic initiatives.
- Administered enterprise IT infrastructure, including Novell 5 servers, GroupWise email platform, internal intranet, and corporate website, ensuring security, uptime, and performance across business units.
Computer Information Systems Tech/E-4
US Air Force
Peterson AFB, United States
07.1993 - 08.1996
- Oversaw installation, maintenance, and repair of personal computer systems at Peterson AFB, ensuring operational readiness.
- Operated in DOS and Windows environments to perform technical tasks, contributing to system functionality.
- Provided hands-on support for Novell and Windows for Workgroups networks, enhancing connectivity and user experience.
- Specialized in hardware installation and upgrades, including printers, scanners, CD-ROMs, hard drives, RAM, cache, and removable storage systems.
Education
Masters - Business Administration
Ball State University - College of Business
01-2011
BS - Management
Ball State University - College of Business
01-2000
Associate of Arts and Sciences - AAS - Software Development
Ivy Tech Community College
05-2021
Technical Certificate - Business Administration
Ivy Tech Community College
01-1993
Certificate - Web Application Development
Ivy Tech Community College
01-2020
Skills
- Data governance
- Institutional reporting
- SQL development
- ETL processes
- Tableau proficiency
- Custom analytics training
Timeline
Executive Director of Business Intelligence
Ivy Tech Community College
02.2023 - Current
Director of Business Intelligence
Ivy Tech Community College
03.2022 - 02.2023
Business Intelligence Analyst/Team Lead
Ivy Tech Community College
09.2020 - 03.2022
Business Intelligence Analyst
Ivy Tech Community College
07.2019 - 09.2020
Assistant Director of Institutional Research, Central Office
Ivy Tech Community College
12.2013 - 07.2019
Director of Institutional Research, East Central/Richmond Region
Ivy Tech Community College
11.2011 - 12.2017
Student Advisor
Ivy Tech Community College
01.2011 - 11.2011
Adjunct Faculty, School of Business and School of Liberal Arts
Ivy Tech Community College
01.2010 - 12.2016
Owner
TJ's Screen Printing
10.2009 - 01.2011
Front End Project Manager/Estimator
Redirections Sign & Design
07.2007 - 10.2009
GIS Analyst
City of Indianapolis
01.2004 - 07.2007
MIS Specialist
Muncie Indiana Transit System
07.1998 - 12.2003
Computer Information Systems Tech/E-4
US Air Force
07.1993 - 08.1996
Masters - Business Administration
Ball State University - College of Business
BS - Management
Ball State University - College of Business
Associate of Arts and Sciences - AAS - Software Development
Ivy Tech Community College
Technical Certificate - Business Administration
Ivy Tech Community College
Certificate - Web Application Development
Ivy Tech Community College