Job ID: 755005
SR Business/ Data Analyst
Client: State of Virigina Department of Transportation
Location: Richmond VA
Duration: 12 Months
Master Data Analyst
- The Virginia Department of Transportation (VDOT) Information Technology Division (ITD) is seeking a Master Data Analyst with demonstrated experience in data analytics to work as a key member of Enterprise Data Asset team. This analyst will support teams working in Agile (Sprint) to analyze datasets to be made available in a cloudbased data management platform that will support the agency to produce master data with data governance.
- Responsibilities include analyzing source systems which contain a spatial component for candidate datasets; documenting business processes and data lifecycle; developing data requirements user stories and acceptance criteria; and testing strategies.
- VDOT is a fastpaced organization with very high standards for work quality and efficiency. This position is expected to handle multiple projects and remain flexible and productive despite changing priorities and processes.
- Ongoing improvement and efficiency are a part of our culture and each team member is expected to proactively contribute to process improvements.
Responsibilities:
- Work with the Project team members and business stakeholders to understand business processes and pain points
- Develop expertise in source system datasets and data lifecycle
- Profile source data which may contain a spatial component; review source data and compare content and structure to dataset requirements; identify conflicts and determine recommendations for resolution
- Conduct entity resolution to identify matching and merging and semantic conflicts
- Elicit record and manage metadata
- Diagram current processes and proposed modifications using process flows context diagrams and data flow diagrams
- Discover and document requirements and user stories with a focus on improving both business and technical processing
- Decompose requirements into Epics and Features and create clear and concise user stories that are easy to understand and implement by technical staff
- Utilize progressive elaboration; map stories to data models and architectures to be used by internal staff to facilitate master data management
- Identify and group related user stories into themes document dependencies and associated business processes
- Assist Product Owner in maintaining the product backlog
- Create conceptual prototypes and mockups
- Collaborate with staff vendors consultants and contractors as they are engaged on tasks to formulate detail and test potential and implemented solutions
- Perform Quality Analyst functions such as defining test objectives test plans and test cases and executing test cases
- Coordinate and Facilitate User Acceptance Testing with Business and ensure Project Managers/Scrum Masters are informed of the progress
Qualifications Required:
- The candidate must have a minimum of 10 years of experience delivering business data analysis artifacts
- 5 years of experience as an Agile Business Analyst; strong understanding of Scrum concepts and methodology
- Experience organizing and maintaining Product and Sprint backlogs
- Experience translating client and product strategy requirements into dataset requirements and user stories
- Proficient with defining acceptance criteria and managing acceptance process
- Exceptional experience writing complex sql queries for Sql Server and Oracle
- Experience with Azure Databricks
- Experience with ESRI ArcGIS
- Experience with enterprise data management
- Expertise with Microsoft Office products (Word Excel Access Outlook Visio PowerPoint Project Server)
- Experience with reporting systems operational data stores data warehouses data lakes data marts
- The candidate must have exceptional written and oral communications skills and have the proven ability to work well with a diverse set of peers and customers
Preferred:
- Certified Business Analysis Professional (CBAP) and/or Certified Scrum Product Owner (CSPO) Certification
- Certified Data Management Professional (CDMP)