Business Systems Analyst
San Francisco, CA

Job Description

Business Systems Analyst

Location: San Francisco, CA

Duration: Contract to hire or Fulltime

Description:

* Client has an opening in our San Francisco, CA Office location for Business Systems Analyst. The Business Systems Analyst works with 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 our data and applications, and ad-hoc reporting. The position 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 mid- to large-sized projects.

Relies minimally on instructions, pre-established guidelines, and mostly on experience and judgment to perform the functions of the job and accomplish goals. Performs a variety of tasks autonomously and with proficiency. Works under general supervision. Some degree of creativity and latitude is required.

Responsibilities:

* Research and diagnose reported issues with data and applications, using query and reporting tools as needed
* Analyze, synthesize, and document business requirements as specifications for software engineers and DBAs
* Effectively gather business requirements for systems solutions by interviewing internal clients in business departments, reviewing business documents, contracts, regulations, and reports and surveying problem reports and enhancement requests
* Hands-on analysis of existing systems functions and data
* Develop and demonstrate advanced knowledge in multiple systems and/or designated domains; effectively share information with others
* Work 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
* Define and develop ad hoc 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
* Assist in training and support for business clients using our applications

Qualifications:

* Education: Bachelor's degree (B. A.) from four-year college or university;
* Role Experience: 6+ years prior experience as an IT Business Systems Analyst, or in a Data/Process role in non-IT department (e.g., underwriting, claims, finance, etc.) for an insurance company
* Work Experience: 6+ years of relevant business systems analyst experience; extensive knowledge and experience with SDLC and associated deliverables; advanced skills in SQL including knowledge in database testing in 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; experience liaising with development, project management, and business partners
* Language Ability: Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public
* Math Ability: Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rate, ratio, and percent and to draw and interpret bar graphs
* Reasoning Ability: Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables
* Computer Skills: To perform this job successfully, an individual should have knowledge of Microsoft word processing software; Microsoft spreadsheet software; Microsoft presentation software and be proficient on applicable databases, systems and vendor software programs; fluency in Windows environment and MS Office tools.

Desired Skills:

* 6+ years prior experience as an IT Business Systems Analyst, or in a Data/Process role in non-IT department (e.g., underwriting, claims, finance, etc.) for an insurance company
* Experience with configuring FRD's, BRD's and UAT testing
* Analyzes, synthesizes, and documents business requirements as specifications for software engineers and DBAs
* Advanced skills in SQL including knowledge in database testing in Microsoft SQL Server environments including designing and manipulating test data, validating stored processes, jobs, triggers and replication
* Hands-on analysis of existing systems functions and data