Toll Systems Analyst at Ferrovial in Dallas, TX

Toll Systems Analyst Location: Dallas Who is NTE, NTE 35W, and LBJ? The North Tarrant Express (NTE) was the first design-build-finance-operate-maintain managed lanes project in Texas and consisted of the complete reconstruction of 13.3 miles of the existing I-820/SH-183 corridor between Dallas and Fort Worth. Since opening in October 2014, nine months ahead of the contracted completion date, the general highway lanes are experiencing a 70% decrease in congestion time and a 15% increase in average speed. This Cintra-led project has doubled capacity and significantly improved mobility along this heavily congested corridor that traverses the heart of six cities through Northeast Tarrant County. The North Tarrant Express 35W (NTE 35W) project spans 16.8 miles from I-30 in downtown Fort Worth to Eagle Parkway at the north end of Alliance Airport. The project is operated and maintained by the Cintra-led consortium in North Texas. This project has improved mobility by adding additional road capacity through a combination of general highway lanes and continuous frontage roads, along with tolled express lanes that use variable pricing to keep traffic moving. The LBJ Express (LBJ) is currently the largest P3 operation in Texas and one of the largest ever undertaken in the U.S. It is a regionally-significant transportation improvement project in North Texas that is relieving severe congestion in the dense urban area of north Dallas. In 2009, the Cintra-led consortium was selected to complete the design, construction, finance, operation, and maintenance of the project along I-635 and I-35E. Since opening in September 2015, the general highway lanes are realizing a 60% decrease in congestion time and a 10% increase in average speed. What makes us different? Our people come first. We want every single employee to develop both professionally and personally. With a strong focus on growth potential, we look to our internal employees as potential candidates for both national and international opportunities. We aim to achieve greatness by promoting from within every chance we get. We work hard and play hard and strive every day for success and achievement. With a diverse group of professionals working in a fast-paced environment, we achieve milestones constantly. And if that weren’t enough, we also offer our employees highly competitive insurance benefits, Paid Time Off, and a matching 401(k) program. Job Description: The Toll Operations Analyst is responsible for monitoring and supporting day to day operations of the back-office systems to ensure on-time and accurate billing of toll transactions; accurate toll rate revenue and traffic; ensuring managed lane customers experience is a predictable and reliable experience. The Toll Operations Analyst also actively participates in the implementation and testing of back office systems, tracks results and records and escalates system performance issues, while also supporting the development and publishing of applicable reports within our data warehouse and reporting systems. Essential Duties and Responsibilities: Reconciliation and Analysis: Rating the daily toll rate gaps using Toll System Module Analyze and review daily toll rates processed by tolling system, identify discrepancies, possible issues and escalate as needed Analyze transactions generated from the roadside, to ensure timely and accurate data transmission and data validation of transactions and escalate as needed Analyze and trend all uncollectable transactions from back office system and provide recommended solution to reduce the revenue impact Analyze and trend revenue adjusted transactions from Toll Service Provider and provide recommended solution to reduce the revenue impact Analyzing trends, identifying insights, and presenting recommendations to executives Developing visual reports, dashboards and KPI scorecards using Power BI visualization tool and Azure Databricks SQL analysis. Monitor daily alarms notifications and escalate as needed Validate daily and monthly reports Perform reconciliation of the invoices and payments processed Prepare monthly and quarterly operational reports for upper management Operational Activities: Provide support during internal and external audits Create and review operational process and procedure documents, ensuring accuracy and updating as necessary Responsible to work with the Central Systems to develop back office system enhancements and report system operational constraints, deficiencies and defects. Manage Concession and Non-Concession Exempt users and generate monthly reports Actively participate in the review of test cases to ensure compliance to all operational, technical and performance requirements, identify operational shortcomings, identify CDA non-compliance items and ensure usability Actively participate in system integration and user acceptance testing Develop and maintain supporting user documentation and training materials. Create ad-hoc queries, design reports, and publish reports leveraging Microsoft Power BI and other applications within the Microsoft suite of products. Ensuring that production is running smoothly Monitoring and identifying all issues that come up Performs other job-related duties as assigned Qualifications (Knowledge, Skills & Abilities): To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required to fulfill those duties. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Education & Experience: Bachelor’s degree in IT, computer science, business or a related field preferred 1+ years’ experience in the field of toll operations, banking, medical or another transaction processing environment. Experience in extracting, sampling, and visualization of large data sets. Professional Qualities: Excellent Communication skills Excellent analytical skills Effectively manage tasks, deadlines and individuals through vendor contracts Ability to interact with colleagues in a self-managed team structure Must be able to multitask, problem solve, and implement innovative processes within a fast paced environment Experienced in training, supporting and motivating operational staff Computer Skills: Knowledge of IT network communications and systems Must be able to demonstrate computer proficiency, especially as to Microsoft Excel, Word, Power BI, Power Point and basic PC processing. Working Knowledge of Azure Data Bricks Work Environment & Physical Demands: The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The noise level in the work environment is usually quiet Minimal travel required, may include occasional air travel The employee must occasionally lift and/or move up to 25 pounds Specific vision abilities required by this job include ability to adjust focus, as necessary to use a computer While performing the duties of this job, the employee is regularly required to talk or hear. The employee is frequently required to stand, walk and sit