Senior Systems Analyst

The Ohio Department of Aging (ODA) seeks an experienced, skilled, and motivated Senior Systems Analyst with systems and business analysis, and quality assurance experience for developing the ODA web applications.Mandatory RequirementsCompletion of undergraduate core program coursework in information technology, engineering, or telecommunications.Minimum TEN years Business Process Analyst/Systems Engineering experience.Minimum FIVE years Software Development Experience.Minimum FIVE years Quality Assurance Analyst experience.Minimum 2 years project/program management or equivalent experience.Required Hands-On Experience:TEN years in contributing to the Software Development Life Cycle (SDLC) from the design phase to the implementation phase of Web Applications; demonstrated in the Sprint Planning and execution with project management principles; experience in building test automation frameworks; translating customer requirements into functional requirements for web applications development.Familiarity with Micro-services architecture and containerization technologies like Docker and Kubernetes is a plus.Experience with continuous integration and deployment (CI/CD) pipelines using Azure DevOps (minimum THREE years).A sound understanding of relational databases and hands-on experience with Standard Query Language (SQL) and producing business reports using SQL reports.Responsibilities:Creates information systems documentation to identify business and functional requirements; coordinates activities for requirements gathering and analyzing information regarding information technology system(s).Performs impact analyses to identify system and process inter-dependencies; collects and analyzes data to provide informed options for decision-making.Develops Request for Proposal (RFP) preparation, vendor solution evaluations & recommendations to meet defined business requirements.Creates Information Technology systems and process flows and flowcharts; decomposes complex processes; develops technical specification documents.Creates architecture diagrams to detail the configuration of servers, databases, and network connections for current and future systems models.Analyzes, models, and interprets data using different tools and techniques.Reviews and assists in software development lifecycle activities including feature and project cost, time, and effort estimations.Creates user stories, develops test strategy and test cases, and does the test execution; can create data migration plans, including the validation of migrated data.Creates or sets up test data for performing test scenarios; executes unit test scripts and assists in executing system test scripts independently; verifies and documents unit and system test results to ensure the software is producing desired results; debugs and revises programs when unit and system tests do not produce desired results.Coordinates execution of feature and system test scripts, participates in debugging efforts and defect tracking, creates and reviews test data for performing testing load testing and regression testing.Develops and maintains a robust automation framework for the creation of automated test scripts and automated test reporting with minimal to no supervision.Designs and executes performance and load tests to assess systems scalability and performance.Maintains test versioning to ensure test data aligns with testing requirements.Identifies data sources; does data analysis and data-mapping; develops and maintains data pipeline; provides data flow diagrams and documents the process.Takes initiative and implements innovative ideas to improve the business and Software development process.Collaborates and communicates effectively with customers, stakeholders, and team members.Works collaboratively with the service delivery team (e.g., project managers and business analysts) to develop project plans and documentation.Desired SkillsExcellent analytical skills, attention to detail, and problem-solving skills.Proven ability to handle multiple tasks and projects simultaneously.Good communication skills with both technical and non-technical clients.Must possess excellent written and oral communication skills.Strong experience in creating good solutions without mature, detailed, codified business requirements.Working experience in delivering expected results in unstructured environments.Works productively and effectively independently without significant management oversight.Skills:Technical Documentation skills; Communication skills with both non-technical and technical clients - Required 10 Years.Translating customer requirements into functional software requirements, and leverage the latest tech trends for organizational efficiency - Required 5 Years.Lead Role as Business Process Analyst/Systems Engineering - analyzing business requirements, developing & maintaining technical requirements - Required 7 Years.A sound understanding of relational databases and hands-on experience with Standard Query Language (SQL) and producing business reports using SQL - Highly desired 3 Years.Quality Assurance - Test Cases Creation, Documentation, execution, Load Test, Performance Testing both manual and automated - Required 5 Years.Power BI, JIRA and any other business analysis tools experience - Highly desired 4 Years.Azure DevOps Experience - Required 3 Years.Certified Business Analysis Professional (CBAP) - Nice to have.Test Automation tools such as Soap UI, Selenium - Highly desired 4 Years.Are willing to report to the office located in downtown Columbus, Ohio twice a week?Are willing to provide two technical references from your previous experience, if requested?

#J-18808-Ljbffr