Decision Support Administrator

Description

• We are looking for a highly skilled Decision Support Administrator – Advanced who is also an experienced programmer that thrives at the intersection of data, mobility, and real-world impact.
• In this role, you will design, develop, and maintain business intelligence solutions that transform complex transportation datasets into actionable insights that help improve roadway safety, optimize traffic flow, and support long term infrastructure planning.
• In this role you will identify and interpret data patterns and trends, build data visualization tools such as charts, graphs, develop custom applications and tables for management, ensure the integrity of the data in various ITS systems, and work with stakeholders to establish key performance indicators.

Key Responsibilities

• Build and maintain dashboards, reports, and visualizations for traffic operations, congestion analysis, and safety metrics.
• Develop custom applications, scripts, and automation tools using Python, C#, or other programming languages.
• Develop automated reporting solutions to support daily, weekly, and monthly transportation performance monitoring.
• Assist with developing specific Departmental goals, standards and objectives which directly support the strategic plan and vision of the organization.
• Assist in the development of Quality Management procedures.
• Work closely with cross-functional teams, including traffic engineers, traffic operators, and leadership to understand business requirements and translate them into technical solutions.
• Support data driven decision making for congestion mitigation, safety initiatives, transit planning, and infrastructure investments.
• Create and maintain data pipelines, ETL processes, and data models to support operational and analytical needs.
• Ensure data accuracy, consistency, and reliability across multiple transportation data sources.
• This role requires strong technical skills in data analysis, data visualization, and database management.
• Troubleshoot and optimize BI systems, applications, and reports.

Required Qualifications

• Ability to develop advanced SQL queries, stored procedures, functions and data transformations to support analytics and operational reporting.
• Ability to develop reports and interactive, user-friendly dashboards, utilizing business intelligence tools like Power BI.
• Ability to design and implement data extraction, transformation, and automation workflows using programming languages such as Python and C#.
• Experience working with large datasets, relational databases, and APIs.
• 3–5 years of professional experience in Power BI development, software programming, or data engineering roles, preferably within an IT or government environment.
• Strong analytical, problem solving, and data processing skills required.
• Familiarity with transportation systems such as ATMS, ITS infrastructure, and traffic management platforms.
• Understanding of GIS tools (ArcGIS, QGIS) and spatial data.
• Provide technical guidance on data best practices, visualization standards, and performance metrics.

Soft Skills

• Must have effective verbal and written communication skills.
• Ability to work independently with minimal supervision as well as participating in cross functional teams.
• Ability to deal with ambiguity and adapt quickly to changing client needs.
• Must demonstrate the ability to manage multiple priorities/tasks, deliver timely and accurate work products with a customer service focus, and respond with a sense of urgency as required.
• Proactively identify opportunities to automate, streamline, and improve processes while fostering collaboration and delivering value to customers.

Competencies

• Advanced analytical thinking and complex problem‑solving abilities.
• Strong proficiency in data modeling, ETL design, and data architecture.
• Ability to write clean, efficient, and well‑documented code in Python, C#, or similar languages.
• Expertise in SQL, including performance tuning and optimization.
• Proficiency in BI visualization best practices and dashboard usability design.
• Strong understanding of relational databases, APIs, and integration methods.
• Ability to interpret business needs and translate them into technical specifications.
• Competence in version control systems such as Git, Azure DevOps or TFS.
• Ability to troubleshoot complex data, application, and ETL issues.
• Strong quality assurance mindset, ensuring accuracy and consistency across data products.