Business Systems Analyst II

State of North Carolina•Wake County, NC

32d

About The Position

This position is in the Structures Management Unit (SMU) and supervises a squad of engineering and technician staff responsible for the continued development, updating, and maintaining the bridge management system (BMS) and bridge maintenance work plans. Beta test new versions and contractor modifications- run scripts to ensure that changes do not adversely affect overall software applications, NCDOT specific analytic models and forecasting tools. Develop/implement routine analytic models and refined decision trees that serve as triggers for maintenance, repair, preservation, rehabilitation and replacement activities or treatment cycles. Develop and maintain the BMS User's Manual which includes specific modules to suit varied user needs, such as the State and Division Bridge Program Managers involved in programming and project selection as well as Division Bridge Maintenance Staff involved in maintaining and repairing bridges. Develop and deliver Unit and Division user training needs. Perform data queries and develop reports to facilitate the selection of bridge preservation, rehabilitation, and replacement projects for all parts of the NCDOT Bridge Program. Perform QC/QA of queries and reports to ensure that results identify appropriate bridge candidates and that the allocation of limited funding resources is optimized. Perform QC/QA check of allocations to ensure that accurate data has been used prior to presentation to the Board of Transportation for approval. Develop reports and/or responses to requests for information from upper and executive management, FHWA, Communications Office and media. Create standard data error checks for Structure Inventory & Appraisal Section's use to prevent erroneous data from being used in bridge program development, project selection, fiscal scenario forecasting, or Division maintenance and preservation allocation determinations. Data mining using Oracle SQL preferred. Working with geospatial data and GIS applications. Provide technical assistance and training, evaluate verbal and written information, develop reports and respond to requests for information from internal and external sources. Identify training needs for Unit and other DOT staff. Develop and deliver training materials, classes or presentations. Assign work, evaluate employee's performance, and train and develop engineers and technicians.

Requirements

A thorough knowledge and understanding of business systems, theories, processes, rules, and regulations and how they apply to technology in the applicable area(s)
Knowledge of applicable business information systems, testing methodologies, training, business system analysis, and/or other applicable systems
Ability to identify, clarify, and select appropriate tools, data, and analysis techniques to diagnose problems and develop solutions
General knowledge of requests, issues, and problem areas
Ability to analyze issues and problems and propose solutions which are consistent with the agency's priorities and financial resources
Ability to utilize available resources to correctly determine the issues and develop alternative solutions
Ability to make guided decisions and recommendations on issues affecting a project or client base
Ability to maintain ongoing interaction with internal and external audiences using written and verbal communication skills
Ability to communicate effectively by articulate verbal discussion
Ability to create clear and coherent written materials
Ability to assist and participate in stakeholder sessions
Ability to interact as a team member on a project team or ability to manage a project task or small-scope project
Ability to apply considerable knowledge of supervisory practices and skill in supervising others
Perform administrative and management duties including evaluating performance, training and coaching
Coordinate and communicate with office and field engineers, other DOT units, FHWA and related outside agencies
Ability to communicate effectively both orally and in writing
Ability to listen and respond appropriately to others
Bachelor's degree from appropriately accredited institution in a discipline related to the area of assignment with three years of programmatic experience related to the area of assignment; or an equivalent combination of training and experience

Nice To Haves

Experience developing, maintaining, and disseminating a Bridge Management System.
Experience performing QA/QC checks of data for accuracy and completeness.
Demonstrated ability developing and writing policies and procedures.
Experience using scripting languages and database management programs, (JavaScript, Groovy, Oracle) to create complex SQL scripts to retrieve data and build detailed reports.
Experience in data mining, developing reports and responding to requests for information from internal and external sources.
Experience supervising permanent employees, contractors and/or consultants.

Responsibilities

Supervising engineering and technician staff
Continued development, updating, and maintaining the bridge management system (BMS) and bridge maintenance work plans
Beta test new versions and contractor modifications- run scripts to ensure that changes do not adversely affect overall software applications, NCDOT specific analytic models and forecasting tools
Develop/implement routine analytic models and refined decision trees that serve as triggers for maintenance, repair, preservation, rehabilitation and replacement activities or treatment cycles
Develop and maintain the BMS User's Manual which includes specific modules to suit varied user needs
Develop and deliver Unit and Division user training needs
Perform data queries and develop reports to facilitate the selection of bridge preservation, rehabilitation, and replacement projects for all parts of the NCDOT Bridge Program
Perform QC/QA of queries and reports to ensure that results identify appropriate bridge candidates and that the allocation of limited funding resources is optimized
Perform QC/QA check of allocations to ensure that accurate data has been used prior to presentation to the Board of Transportation for approval
Develop reports and/or responses to requests for information from upper and executive management, FHWA, Communications Office and media
Create standard data error checks for Structure Inventory & Appraisal Section's use to prevent erroneous data from being used in bridge program development, project selection, fiscal scenario forecasting, or Division maintenance and preservation allocation determinations
Data mining using Oracle SQL
Working with geospatial data and GIS applications
Provide technical assistance and training, evaluate verbal and written information, develop reports and respond to requests for information from internal and external sources
Identify training needs for Unit and other DOT staff
Develop and deliver training materials, classes or presentations
Assign work, evaluate employee's performance, and train and develop engineers and technicians