Data Analyst II

This is an onsite position. This role will not be remote.

Applicants must be currently authorized to work in the US on a full-time basis. IPTC will not sponsor visas or work authorizations for this position.

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 31 transit routes throughout the county, providing nearly 10 million passenger trips a year to the good citizens of our region. IndyGo is committed to expanding mobility options to improve connectivity with the company’s mission, vision, and goals.

WHO WE ARE

A key measure of any great city is the ease of getting from one place to another. We call it “mobility.” It’s as essential as access to electricity and clean water. It moves a city forward to become a better place of opportunity and community. It’s a measure of a city’s vitality and potential, and it reflects a city’s judgment about its civic priorities. It makes a city a better home and a better place to visit.

At IndyGo, getting people from one place to another is much more than just moving riders: it’s about getting our riders to their hopes and dreams, to their education and careers, to their families and friends, to their health and well-being, and another day of life in Indianapolis and the surrounding areas.

We’re here because you’ve got somewhere you need to be, and you need an easy, reliable way to get there. So come on; get on and get going to wherever you want to go on IndyGo.

INDYGO MISSION

As the region's largest transit authority, we are duty-bound to set the bar for transparency, trust, and overall professionalism. Our mission is to connect our community to economic and cultural opportunities through safe, reliable, and accessible mobility experiences.

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

• Full-time positions with guaranteed 40 hours/week.
• Medical, dental, and vision (effective on the 1st of the month, 30 days after the start date).
• Free on-site wellness clinic for employees and their families.
• Retirement plan (401A and 457B).
• Tuition reimbursement.
• Free IndyGo transportation for employees and their families.
• Federal Loan Forgiveness Program

POSITION PURPOSE

Familiarity with, or experience in analyzing "things that move," as in vehicles or people, is a foundational aspect of the work that will be performed in this position. This position is also responsible for managing multiple diverse and complex projects to track performance improvement and serves as a liaison to achieve efficiency and process improvements throughout the agency. This would be achieved through various levels of technical data management, supporting IndyGo's current and future projects through the analysis of data from multiple sources. These functions will generally be performed to identify, visualize, and track key performance indicators, measure progress on desired outcomes, and identify potential efficiencies in agency processes and procedures.

The chosen candidate will work in partnership with others in their respective division and other departments to conduct relevant analyses and communicate meaningful insights to general stakeholder groups and the public at large. This position will also be responsible for alerting others to any issues, anomalies, or opportunities they uncover while performing their duties.

ESSENTIAL FUNCTIONS AND RESPONSIBILITIES

To succeed in this role, an individual must satisfactorily perform the functions listed below. The company will provide reasonable accommodations to enable individuals with disabilities to perform these functions.

ESSENTIAL FUNCTIONS

• Creates automated workflows and interactive dashboards to generate departmental reporting, using programming languages and/or BI tools.
• Develops and enhances methods for data collection, validation, and analysis from multiple internal and external sources, ensuring accuracy, integrity, and proper documentation.
• Perform database management functions, including the maintenance of databases for ridership data, service data, and field collection data.
• Respond to standard and ad hoc requests for relevant operation, ridership, or service data as needed for internal and external customers.
• 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 affect improved efficiency.
• 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.

SUPERVISORY RESPONSIBILITIES

• None

EDUCATION AND/OR EXPERIENCE

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

• Bachelor’s degree in business, economics, statistics, data analytics, data science, computer science, or a related field, or a combination of education and professional experience equivalent. 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 professional experience working with Advanced SQL, automating scripts, Excel, Power BI/Tableau, and data manipulation/statistical software packages such as R, SAS, or Python.
• Experience in working with APIs for data retrieval and integration, as well as utilizing web scraping libraries for automated data extraction 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.
• Proficient in writing SQL queries, including window functions, stored procedures, triggers, and performance optimization techniques for efficient database operations.
• Proficient in developing interactive dashboards and reports in Power BI, utilizing DAX, Power Query (M), and data modeling techniques for insightful visual analytics and business intelligence solutions.
• Proficient in using Power Query for data transformation, cleaning, and preparation, along with advanced Excel functions like pivot tables, VLOOKUP, INDEX/MATCH, and data analysis tools for efficient reporting and visualization.
• Skilled in API integration for ETL workflows, leveraging Python (e.g., requests, Airflow) and R for automation scripting, data extraction, transformation, and process optimization.
• Skilled in web scraping using Python libraries, enabling automated data extraction, parsing, and integration into ETL workflows.
• Experience in managing multiple projects simultaneously, effectively balancing priorities, deadlines, and budget constraints, while adapting to dynamic project needs and shifting focus as required.
• Experience with SQL Server Reporting Services (SSRS) for developing and deploying reports and SQL Server Integration Services (SSIS) for ETL processes and data workflows.
• 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.
• Ability to work in a deadline-oriented office environment.

PHYSICAL DEMANDS

The physical demands described here are representative of those an individual must meet to successfully perform the essential functions of this job.

• 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.