Position: Power BI Analyst / Business Intelligence Analyst
Duration: 6 months with extension possible
Location: Ocoee, FL (onsite from day 1)
Interview details: In the event an interview is requested, in-person interviews will be conducted at the Turnpike Headquarters in Ocoee. At the discretion of the manager, first-round interviews may be conducted remotely via Microsoft Teams.
General Characteristics
The Decision Support Specialist is responsible for developing, refining and maintaining Power BI reports and dashboards to support toll system monitoring and decision-making. This role involves analyzing toll systems to ensure peak efficiency, performing detailed data analysis, and supporting operational troubleshooting. This specialist collaborates with internal teams and vendors and works to replace outdated reports, improve reporting processes, and provide actionable insights.
Key Responsibilities
- Design, develop, and enhance Power BI dashboards and reports for toll operations and performance monitoring.
- Collaborate with database experts, the Toll Systems Monitoring Manager and the Toll Business Analyst Manager to connect to data sources and ensure data integrity.
- Perform daily/weekly monitoring and analysis of lane performance reports and dashboards.
- Conduct hyper-care monitoring of new and upgraded lanes.
- Perform basic lane/plaza fault isolation, advanced fault isolation and third-level support for roadside servers, databases, and software.
- Analyze anomalies reported by Operations, Finance, and Maintenance; conduct root cause analysis, develop impact assessments, and prepare executive-level summaries for management.
- Support setup of new lane system installations and/or upgrades.
- Develop Standard Operating Procedures (SOPs) for SunWatch when monitoring is transferred.
- Coordinate with internal vendors to ensure high-priority issues are addressed promptly and escalate critical incidents as needed.
- Identify gaps in existing processes and contribute to developing solutions for improved efficiency and accuracy.
Education
Bachelor's Degree in Computer Science, Information Systems, Data Analytics, or related field; or equivalent work experience.
Experience
- Minimum 3 years of experience in business intelligence and reporting tools, with strong proficiency in Power BI.
- Experience in data modeling, dashboard design, and performance optimization.
- Familiarity with tolling or transportation systems preferred.
- Power BI expertise (report development, DAX, Power Query, data modeling).
- Knowledge of toll lane theory of operation and basic troubleshooting.
- Familiarity with Linux command usage and server support.
- Basic SQL query writing skills.
- Proficiency in Excel (including macros, Visual Basic, Pivot Tables), MS Word, and PowerPoint.
- Experience with network and system management tools (e.g., CA Unicenter, Orion).
- Strong analytical skills for trend identification and root cause analysis.
Complexity
- Intermediate professional role focused on report development, data visualization, and operational analysis.
- Works on multiple projects of moderate complexity, providing insights that drive operational and strategic decisions.
- May coach junior staff on BI tools and best practices.
Never miss an opportunity! Create an alert based on the job you applied for.
