← back to jobs
> job detail
I
👽Other

Data Analyst II

Indygo-Eacc26df · Indianapolis, IN, US
// classified as
Other (Adjacent or hard to classify.)
posted
2d ago
location
Indianapolis, IN, US
languages
python, r, sql
tools
excel
> stack
pythonrsqlexcelmatplotlibplotly
> description

Position Title: Data Analyst II 

Safety Sensitive: No

Supervisor’s Title: Operations Performance Manager

FLSA Status: Exempt

Department:  Service Planning

Division:  Operations

Worker Category: Salary Non-exempt Full-Time

Job Class: Professional

 





ABOUT US 

We are IndyGo, a Municipal Corporation of Indianapolis–Marion County, and we’re proud to be the largest public transportation provider in the state of Indiana. We operate transit routes throughout the county, providing millions of passenger trips a year. IndyGo is committed to expanding mobility options to improve connectivity with the company’s mission, vision, and goals.

WHO WE ARE 

As the largest public transportation provider in Indiana, we believe driving people from one place to another is much more than just moving riders: it’s about helping our riders reach their hopes and dreams, education and careers, families and friends, and health and well-being. IndyGo is focused on meeting three objectives as we operate nearly 30 transit routes throughout Marion County, and provide millions of passenger trips each year. They include protecting frontline workers, increasing ridership and prioritizing long-term stability. We are moving the city forward to become a better place of opportunity and community.

INDYGO MISSION

IndyGo's mission is to connect our community to economic and cultural opportunities through safe, reliable and accessible mobility experiences. Our vision is to be at the forefront of making Indianapolis a resilient, prosperous and equitable community for all.

Accountability: We are legally, ethically, and morally committed to utilizing all resources responsibly with integrity and transparency. 

Adaptability: We adapt to disruptions through technology, workforce and ridership innovations, so we can meet the evolving needs of our community. 

Workplace Culture: We offer an empowering workplace to meet the needs of our teammates and riders.

Compassion: We promote, embrace and value all individuals, treating each other with dignity and respect.

Communication: We value open and honest conversations with each other, our riders and the community.

Excellence: We are proud of who we are and the work we do and will continue to exceed customer expectations.

Responsibility: We will be good stewards of our resources.

Results: We make things better today than they were yesterday.

Safety: We ensure safe and secure environments.


BENEFITS WE OFFER 

  • Voluntary medical, dental, and vision coverage (effective on the first of the month following 30 days of employment) 
  • On-site wellness clinic for employees and their families 
  • Retirement plans (401A and 457B) 
  • Tuition reimbursement 
  • Free IndyGo transportation for employees and their families 
  • Eligibility for the Federal Loan Forgiveness Program 


POSITION PURPOSE

Familiarity with public transit operations, including bus service, ridership patterns, passenger behavior, and other financial and operational performance metrics, is essential for this position. This position analyzes data from multiple systems and sources to monitor performance, identify trends, and support service and operational improvements. Serving as a liaison across departments, this position helps drive efficiency, process enhancements, and data-informed decision-making in support of IndyGo's strategic and operational initiatives.

The Data Analyst II will collaborate with data analysts and cross-functional stakeholders to deliver insights and communicate findings to internal leadership and external audiences. This role will also proactively identify and communicate issues, anomalies, risks, and opportunities discovered through data and system monitoring.

ESSENTIAL FUNCTIONS AND RESPONSIBILITIES 

To perform this position successfully, an individual must be able to perform the essential functions of the job, with or without reasonable accommodation. The company will provide reasonable accommodations to qualified individuals with disabilities, consistent with applicable law.

  • Track, monitor, and report on Key Performance Indicators (KPIs) using quantitative and geospatial data interpretation methods.
  • Collects, validates, and interprets data from multiple internal and external sources while ensuring accuracy and integrity.
  • Designs and supports automated data pipelines for database updates and reporting, using APIs, scripting, and ETL processes to ensure reliable data integration, transformation, and timely availability of datasets for departmental reporting and analytics.
  • Perform database management functions, including maintaining databases for ridership, service KPI data, and other trip-related operational datasets.
  • Collaborate with stakeholders to document and review existing and emerging business processes, develop detailed flowcharts, and draft SOPs, while identifying gaps, inconsistencies, and opportunities to improve efficiency, standardization, and operational effectiveness.
  • Designs and develops interactive data visualizations and reporting solutions using programming languages and Business Intelligence (BI) tools, translating data into actionable insights for internal reporting and stakeholder presentations.
  • Respond to standard and ad hoc requests for relevant operation, ridership, or service data as needed for internal and external stakeholders.
  • Use historical data to research, evaluate, and summarize trends and anomalies to generate statistical data models that assess performance and measure operational costs and efficiencies. 
  • Leads various projects with departments to improve performance and efficiency and reduce costs. Identifies and monitors project deliverables scope, plan, issues, risks, and milestones. 
  • Provides ongoing oversight and support to departments to ensure that measures are being implemented to effectively manage operations and improve efficiency.
  • Supports and mentors DA1 analysts and interns by providing technical guidance on data processes, reporting, and analysis, ensuring work quality, consistency, and alignment with established standards and best practices.
  • Perform other duties as required and/or assigned.


OTHER FUNCTIONS

  • Provide support to other IndyGo departments as needed. 
  • Perform other duties as assigned in alignment with IndyGo’s strategic goals.


EDUCATION AND/OR EXPERIENCE

To perform this job successfully, an individual must have the following education and/or experience.

  • Bachelor’s degree in business, economics, statistics, data analytics, data science, computer science, or a related field. Master's degree preferred.
  • Minimum of three (3) years of professional experience in data analysis/business analysis with a bachelor’s degree or one (1) year of professional experience with a master’s degree preferred.
  • Minimum 2 years of experience working with Advanced SQL.
  • Minimum 1 year of professional experience with API-based data integration and automated data workflows, including scripting (e.g., Python or similar languages) to support data extraction, transformation, and processing.


KNOWLEDGE, SKILLS, AND ABILITIES

The requirements listed below are representative of the knowledge, skills, and/or abilities required to perform each essential duty satisfactorily.

  • Proven organizational, analytical, and problem-solving skills, with oral and written communication abilities to effectively engage diverse audiences. 
  • Ability to clearly present key findings, communicate effectively, and engage with diverse audiences using appropriate modes of communication.
  • Advanced proficiency in using advanced Excel functions like pivot tables, VLOOKUP, INDEX/MATCH, and macros, along with intermediate proficiency with Power Query for data transformation, cleaning, and preparation for efficient reporting and visualization.
  • Proficient in writing SQL queries, including window functions, stored procedures, triggers, and performance optimization techniques for efficient database operations.
  • Familiar with CRUD (Create, Read, Update, Delete) and Rest API’s for maintaining and validating data in relational databases.
  • Extracts data from external mobility and transit systems using REST APIs, leveraging Python or R libraries, with support for authentication (API keys, OAuth 2.0), pagination, and rate-limit handling.
  • Develops and maintains ETL pipelines using Python or R to transform raw JSON/API outputs into structured datasets.
  • Automates recurring data refresh cycles using scheduled scripts and workflow orchestration tools such as SQL Server Agent and Power Automate, enabling weekly or event-driven execution of API-to-database ETL pipelines.
  • Proficient in designing and developing business intelligence and data visualization solutions using Power BI, DAX, Power Query (M), Python, and R, including the use of visualization libraries such as Plotly, Matplotlib, Seaborn, ggplot2, and Shiny to support reporting, trend analysis, and executive decision-making. [SS1.1]
  • Experience in managing multiple projects simultaneously, effectively balancing priorities, deadlines, and budget constraints, while adapting to dynamic project needs and shifting focus as required.
  • Ability to collaborate inclusively with team members and departments, valuing diverse perspectives and fostering an environment of mutual respect and effective communication.
  • Ability to work independently with minimal supervision. 


PHYSICAL DEMANDS

To perform this position successfully, an individual must be able to perform the essential physical functions of the job, with or without reasonable accommodation. The company will provide reasonable accommodations to qualified individuals with disabilities, consistent with applicable law.

  • Regular on-site attendance is an essential function of this position due to the need for in-person collaboration, operational support, hands-on infrastructure management, and training and development activities. This role is designated as fully onsite and is not eligible for remote work.
  • The position may require an individual to remain stationary for extended periods without being able to leave the work area. May have to move or position themselves to use office equipment. May have to move occasionally between departments and/or facilities.
  • Local travel may be required occasionally between various agency locations.


IndyGo is an Equal Opportunity Employer

Apply at Indygo-Eacc26df →