Lead Data Analyst

Central Ohio Transit Authority (COTA); Columbus (OH); On-site; USD 76,000 - 89,000; Full time

Benefits offered by this job

Medical insurance

Vision insurance

Dental insurance

Life insurance

Parental leave

Employee discounts

Bus pass

Wellness initiatives

Chair massage

Health coach

Tuition reimbursement

Student loan repayment

Public pension (OPERS)

Deferred compensation

Job summary

Central Ohio Transit Authority (COTA) seeks a Lead Data Analyst to design and develop data integrations and reporting to enhance decision making. You will conduct in-depth data analysis, collaborate with database developers to improve data collection and storage, and maintain ETL flows aligned with COTA's strategic plan and core values.

You will lead cross-functional analytics projects, present clear narratives, and contribute to data quality improvements across the organization.

Qualifications

• Requires a bachelor’s degree in computer science, statistics, mathematics or related field and a minimum of four years of data analysis experience.

Responsibilities

• Leads analyses from requirements through deployment or presentation, understanding business processes and data.
• Manages analytics projects with regular status updates.
• Synthesizes analyses into clear narratives for decision making.
• Designs and implements data integration flows and APIs or file-based integrations.
• Collaborates cross-functionally to improve data processing and quality.
• Gathers data from primary/secondary sources to identify trends.
• Creates advanced analyses and communicates findings to inform decisions.
• Documents processes and maintains data records.
• Keeps current with data quality trends and best practices.
• Supports QA/QC to meet data quality requirements.

Education

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

Job description

Salary: $75,940.80 - $89,356.60

Location: 33 N. High Street, 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 duties that advance COTA's Strategic Plan and reflect the organization's core values of safety, empowerment, accountability, teamwork, and service, and support the mission of Moving Every Life Forward.

Essential Job Functions

• Leads analyses from requirements gathering or problem statement through deployment or presentation, fully understanding business processes and objectives, underlying data, and relevant factors;
• Independently manages analytics projects and provides regular and clear updates; and,
• Synthesizes 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.
• Document processes and maintain data records.
• Adhere to best practices in data analysis and collection.
• Keep abreast of developments and trends in data quality analysis.
• Support Quality Assurance/Quality Control to ensure a quality level that meets COTA's requirements; monitors 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.
• Performs other duties as assigned; and
• Regular, predictable and punctual attendance required.

Minimum Education & Experience Required

• Requires a bachelor's degree in computer science, statistics, mathematics, or related field and minimum of four (4) years of experience in data analysis. An advanced degree in data science, statistics, mathematics or a related field is strongly preferred.

COTA is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. 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

Salary: $75940.80 - $89356.60

Job Posted by ApplicantPro