"Alerted.org

Interview Type: In Person *** 37.5 hours per week *** Required THREE professional references *** Hybrid *** Locals

Job Description:

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.

Required Skills:

+ Experience in business analysis, including requirements gathering, process modeling, and functional analysis for custom software solutions. 5 Years

+ Experience with defining, developing, and writing business requirements for database management systems. 3 Years

+ Experience with data clean up, standardization, and quality remediation. 2 Years

+ Experience and familiarity with Microsoft technologies including Access, Visio, MSSQL, Teams, Word, and Excel. 2 Years

+ Bachelors with a major in information systems, computer science, business, or related field or relevant work experience.

+ Exceptional written and verbal communication is required to be considered for this role.

Desired Skills:

Experience with data management systems, especially Oracle and SSRS. 2 years

Highly Desired Skills:

+ Experience with database modernization, especially from Access databases. 2 Years

Nice to Have:

+ Familiarity working w/public sector environments including knowledge of local, state, & federal govt. processes & environments. 2 Years

+ Experience working w/environmental info systems, especially those related to wastewater, including regulatory compliance & data management. 2 Years

+ Familiar with essential project management documents and tools such as the Project Charter, Risk Register, and RASCI Matrix. 3 Years