Job Details

Interviews will be required to be in-person at the Shipley building at 1970 West Broad Street. Is your candidate willing and able to interview in person?

Travel Required throughout Ohio, Onsite required while not travelling

The IT BSA1 will join the eWarrants application team and be primarily responsible for the functional data conversion effort for each criminal justice agency. DPS technical personnel will export the data from state-owned systems and provide it to the IT BSA1 to use in comparison to the data owned and maintained by the local law enforcement entities. The IT BSA1 will then work directly with DPS staff and law enforcement or court personnel across the state to research and resolve data issues. Any actual changes that need to be made to the data will be done by authorized personnel only. The cleaned data will then be imported into eWarrants during go live. This is a repeatable process for each individual court and law enforcement entity in an Ohio county.

As a secondary responsibility, the IT BSA1 will become an eWarrants SME and assist existing team members in developing business process flows that support a court or law enforcement entity's unique way of doing business; participate in the rollout of eWarrants including overseeing the entire data conversion effort and data readiness upon go live.

Finally, the position does require about 20% travel throughout the State of Ohio in a DPS owned vehicle. The IT BSA1 must have some flexibility, with advanced notice, to travel by car to various locations. This could entail working beyond a standard eight-hour day (all time including travel time is chargeable; gas in the DPS owned vehicle to be paid for by the State; per diems are not offered).

During the interview process with the ODPS staff, the resource consultant must demonstrate competence/experience in their specific area(s) of project assignment. The resource's experience must also be documented for review and verification. Offered resources not showing technical or functional competence/experience will be sufficient reason to reject the Offeror's proposal. It is the responsibility of the Offeror to pre-screen their candidates to ensure compliance. Resource will have a background check conducted by ODPS.

Required Skills:

1. Highly skilled in the use of Excel for data manipulation using, but not limited to, the following Excel features:
1. Import of data through Power Queries
2. The development and use of pivot tables
3. Data manipulation through features such as TRIM, Dynamic Arrays, and XLookup
4. Use of power pivots
5. Removal of duplicates by using Excel Remove Duplicates feature
6. Use of conditional statements
2. Strong communication/leadership skills.
3. Strong influence, collaboration, and negotiation experience.
4. Ability to collaborate with supporting resources across business and/or functional lines.
5. Excellent oral and written skills/possess strong meeting and work session facilitation skills.
6. Ability to work independently and as part of a team, manage time and resources to meet assigned deadlines.
7. Ability to facilitate a session with non-technical stakeholders and facilitate requirements gathering sessions without the onsite of a project manager or technical expert.
8. Strong and demonstrable understanding of Agile/Scrum methodology practices and experience in facilitating scrum ceremonies.
9. Strong understanding of prioritization stemming from the elicitation of system and/or user requirements.
10. Excellent organizational skills, proven analytical, planning, problem-solving, and decision-making skills.
11. Knowledgeable in the English language/speak clearly and understandably use the English language.

Minimum Requirements:

1. Four (4) years experience as an advanced Excel user within the past eight (8) years.
2. Four (4) years experience in the area of data conversion using Excel or similar tool.
3. Four (4) years experience as a Business Systems Analyst within the past eight (8) years.
4. Four (4) years experience eliciting and defining system and user requirements through observation, interviews, and analysis.
5. Four (4) years experience working directly with end-users to define requirements and provide technical advice and assistance in a large-scale environment.
6. Four (4) years experience translating customer needs into formal business requirements.
7. Three (3) years experience interviewing non-technical end users to determine and document current business process flows.
8. Two (2) years experience in Business Process Re-engineering.
9. Three (3) years experience using Visio to create business process flows including standard flowcharts and swim lane diagrams.
10. Three (3) years experience creating test conditions, test cases, and test scenarios.
11. Four (4) years experience analyzing end-user needs and conducting fit gap analysis.
12. Documented experience as a technical Business Analyst from project initiation through completion on a minimum of two (2) software development or implementation projects requiring a minimum of two thousand (2,000) Full-time Equivalent (FTE) hours to complete.
13. Documented experience using project management software to develop and maintain a Work Breakdown Structure (WBS) on a minimum of two (2) projects.
14. Four (4) years experience using a business requirements tracking tool for recording and prioritization of business requirements.
15. Documented experience in systems process and data mapping, requirements gathering, and analysis as well as proficiency in the creation of detailed documentation.
16. Needs to show at least 1 experience with a large organization as ODPS.
17. Must have a valid driver license issued by any US State; driver license must stay valid throughout length of employment.

Desired Skills:

• Prior experience in working with Criminal Justice and Law Enforcement entities.
• Knowledge of Agile Methodology and/or scrum practices.
• Microsoft Azure DevOps and/or Jira or any other collaboration tool.