What are the responsibilities and job description for the IT BUSINESS SYSTEMS ANALYST | COLUMBUS, OH (ONSITE) position at Columbus Technology Solutions?
Job Details
JOB TITLE: IT BUSINESS SYSTEMS ANALYST
JOB DURATION: 6-8 MONTHS
JOB LOCATION: COLUMBUS, OH (ONSITE)
EXPERIENCE: 8 YEARS
VISA: , GC-EAD, OPT, (W2/1099) CAN APPLY.
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. The resource will have a background check conducted by ODPS.
1. Highly skilled in the use of Excel for data manipulation using, but not limited to, the following Excel features:
a. Import of data through Power Queries
b. The development and use of pivot tables
c. Data manipulation through features such as TRIM, Dynamic Arrays and XLookup
d. Use of power pivots
e. Removal of duplicates by using the Excel Remove Duplicates feature
f. 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. Have excellent oral and written skills/possess strong meeting and work session facilitation skills.
6. Have the ability to work independently and as part of a team, the ability to manage time and resources to meet assigned deadlines.
7. 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.
8. Have a strong and demonstrable understanding of Agile/Scrum methodology practices and experience in facilitating scrum ceremonies
9. Have a strong understanding of prioritization stemming from the elicitation of system and/or user requirements.
10. Have excellent organizational skills, proven analytical, planning, problem-solving, and decision-making skills.
11. Must be knowledgeable in the English language/speak clearly and understandably use the English language.
Required Skills:
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 tools.
3. Four (4) years experience as a Business Systems Analyst within the past eight (8) years.
4. Four (4) years of experience eliciting and defining system and user requirements through observation, interviews, and analysis.
5. Four (4) years of experience working directly with end-users to define requirements and provide technical advice and assistance in a large-scale environment.
6. Four (4) years of experience translating customer needs into formal business requirements.
7. Three (3) years of 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 of experience using Visio to create business process flows including standard flowcharts and swim lane diagrams.
10. Three (3) years of experience creating test conditions, test cases, and test scenarios.
11. Four (4) years of 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