Job Title : Business Analyst (Travel to sites Onsite)
Location : Columbus OH
Duration : 6 Months
Interview : Webex
- Business Analyst will join the eWarrants application team and be primary responsible for the functional data conversion effort for each criminal justice agency. DPS technical personnel will export the data from stateowned systems and provide to the BA to use in comparison to the data owned and maintained by the local law enforcement entities. The BA 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 BA will become an eWarrants SME and assist existing team members in developing business process flows that support a court or law enforcement entitys 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 BA must have some flexibility with advanced notice to travel by car to various locations. This could entail working beyond a standard eighthour 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
see tab for mandatory skills
During the interview process with the ODPS staff the resource consultant must demonstrate competence / experience in their specific area(s) of project assignment. The resources 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 Offerors proposal. It is the responsibility of the Offeror to prescreen their candidates to ensure compliance. Resource will have a background check conducted by ODPS.
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 tablesData manipulation through features such as TRIM Dynamic Arrays and XLookupUse of power pivotsRemoval of duplicates by using Excel Remove Duplicates featureUse of conditional statementsStrong 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 nontechnical 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 ceremoniesHave 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 decisionmaking skills.Must be knowledgeable in the English language / speak clearly and understandably use the English language.Requirements :
Four (4) years experience as an advanced Excel user within the past eight (8) yearsFour (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) yearsFour (4) years experience eliciting and defining system and user requirements through observation interviews and analysis.Four (4) years experience working directly with endusers to define requirements and provide technical advice and assistance in a largescale environmFour (4) years experience translating customer needs into formal business requirementsThree (3) years experience interviewing nontechnical end users to determine and document current business process flows.Two (2) years experience in Business Process Reengineering.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 scenariosFour (4) years experience analyzing enduser needs and conducting fit gap analysisFour (4) years experience using a business requirements tracking tool for recording and prioritization of business requirements.Documented experience as a technical Business Analyst from project initiation through completion on a minimum of two (2) software development or impleDocumented experience using project management software () to develop and maintain a Work Breakdown Structure (WBS) on a minimum of two (2) projectsMust have a valid driver license issued by any US State; driver license must stay valid throughout length of employmentNeeds to show at least 1 experience with a large organization as ODPSPrior experience in working with Criminal Justice and Law Enforcement entitiesKnowledge of Agile Methodology and / or scrum practicesMicrosoft Azure DevOps and / or Jira or any other collaborationKey Skills
SQL,Agile,Business Analysis,Visio,Waterfall,Business Process Modeling,Requirements Gathering,User Acceptance Testing,Business requirements,SDLC,Systems Analysis,Data Analysis Skills
Employment Type : Full Time
Vacancy : 1
