21492 - District Business Data Analyst

Virginia Department of Transportation • Bristol, VA

4d

About The Position

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.

Requirements

• 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).
• 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.

Nice To Haves

• 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.

Responsibilities

• 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 This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed