Analyst II - Revenue

dart; United States; Vor Ort; USD 59.000 - 97.000; Vollzeit

Zusammenfassung

DART analysts drive data-driven decision making by reconciling transactions, forecasting ridership and revenue trends, and preparing monthly reports. The role emphasizes building dashboards and data pipelines to support fraud prevention and operational efficiency.

Ideal candidates combine strong analytical abilities with experience in SQL, Tableau or Power BI and proficiency in MS Office, ready to work in a data-intensive environment.

Qualifikationen

• Bachelor's degree in Business, Accounting, Finance, Statistics or Data Analysis or related field.
• Two years of progressively responsible data analysis or reconciliation experience.
• Proficiency with SQL, Tableau, Power BI and MS Office.
• Background in data analysis, trend reporting and financial or operational metrics.

Aufgaben

• Analyze data, forecast trends and reconcile data sets for reporting.
• Develop and maintain dashboards, data pipelines and financial models.
• Prepare monthly agency reports and explain variances to minimize risk.
• Investigate customer issues, refunds and disputes and resolve them timely.
• Produce and automate standard operating procedures for daily functions.

Kenntnisse

Data analysis

Analytical thinking

Problem solving

Communication

SQL

Tableau

Power BI

Microsoft Office

Ausbildung

Bachelor's degree in Business, Accounting, Finance, Statistics or Data Analysis

Tools

SQL

Tableau

Power BI

Microsoft Office

Jobbeschreibung

Pay Range

$58,832.00 - $97,073.00

Country

United States of America

Address

1401 PACIFIC AVE

City

DALLAS, TX 75202

FLSA

Exempt

Professionals

02 - Professional (EEO-4-United States of America), 2D - Professionals - Business (EEO-SubCategory)

General Summary

Responsible for analyzing, forecasting and reconciling and reporting. Monitors agency PCI compliance activities.

Essential Duties and Responsibilities

Responsible for reconciling DARTs systems.

Researches, identifies, explains and reports reconciliation variances to minimize fraud risk.

Prepares monthly reporting for the agency. This includes data scrubbing, analyzing and maintaining trends.

Researches and explains significant variances to thresholds.

Prepares reports for and makes recommendations to management based upon results of analyses/evaluations.

Provides technical assistance and training to staff.

Reviews customer comments report monthly.

Investigates and resolves customer concerns.

Issues customer refunds.

Performs data analysis of current fare program and regularly monitors performance.

Build and automate reporting dashboards, data pipelines, and financial models.

Performs complex analysis and provides recommendations for business research and operations related to fare collection systems.

Requirements include 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.

Analyzes potential areas of automation to determine user and technical needs and recommends possible solutions, including process redesign and individual programs.

Develops methods for improving/optimizing user interfaces and maintenance protocols.

Analyze, evaluate, and produce reports (both custom and system provided) relating to agency ridership, fare related revenue and ticket sales.

Create and maintain departmental Standard Operating Procedures (SOP's) for daily, weekly and monthly functions.

Ensure accurate fraud detection methods are in place and updated with industry standards.

Provides support to senior staff in complex projects as directed.

Performs other related duties as assigned.

Minimum Knowledge, Skills, and Abilities Required

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 use various back-office systems, reporting tools and investigative methods to resolve customer issues, refunds and disputes are responded to in a timely manner.

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.

Working Conditions

Works in an environment where there is minimum exposure to dust, noise, or temperature. May be moderately exposed to unpleasant working conditions to include dust, noise, temperature, weather, petroleum products, and chemicals while visiting DART's operating facilities, assuming incumbent is observing all policies and procedures, safety precautions and regulations, and using all protective clothing and devices provided.

Note: The above statements are intended to describe the general nature and level of work be