21492 - District Business Data Analyst

Description
Plan, manage and coordinate designated activities related to assigned program area(s). Plans, researches and analyzes district business operations relative to business planning, performance measures, customer feedback, performance improvements, and communications of results. Supports programmatic analysis, reporting, and data management functions for assigned area(s) by developing and maintaining databases and data services needed to support the business. Applies business knowledge and technical expertise in developing tools to help make data driven decisions, report on program performance, and build efficiencies into daily work products and processes. Responds to ad-hoc requests for information. Functions as technical liaison to district partners.

How you will contribute:

Business Reporting: Create and update various types of reports to support district leaders in managing assigned program(s) areas. Report on performance and performance metrics; recommend and provide new reports as needed; and ensure reports address stakeholder and district management needs. Respond to ad-hoc requests for data, reports and information. Develop new tools when needed to support reporting requests. Ensure business reporting of program(s) areas is consistent with statewide practices and objectives.

Data Liaison: Serve as point of contact within assigned program area(s) on data and reporting needs. Assist users in interpreting and applying data to improve business performance and results. Develop recommendations for improving existing data, systems, and processes and work with programmatic partners and stakeholders to resolve discrepancies and achieve shared results.

Data Management: Research, compile, organize, and analyze large amounts of data from various systems, sources and platforms. Revise and update existing databases and systems to ensure data is current and accurate for assigned program area(s).

What will make you successful:

Demonstrated skill developing and managing large data sets and integrating data from different sources and across different platforms.

Knowledge of the interrelationships among project data, including phases, schedules, and estimates.

Knowledge of theory and principles of database development, data management, business process improvement, and performance management.

Proficient use of Microsoft Office products with strong emphasis on Excel (to include Pivot Tables) MS Access, OneNote, Word, PowerPoint, Outlook, Power BI, and Tableau.

Proficient use of SQL Server and writing database queries in SQL.

Some knowledge of the Software Development Lifecycle (SDLC).

Minimum Qualifications:

Ability to apply logic and reasoning to identify and analyze problem areas and recommend various solutions consistent with applicable regulations and policies.

Ability to use Microsoft software with a focus on Access and Excel, Power Platform (including Power BI, Power Apps, etc.).

Ability to use SQL Server and write database queries in SQL proficiently.

Knowledge of theory and principles of database development, data management, business process improvement, and performance management.

Skill developing, managing large data sets, integrating data from different sources and across different platforms.

Skill in oral and written communication to build effective relationships.

Skill in working with business and financial information systems.

Additional Considerations:

Knowledge of statistical analysis using SAS-R, mathematical based modeling experience.

Knowledge of statistical methods, data analysis, needs assessments, and principles of business process evaluation.

Proficient use of Microsoft SharePoint.

Click below to learn more about the Competency Model associated with this Position:
Competency Model

Physical Requirements
Physical Requirements

VDOT employees must abide by VDOTs Code of Ethics and the Commonwealths Standards of Conduct.
VDOT Code of Ethics
Standards of Conduct

Qualifications

Physical Requirements
Physical Requirements