Data Analyst II

Indygo • Indianapolis, IN

1d • Onsite

About The Position

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.

Requirements

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

Responsibilities

• 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.
• Provide support to other IndyGo departments as needed.
• Perform other duties as assigned in alignment with IndyGo’s strategic goals.

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 251-500 employees