Analyst II - Revenue
About The Position
Responsible for analyzing, forecasting, reconciling, and reporting on agency PCI compliance activities. This role involves monitoring agency PCI compliance, reconciling DART systems, researching and explaining reconciliation variances to minimize fraud risk, and preparing monthly agency reports including data scrubbing, analysis, and trend maintenance. The position also involves preparing reports and recommendations for management, providing technical assistance and training, reviewing customer comments, investigating and resolving customer concerns, and issuing customer refunds. Additionally, the role performs data analysis of current fare programs, monitors performance, builds and automates reporting dashboards, data pipelines, and financial models. It requires complex analysis and recommendations for business research and operations related to fare collection systems, including analyzing and reporting on transactions and trends associated with various payment methods, ridership data, operational performance data, and budgets. The analyst will also analyze potential automation areas, develop methods for improving user interfaces and maintenance protocols, analyze and produce reports on agency ridership, fare revenue, and ticket sales, and create/maintain departmental Standard Operating Procedures (SOPs). Ensuring accurate fraud detection methods are in place and updated with industry standards, and providing support to senior staff in complex projects are also key responsibilities.
Requirements
- Bachelor’s degree from an accredited college or university in Business, Accounting, Finance, Statistical or Data Analysis or related field.
- Two (2) years progressively responsible experience involving data analysis, account reconciliation, analysis of performance trends or related field.
- Pass a physical (medical) examination that includes a drug screen.
- Proficiency of PC software applications to include SQL, Tableau, Power BI, Microsoft Office or other related software applications.
- As a condition of employment, must pass a criminal background and credit check.
- High level of analytical ability required to find solutions to complex interpersonal, financial, administrative, professional, and technical problems.
- Able to analyze moderately complex data sets, to accurately summarize data, and to characterize causal relationships and interrelationships between and among variables.
- Ability to use various back-office systems, reporting tools and investigative methods to resolve customer issues, refunds and disputes are responded to in a timely manner.
- Interpersonal skills required to effectively communicate with staff, all levels of management and non-supervisory employees, vendors, government entities, contractors, and others internal and external customers.
- Ability to work independently to reach goals set by management.
- Ability to be dedicated to meeting the expectations and requirements of internal and external customers.
- Ability to write clearly and succinctly in a variety of communication settings and styles.
- Ability to make good decisions based upon a mixture of analysis, wisdom, experience, and judgment.
- Ability to use rigorous logic and methods to solve difficult problems with effective solutions.
- Ability to quickly find common ground and solve problems for the good of all.
Responsibilities
- Reconciling DARTs systems.
- Researching, identifying, explaining and reporting reconciliation variances to minimize fraud risk.
- Preparing monthly reporting for the agency, including data scrubbing, analyzing and maintaining trends.
- Researching and explaining significant variances to thresholds.
- Preparing reports for and making recommendations to management based upon results of analyses/evaluations.
- Providing technical assistance and training to staff.
- Reviewing customer comments report monthly.
- Investigating and resolving customer concerns.
- Issuing customer refunds.
- Performing data analysis of current fare program and regularly monitoring performance.
- Building and automating reporting dashboards, data pipelines, and financial models.
- Performing complex analysis and providing recommendations for business research and operations related to fare collection systems.
- Analyzing and reporting on transactions and trends associated with cash, credit cards, and other means of payment; ridership data and other operational performance data; and budgets related to assigned projects.
- Analyzing potential areas of automation to determine user and technical needs and recommending possible solutions, including process redesign and individual programs.
- Developing methods for improving/optimizing user interfaces and maintenance protocols.
- Analyzing, evaluating, and producing reports (both custom and system provided) relating to agency ridership, fare related revenue and ticket sales.
- Creating and maintaining departmental Standard Operating Procedures (SOP’s) for daily, weekly and monthly functions.
- Ensuring accurate fraud detection methods are in place and updated with industry standards.
- Providing support to senior staff in complex projects as directed.
- Performing other related duties as assigned.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
