Business Systems Analyst

• Join the eWarrants application team and be primary responsible for the functional data conversion effort for each criminal justice agency
• Work directly with DPS staff and law enforcement or court personnel across the state to research and resolve data issues
• 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
• Travel throughout the State of Ohio in a DPS owned vehicle (about 20% travel)

• Highly skilled in the use of Excel for data manipulation using, but not limited to, the following Excel features: Import of data through Power Queries
• The development and use of pivot tables
• Data manipulation through features such as TRIM, Dynamic Arrays and XLookup
• Use of power pivots
• Removal of duplicates by using Excel Remove Duplicates feature
• Use of conditional statements
• Strong communication/ leadership skills
• Strong influence, collaboration and negotiation experience
• Ability to collaborate with supporting resources across business and/or functional lines
• Have excellent oral and written skills/possess strong meeting and work session facilitation skills
• Have the ability to work independently and as part of a team, the ability to manage time and resources to meet assigned deadlines
• Have the ability to facilitate a session with non-technical stakeholders and facilitate requirements gathering sessions without the onsite of a project manager or technical expert
• Have a strong and demonstrable understanding of Agile/Scrum methodology practices and experience in facilitating scrum ceremonies
• Have a strong understanding of prioritization stemming from the elicitation of system and/or user requirements
• Have excellent organizational skills, proven analytical, planning, problem solving, and decision-making skills
• Must be knowledgeable in the English language/speak clearly and understandably use the English language
• Four (4) years experience as an advanced Excel user within the past eight (8) years
• Four (4) years experience in the area of data conversion using Excel or similar tool
• Four (4) years experience as a Business Systems Analyst within the past eight (8) years
• Four (4) years experience eliciting and defining system and user requirements through observation, interviews, and analysis
• Four (4) years experience working directly with end-users to define requirements and provide technical advice and assistance in a large-scale environment
• Four (4) years experience translating customer needs into formal business requirements
• Three (3) years experience interviewing non-technical end users to determine and document current business process flows
• Two (2) years experience in Business Process Re-engineering
• Three (3) years experience using Visio to create business process flows including standard flowcharts and swim lane diagrams
• Three (3) years experience creating test conditions, test cases, and test scenarios
• Four (4) years experience analyzing end-user needs and conducting fit gap analysis
• 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
• Documented experience using project management software () to develop and maintain a Work Breakdown Structure (WBS) on a minimum of two (2) projects
• Four (4) years experience using a business requirements tracking tool for recording and prioritization of business requirements
• Documented experience in systems process and data mapping, requirements gathering, and analysis as well as proficiency in the creation of detailed documentation
• Needs to show at least 1 experience with a large organization as ODPS
• Must have a valid driver license issued by any US State
• driver license must stay valid throughout length of employment

• 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

Gas in the DPS owned vehicle to be paid for by the State