Overview
Skills
Job Details
Business Analyst (Access/Excel Database Modernization)
6 months contract. Location: Concord, NH (Hybrid Role - 3 days/week onsite required)
This contract will serve to help the client in moving towards a new standardized database by helping to organize, with documentation, the data and structure of each existing database.
- IDEAL CANDIDATE - will be a Business Analyst who has experience working in this BA role with Access/Excel database modernization projects.
JOB DESCRIPTION:
The client currently operates with several siloed Access databases and numerous outdated Excel databases. We aim to organize the data and structure of each of these databases, creating documentation along the way, as we prepare to onboard the client to a more unified database system. This role will be crucial in aiding this process. Additionally, the position will support the business analyst with various tasks, contributing to the overall efficiency and success of the project. Ultimately, this position will help us achieve our goal of having a well-structured, documented, and efficient database system.
Accountabilities:
- Evaluates existing database structure including Access and Excel databases.
- Develops, analyzes, and documents stakeholder requirements for a new database based on state and federal rules /statutes and staff input. These requirements include both user experience requirements and functional requirements.
- Works closely and facilitates communications with staff, including IT developers, program environmental scientists, program wastewater engineers, and project team members as needed to develop a clear understanding of the database requirements.
- Creates database documentation including, but not limited to business plans, entity relationship diagrams, process models, and descriptive project plan documents for the new proposed database
- Researches and evaluates database solutions and implementation approaches, including interim solutions that could bridge current needs while awaiting enterprise system integration.
- Coordinates project activities and maintain project documentation to ensure deliverables are completed on schedule.
- Assists the business analyst with various tasks to support the project's success, ensuring a collaborative and efficient workflow.
- Continually seek to improve practices to add quality and value in support of the work and eliminating unnecessary or redundant actions.
Skill Matrix:
Skill | Required / Desired | Amount | of Experience |
Experience in business analysis, including requirements gathering, process modeling, and functional analysis for custom software solutions | Required | 5 | Years |
Experience with database modernization, especially from Access databases. | Highly desired | 2 | Years |
Experience with defining, developing, and writing business requirements for database management systems. | Required | 3 | Years |
Experience with data clean up, standardization, and quality remediation. | Required | 2 | Years |
Experience and familiarity with Microsoft technologies including Access, Visio, MSSQL, Teams, Word, and Excel. | Required | 2 | Years |
Experience with data management systems, especially Oracle and SSRS. | Desired | 2 | Years |
Familiarity working w/public sector environments including knowledge of local, state, & federal govt. processes & environments. | Nice to have | 2 | Years |
Experience working w/environmental info systems, especially those related to wastewater, including regulatory compliance & data management. | Nice to have | 2 | Years |
Familiar with essential project management documents and tools such as the Project Charter, Risk Register, and RASCI Matrix. | Nice to have | 3 | Years |
Bachelors with a major in information systems, computer science, business, or related field or relevant work experience. | Required |
|
|
Exceptional written and verbal communication is required to be considered for this role. | Required |
|
|