← Back to jobsJob ID col-cmvl9e09j0246s3ct8faer9ip

CTtransitPosted 28 days ago

Data Analyst

Full-time
On-site
Mid level
Competitive
Posted 28 days ago

CTtransit is hiring a Data Analyst to maintain and analyze operational data across multiple systems. The role prepares recurring reports, identifies trends and discrepancies, and supports the General Manager with reporting, projects, and administrative tasks.

Posted
28 days ago
Source
secure.entertimeonline.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • Collect, enter, maintain, validate, and reconcile operational data across multiple systems and applications
  • Develop and maintain Excel spreadsheets, trackers, logs, dashboards, and recurring reports
  • Create and utilize Excel PivotTables and other reporting tools to organize data, identify trends, and monitor operational performance
  • Analyze historical and current data to identify patterns, recurring issues, performance gaps, and emerging trends
  • Maintain trend logs and provide regular summaries of key findings to the General Manager
  • Compile daily, weekly, monthly, and ad hoc reports for management review
  • Assist the General Manager with data collection, reporting, presentations, special projects, and other administrative responsibilities
  • Review reports and records for accuracy and proactively identify discrepancies requiring follow-up
  • Learn and efficiently navigate multiple operational software applications and reporting platforms
  • Maintain organized electronic records, files, reports, and supporting documentation
  • Answer incoming telephone calls, provide professional customer service, accurately document concerns, and appropriately route or escalate inquiries
  • Communicate professionally with customers, employees, management, clients, and external stakeholders
  • Maintain confidentiality when handling employee, customer, operational, and business information
  • Perform additional administrative and operational support duties as assigned

Qualifications

  • Intermediate-to-advanced Microsoft Excel proficiency, including PivotTables, formulas, sorting, filtering, data organization, and trend analysis
  • Strong proficiency with Microsoft 365 applications, including Excel, Word, Outlook, PowerPoint, and Teams
  • Demonstrated ability to quickly learn and adapt to unfamiliar software, databases, and technology
  • Ability to interpret data and translate information into meaningful trends, summaries, and reports
  • Strong computer, data-entry, and keyboarding skills with a high degree of speed and accuracy
  • Ability to efficiently navigate multiple applications and computer systems simultaneously
  • Strong analytical and problem-solving skills
  • Exceptional attention to detail and ability to identify data discrepancies
  • Strong organizational and time-management skills with the ability to manage competing priorities
  • Strong written and verbal communication skills
  • Excellent customer service and telephone etiquette
  • Ability to interact professionally with customers and effectively handle questions, concerns, and sensitive situations
  • Ability to work independently, anticipate needs, take initiative, and complete assignments with limited supervision

Preferred

  • Previous experience in data administration, operations administration, reporting, business analysis, or a similar role
  • Experience developing reports, trackers, PivotTables, dashboards, or other data-analysis tools
  • Experience working with operational databases, scheduling systems, transportation software, HRIS, ERP, CRM, or similar business applications
  • Experience supporting senior or executive-level management
  • Transportation, transit, logistics, dispatch, call center, or other high-volume operational experience preferred

Required skills

Data AnalysisData ReportingExcel PivotTablesMicrosoft ExcelMicrosoft OutlookMicrosoft PowerPointMicrosoft TeamsMicrosoft WordTransportation and LogisticsTrend Analysis

Full job description

CTtransit is hiring a Data Analyst to maintain and analyze operational data across multiple systems. The role prepares recurring reports, identifies trends and discrepancies, and supports the General Manager with reporting, projects, and administrative tasks.

Responsibilities

  • Collect, enter, maintain, validate, and reconcile operational data across multiple systems and applications
  • Develop and maintain Excel spreadsheets, trackers, logs, dashboards, and recurring reports
  • Create and utilize Excel PivotTables and other reporting tools to organize data, identify trends, and monitor operational performance
  • Analyze historical and current data to identify patterns, recurring issues, performance gaps, and emerging trends
  • Maintain trend logs and provide regular summaries of key findings to the General Manager
  • Compile daily, weekly, monthly, and ad hoc reports for management review
  • Assist the General Manager with data collection, reporting, presentations, special projects, and other administrative responsibilities
  • Review reports and records for accuracy and proactively identify discrepancies requiring follow-up
  • Learn and efficiently navigate multiple operational software applications and reporting platforms
  • Maintain organized electronic records, files, reports, and supporting documentation
  • Answer incoming telephone calls, provide professional customer service, accurately document concerns, and appropriately route or escalate inquiries
  • Communicate professionally with customers, employees, management, clients, and external stakeholders
  • Maintain confidentiality when handling employee, customer, operational, and business information
  • Perform additional administrative and operational support duties as assigned

Preferred

  • Previous experience in data administration, operations administration, reporting, business analysis, or a similar role
  • Experience developing reports, trackers, PivotTables, dashboards, or other data-analysis tools
  • Experience working with operational databases, scheduling systems, transportation software, HRIS, ERP, CRM, or similar business applications
  • Experience supporting senior or executive-level management
  • Transportation, transit, logistics, dispatch, call center, or other high-volume operational experience preferred
  • Data Administration
  • Operations Administration
  • Business Analysis
  • Report Development
  • Tracker Development
  • PivotTables
  • Dashboard Development
  • Data Analysis Tools
  • Operational Databases
  • Scheduling Systems
  • Transportation Software
  • HRIS
  • ERP
  • CRM
  • Business Applications
  • Executive Management Support
  • Transportation Operations
  • Transit Operations
  • Logistics
  • Dispatch
  • Call Center Operations
  • High-Volume Operations

Company

  • State-owned fixed-route bus transit system in Connecticut
  • Hartford, Connecticut, USA
  • http://www.cttransit.com/
  • Founded in 1976
  • 1001-5000 employees

Qualifications

  • Intermediate-to-advanced Microsoft Excel proficiency, including PivotTables, formulas, sorting, filtering, data organization, and trend analysis
  • Strong proficiency with Microsoft 365 applications, including Excel, Word, Outlook, PowerPoint, and Teams
  • Demonstrated ability to quickly learn and adapt to unfamiliar software, databases, and technology
  • Ability to interpret data and translate information into meaningful trends, summaries, and reports
  • Strong computer, data-entry, and keyboarding skills with a high degree of speed and accuracy
  • Ability to efficiently navigate multiple applications and computer systems simultaneously
  • Strong analytical and problem-solving skills
  • Exceptional attention to detail and ability to identify data discrepancies
  • Strong organizational and time-management skills with the ability to manage competing priorities
  • Strong written and verbal communication skills
  • Excellent customer service and telephone etiquette
  • Ability to interact professionally with customers and effectively handle questions, concerns, and sensitive situations
  • Ability to work independently, anticipate needs, take initiative, and complete assignments with limited supervision
  • Previous experience in data administration, operations administration, reporting, business analysis, or a similar role
  • Experience developing reports, trackers, PivotTables, dashboards, or other data-analysis tools
  • Experience working with operational databases, scheduling systems, transportation software, HRIS, ERP, CRM, or similar business applications
  • Experience supporting senior or executive-level management
  • Transportation, transit, logistics, dispatch, call center, or other high-volume operational experience preferred

Required skills

  • Data Analysis, Data Reporting, Excel PivotTables, Microsoft Excel, Microsoft Outlook, Microsoft PowerPoint, Microsoft Teams, Microsoft Word, Transportation and Logistics, Trend Analysis

Preferred skills

  • Experience supporting senior or executive-level management

Experience

  • Mid level

Job details

Employment type

Full-time

Seniority level

Mid level

Date posted

Oct 23, 2026

Work mode

On-site

Job source

secure.entertimeonline.com

Company

CTtransit

Information Technology & AI

State-owned fixed-route bus transit system in Connecticut

  • Hartford, Connecticut, USA
  • Information Technology & AI
  • 1001-5000 employees
  • Founded 1976
  • cttransit.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Analyst jobs in Lexington

Delta Air Lines

1w ago

Sr. Data Analyst, Operations Planning and Performance

Full-timeOn-siteAtlanta, GACompetitive

Delta Air Lines’ Senior Data Analyst supports Operations Planning & Performance’s Aircraft Future Planning team by delivering data-driven insights, predictive analytics, and planning tools to improve aircraft and engine availability.

Why similarSame roleMicrosoft ExcelMicrosoft PowerPoint

Precision Technologies

4d ago

Data Analyst

Full-timeRemoteUnited StatesCompetitive

Precision Technologies is seeking an experienced Data Analyst to support business decision-making through data analysis, business intelligence, and reporting.

Why similarSame roleMicrosoft ExcelRemote

Mitchell Martin Inc.

4d ago

Data Analyst

TemporaryOn-siteNew York, NYCompetitive

Mitchell Martin Inc. is recruiting for a confidential client seeking a Data Analyst to support front-office operations in investment and asset management.

Why similarSame roleData Analysis

Get new Data Analyst jobs in Lexington by email

Create job alert

Data Analyst

CTtransit · Competitive

Apply on company site