Logo

Business Analyst II (#RB6205)
$39.74-$48.30 Hourly / $6,887.84-$8,372.21 Monthly / $82,654.09-$100,466.57 Yearly




DEFINITION

Under direction, performs analytical duties, including detailed quantitative analyses, to evaluate business programs and operations of various County departments; researches, organizes, and analyzes business information gathered from various automated systems and electronic databases; identifies and recommends business efficiencies and process improvement opportunities; and does related or other work as required in accordance with Rule 3, Section 3 of the Civil Service Rules.

CLASS CHARACTERISTICS

This is the journey-level class in the Business Analyst series. Incumbents in this class work independently to conduct detailed analytics-based data studies in order to inform and support department planning and process improvement efforts. Using various electronic data analysis tools, incumbents identify key performance indicators, design and conduct data queries, perform statistical and quantitative analyses, and utilize explanatory and predictive modeling to provide decision support for departmental programs and activities. Depending on assignment, duties may require an incumbent to be familiar with department-specific business practices, goals, and/or automation resources.

This class is distinguished from Business Analyst I as the latter is the entry-level class where incumbents initially perform the more routine duties under general supervision while learning to perform full scope of work with substantial independence.

TYPICAL DUTIES

  • Leads, conducts, and participates in the collection, identification, and analysis of business cycle information, including key performance indicators; designs complex data tools and system queries; ensures the correct selection, analysis and interpretation of data and the identification of business trends.
  • Conducts detailed analytic and data-based studies of departmental business functionality, including financial, program, and/or operational activities; using explanatory and predictive modeling methods, develops business scenarios, options, priorities and alternatives; prepares cost and revenue projections.
  • Prepares complex analytical reports outlining study findings as well as process improvement solutions and analyses; develops cost allocations and indirect cost rate proposals based on third-party payer and/or other requirements.
  • Designs and develops solution testing plans, strategies and quality management tools; reviews solution defects and makes strategy adjustments as needed.
  • Provides business process subject matter expertise for, and coordination of, information technology projects; defines business process needs and serves as a liaison to information technology staff regarding the development, modification, and/or maintenance of automated systems.
  • Helps monitor and maintain the quality and integrity of data stored in and/or processed through core business applications and databases; maintains data tables and references; downloads/uploads data sets; identifies opportunities for improving databases, data sets, and reports utilized by the department and recommends changes as appropriate.
  • Defines and conducts best practice studies by researching other departments and/or agencies; responds to a variety of information requests from both inside and outside the department.
  • Analyzes and interprets existing, new and proposed legislation for cost and program impacts; develops and prepares impact projections.
  • Prepares and presents a variety of financial, statistical, and narrative documents, including charts, tables, and other visual data tools; prepares and answers correspondence and questionnaires; makes graphic and oral presentations to individuals and groups.
  • Assists in the development of capital and operational budgets by analyzing budget variances, providing explanations as to why they occurred, and providing recommendations as needed.
  • Develops and recommends policy statements for management approval.
  • Confers with representatives of other agencies or departments; coordinates projects; serves as liaison between departments.
  • May supervise clerical or technical employees if assigned as an ancillary, but not preponderant, duty.

MINIMUM QUALIFICATIONS

EITHER PATTERN I
Experience: Two years as a Business Analyst I in San Joaquin County Service.

OR PATTERN II
Education: Graduation from an accredited four-year college or university with a major in business analytics, computer science, mathematics, finance, business, or public administration, or a closely related field.

Experience: Two years conducting professional, quantitative analyses of financial, programmatic, and/or operational business data utilizing business analytics methodologies, as well as developing and presenting process improvement recommendations.

Substitution #1: Current standing as a Certified Business Analysis Professional (CBAP) from the International Institute of Business Analysis may substitute for the above-required education.

Substitution #2: A master’s degree in business analytics, computer science, mathematics, finance, business or public administration, or a closely related field may be substituted for one year of the above-required experience.

AND FOR BOTH PATTERNS
Special Requirement: Depending on assignment, positions may require that some or all of the qualifying experience was obtained while working in an area or program that is directly related to departmental business operations.

KNOWLEDGE

Principles and practices of business analysis including planning and monitoring, elicitation, requirements management and communication, enterprise analysis, requirements analysis, and solution assessment and validation; theories, principles, and methods related to the business intelligence life cycle including the identification of key performance indicators, predictive modeling and data mining; quantitative data analytics techniques and procedures associated with research, collection, compilation, statistical evaluation, and modeling of data; laws and regulations pertaining to area of assignment; computer software tools used for the storage, management, manipulation, analysis and reporting of large quantities of data; typical spreadsheet and relational database programs and analysis tools; basic principles of information technology; principles and methods of communicating information through written and oral reports and presentations.

ABILITY

Identify key business performance data and indicators, based on departmental goals and objectives; build and conduct relational database queries using standard software tools; analyze business data in order to identify trends, resolve problems, and recommend potential areas of process improvement; participate in the development and maintenance of departmental data systems and structures; lead and/or coordinate projects; communicate effectively, both orally and in writing; maintain effective relationships with those contacted during the course of work.

PHYSICAL/MENTAL REQUIREMENTS

Mobility - ability to frequently sit for long periods, move about an office, and reach above and below desk level. Dexterity - sufficient to frequently operate a keyboard, handle individual papers, and write and take notes. Lifting - ability to occasionally lift papers, files, and material weighing up to 25 pounds. Visual - ability to frequently read computer screens and do close-up work. Hearing/Talking - ability to hear normal speech, hear on the telephone, talk in person, and talk on the telephone. Emotional/Psychological Factors - ability to frequently make decisions and concentrate, and to occasionally make public contact and work overtime if needed.

San Joaquin County complies with the Americans with Disabilities Act (ADA) and, upon request, will consider reasonable accommodations to enable individuals with disabilities to perform essential job functions.

CLASS: RB6205; EST: 1/8/2014;