IT Business Systems Analyst II

WHAT WE'RE LOOKING FORThe Business Systems Analyst II works with Technical Product Owners, Software Engineers, Database Administrators (DBA), and Quality Assurance (QA) teams, as well as with business clients across the company for gathering and documenting business specifications for systems development and enhancements, investigating and resolving issues with data, applications, and ad-hoc reporting. This individual is responsible for working with software engineers and internal clients to ensure that system solutions meet business needs for standard to complex production support and small- to mid-sized projects.

• Researches and diagnoses reported issues with data and applications, using query and reporting tools such as SQL Server Management Studio, Visual Studio and Power Bi
• Analyzes, determines root cause, synthesizes, and documents business requirements as specifications for software engineers and DBAs and effectively gathers business requirements for systems solutions by: Interviewing internal clients in business departments; Reviewing business documents, contracts, regulations, and reports; Surveying problem reports and enhancement requests; Hands-on analysis of existing systems functions and data
• Develops and demonstrates advanced knowledge in multiple systems and/or designated domains; effectively share information with others
• Works with clients and IT QA staff to develop and execute user acceptance test plans; work with software engineers and DBAs to diagnose, correct, and retest problems
• Defines and develops adhoc reports using system data sources and query/reporting tools such as, MS-SQL, both for delivery to clients and for use in analysis and testing
• Assists in training and support for business clients using our applications

WHAT WILL SET YOU APART

• Education: B.A. / B.S. in Computer Science or Information Technology strongly preferred. A Combination of other certifications/experience may be considered in lieu of degree
• Experience: 5+ years’ experience as an IT Business Systems Analyst. Extensive knowledge and experience with SDLC and associated deliverables. Experience liaising with development, project management, and business partners.
• Technical Skills: Advanced skills in SQL and in database testing Microsoft SQL Server environments including designing and manipulating test data, validating stored processes, jobs, triggers and replication. Extensive knowledge and skills in requirements drafting, and wire-framing. Proven ability to create clear, concise, detailed oriented requirements, specifications, business requirements documents. Proven ability to understand and create test plans from specifications or verbal communications.
• Reasoning Ability: Able to solve practical problems and deal with a variety of concrete variables in situations where some limited standardization exists. Able to interpret instructions furnished in written, oral, diagram, or schedule form. Relies on extensive experience and judgment to plan and accomplish goals.