Business Analysis I – Business System Analyst

Under this Scope Of Work (SOW):

1. The Consultant must have a strong organizational, documentation, and communications skills to accomplish data discovery and documentation of data and integrations within business systems. The selected candidate will have strong written and verbal communication skills, attention to detail, demonstrated project management, business analyst ability, and the ability to participate in a team environment to manage complex business intelligence projects.
2. The Consultant will collaborate with clients and internal city departments to validate business requirements, identity data and workflows to achieve project tasks by their due date. The selected candidate will work directly with the City’s BIDI Manager for all project coordination with the City’s subject matter experts and become familiar with the current City’s business processes, business environment, BIDI technical environment and the City’s standards for BIDI information dashboard development.
3. The “Opioid and Substance Surveillance and Monitoring Dashboard” project strives to collect all relevant data across city departments and external sources related to substance use and overdose. Creating a surveillance and monitoring system is a key public health intervention which will integrate information resulting in improved awareness of the scope of substance use and overdose in the community, provide an opportunity for analysis and interpretation of the whole picture and inform planning and evaluation of interventions to address substance use and related harms.

The business requirements are found in See Appendix A

2. Project Background

The city has been working with the newly formed Public Health department for almost one year on Opioid related projects. This is the largest most complex project, requiring data integration from multiple business systems.

The city is seeking assistance to complete tasks for each information provider using the following approach.

• Data Discovery
• API/Data Integration with internal and external organizations
• Data Profiling
• Data Cleansing
• Dashboard Iterations
• Testing (UAT)
• Production Implementation