Business Data Analyst at Virginia Department of Transportation

Wayne State University; Charlottesville (VA); On-site; USD 65,000 - 85,000; Full time

Job summary

A leading educational institution is seeking a dedicated individual for a data management role in Charlottesville, Virginia. The position involves planning, managing, and coordinating various activities related to data systems, performance measures, and reporting. The ideal candidate will have strong proficiency in SQL Server, Microsoft Office suite, and possess excellent analytical and communication skills. This role is pivotal for ensuring data-driven decision-making and aligning IT processes with business needs.

Qualifications

• Demonstrated skill in developing and managing large data sets.
• Knowledge of database development and performance management.
• Ability to analyze problem areas and recommend solutions.

Responsibilities

• Create and update reports to support management.
• Research and analyze large amounts of data.
• Work with IT to align technology with business needs.

Skills

Data integration from different sources

Database development principles

Proficient use of Microsoft Office products

SQL Server proficiency

Oral and written communication skills

Tools

SQL Server

Microsoft Excel

Power BI

Microsoft SharePoint

Job description

Contact Email: [e-mail]

Job Description

Plan, manage and coordinate designated activities related to assigned program area(s). Research and analyze the statewide business relative to planning, performance measures, customer feedback, performance improvements, and communicate results. Support programmatic analysis, reporting, and data management functions by developing and maintaining databases and data services needed to support the business. Apply 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. Respond to ad‑hoc requests for information. Perform all functions in compliance with state regulations and policies. Function as technical liaison to the Information Technology Division (ITD) and external partners and demonstrate high proficiency in computer software applications with some programming capabilities. Develop recommendations and maintain documentation for improvements to existing data, systems and system configuration, and processes in support of business activities and provide technical assistance for developed applications to all end users.

How you will contribute

• Business Reporting: Create and update various types of reports to support management for assigned program and report on performance and performance metrics. Recommend and provide new reports as needed and ensure reports address stakeholder and management needs.
• Data Management: Research, compile, organize, and analyze large amounts of data from various systems and sources; revise and update existing databases to include adding new data fields and developing recommendations and maintaining documentation for improvements to existing data, systems, and processes.
• IT Liaison: Seek out and adopt technology to assist business group(s). Work with IT professionals in creating, testing and aligning technology to meet business processes.

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.
• 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.
• Demonstrated skill developing, managing large data sets, integrating data from different sources and across different platforms.
• Knowledge of theory and principles of database development, data management, business process improvement, and performance management.
• Proficient use of Microsoft software.
• Proficient use of SQL Server and writing database queries in SQL.
• 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, Teams, Excel, Power BI, etc.