Post Job Free
Sign in

Lead Data Analyst

Company:
Central Ohio Transit Authority
Location:
Columbus, OH, 43215
Posted:
May 25, 2025
Apply

Description:

Job Description

SALARY: $75,940.80 - $89,356.80

LOCATION: 33 N. High St. Columbus, OH 43215

BENEFITS:

Medical, Vision, Dental, Supplemental and Life Insurance

Paid Parental Leave

Employee Discounts

COTA Bus Pass

Wellness Initiatives

On-Site Chair Massage

On-Site Health Coach

Tuition Reimbursement

Student Loan Repayment Program

Public Pension through OPERS & Ohio Deferred Compensation

POSITION SUMMARY:

COTA's Lead Data Analyst will support the design and development of data integrations and reporting to enhance the accuracy and quality of decision making. Key functions include conducting in-depth data analysis, collaborating with database developers to enhance data collection and storage procedures, and developing and maintaining data integrations and ETL flows.

Performs other duties in alignment with the COTA Strategic Plan and in support of the organization's vision to Move Every Life Forward.

ESSENTIAL JOB FUNCTIONS:

Lead analyses from requirements gathering/problem statement through deployment or presentation, fully understanding business processes and objectives, underlying data and relevant factors

Independently manage analytics projects and provides regular and clear updates

Synthesize complex analyses into clear narratives to facilitate understanding and decision making

Support the design and implementation of integration flows and enhancements, including APIs and/or file-based integrations

Work cross-functionally to identify opportunities and build solutions to optimize data processing, improve data quality, identify issues and reduce failures

Gather data from primary or secondary data sources to identify and interpret trends

Create robust (advanced and/or statistical) analysis and communicate findings to management to inform business decisions and prioritize information system needs

Support Quality Assurance/Quality Control to ensure a quality level that meets COTA's requirements, monitoring data systems to ensure data quality

Collaborate with other business analysts and project team members across the department and on other projects to share knowledge and experience that can be leveraged for cross-project purposes or for improvement in the data quality process in general

MINIMUM EDUCATION & EXPERIENCE REQUIRED:

Bachelor's degree in computer science, statistics, mathematics or related field

Four (4) years of experience in data analysis

An advanced degree in data science, statistics, mathematics or a related field is strongly preferred

Analytics and Six-Sigma certifications preferred

Extensive knowledge of data analysis techniques and experience in a similar role

Background of data analysis expertise resulting in reliable information for company executives

Demonstrated expertise in advanced statistics, operations research, mathematical modeling and statistical forecasting

Demonstrated application of advanced Statistical Process Control (SPC) methodologies

Experience with ETL tools, Snowflake and AWS

Expertise in Python, R or similar

Expert in Excel, SQL, PowerBI and/or related tools

Experience with standard software development project management processes (SDLC, waterfall, RUP, agile, etc.) and/or business intelligence development

Highly skilled in verbal and written communication to an executive audience using PowerPoint and other presentation mediums

COTA is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. Equity, Diversity, and Inclusion are of core importance and essential to the success of the organization. All employment decisions are based on job needs, job requirements and individual qualifications, without regard to race, color, religion or belief, sex, sexual orientation, age, genetic information, gender identity, national origin, veteran or disability status. COTA believes that diverse and inclusive organizations gain the benefits in creating a stronger and more effective workforce resulting in services that better meet the needs of consumers and in result Move Every Life Forward.

Job Posted by ApplicantPro

Full-time

Apply