1053 IS Business Analyst- Senior - HSA

Recruitment #TEX-1053-103300

Introduction

This announcement has been amended and extended to reflect changes with the application deadline date.  Applicants who already applied under Recruitment PBT-1053-103300 during the filing period February 20, 2020 through March 5, 2020 need not reapply and will be included in the applicant pool.

 

3/9/20: Extended application deadline to March 23, 2020


APPOINTMENT TYPE 

This Temporary Exempt (TEX) Category 17 position is excluded by the Charter from the competitive Civil Service examination process and shall serve at the discretion of the Appointing Officer. Duration of this appointment shall not exceed 24 months (in 6 month increments). 

WHO WE ARE 
 
The Human Services Agency (HSA) is a department of the City and County of San Francisco and the central resource for public assistance in the City. Our mission is to promote well-being and self-sufficiency among individuals, families and communities in San Francisco. HSA was formed in 2004 with the merger of two previously existing city departments, the Department of Human Services and the Department of Aging and Adult Services. The agency retains two commissions and two department heads. The agency also includes the Office of Early Care and Education. Our mission is to promote well-being and self-sufficiency among individuals, families and communities in San Francisco.   

WHAT WE DO     

We provide a safety net for individuals and families by offering income support, community-based living supports, and assistance getting food, housing, and health coverage. We offer programs and services that ensure the protection and safety of children, the elderly, and dependent adults. We help people secure employment through training, job search, and child care assistance.   

ABOUT THE BUSINESS INTELLIGENCE AND DATA WAREHOUSING TEAM

The Business Intelligence (BI) and Data Warehouse (DW) are units in the HSA Department of Information Technology established to consolidate data from different data sources, validate, and build out the central data warehouse. This data warehouse is central to the agency’s data strategy to empower our users to develop operational and strategic reporting capabilities. The objective of integrating different databases and developing the capabilities to slice and dice data will help our Agency derive at better insights in order to improve our operations, increase our customer service, and drive customer satisfaction. The scope of the project is to provide the ability of performing data analysis and business intelligence across the Agency using the Oracle, Microsoft Business Intelligence (BI), and Extract/Transform/Load (ETL) products.

POSITION DESCRIPTION

Under general direction, the Senior IS Business Analyst oversees the more difficult and complex aspects of the systems development lifecycle, including project planning and management, as well as business process redesign and implementation of Data projects. Specifically, the incumbent will be responsible for data integration projects that have an agency-wide impact. The incumbent will be responsible for data extractions and data loading across a variety of data sources. The individual will also be responsible for coordinating ETL implementations, managing ETL jobs/packages, acceptance testing, and production support.

ESSENTIAL DUTIES AND RESPONSIBILITIES

1) Uses the Development Life Cycle methods to analyze the feasibility of and develop requirements for new data and Extract/Transform/Load (ETL) systems.
2) Conducts requirement workshops to interface with business users to determine data needs and requirements and ensures the design fits the needs of the users.
3) Develops data warehouse design using dimensional modeling in consultation with ETL/Data warehouse architects.
4) Completes the ETL design in consultation with the ETL architects and finalizes the development in Microsoft SQL Server Integration Services (MS SSIS). 
5) Builds complex ETL packages and solutions to facilitate the data needs of the agency using MS SSIS.
6) Performs unit testing and regression testing of ETL packages developed in MS SSIS. 
7) Collaborates with the Business Intelligence (BI) Engineer to inform the BI metadata design and maintains the enterprise metadata model.
8) Prepares user and technical manuals. Train users on data processes and BI applications.
9) Provides production support by reviewing support tickets, assessing production problems, prioritizing needs and resolving problems.
10) Performs basic database administration to assure functionality and effectiveness in performing to desired specifications.
11) Analyzes the impact on current business processes and help redesign processes if needed.
12) Identifies opportunities for ETL/process improvements; participates in special projects as necessary. 

Minimum Qualifications

1) EDUCATION:

An associate degree in computer science or a closely related field from an accredited college or university OR its equivalent in terms of total course credits/units [i.e., at least sixty (60) semester or ninety (90) quarter credits/units with a minimum of twenty (20) semester or thirty (30) quarter credits/units in computer science or a closely-related field]

AND

2) EXPERIENCE:

Three (3) years in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management.

SUBSTITUTION:

Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units / forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.

**Applicants must meet the Minimum Qualification requirements at the time of filing**

VERIFICATION OF EXPERIENCE AND/OR EDUCATION:

Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. Refer to the following links for verification:

Verification Guidelines: http://www.sfdhr.org/index.aspx?page=20#verification

Education Verification, including verifying foreign credits or degree equivalency:

https://sfdhr.org/sites/default/files/documents/Job-Seekers/How-to-Verify-Education-Requirements.pdf

Note: Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco.


How To Apply

Applications for City and County of San Francisco jobs are only accepted through an online process. Visit www.jobaps.com/sf to register an account (if you have not already done so) and begin the application process
• Select the desired job announcement (TEX-1053-103300)
• Select “Apply” and read and acknowledge the information
• Select either “I am a New User” if you have not previously registered, or “I have Registered Previously”
• Follow instructions on the screen

Computers are available for the public (from 8:00 a.m. to 5:00 p.m. Monday through Friday) to file online applications in the lobby of the Dept. of Human Resources at 1 South Van Ness Avenue, 4th Floor, San Francisco.

Applicants may be contacted by email about this announcement and, therefore, it is their responsibility to ensure that their registered email address is accurate and kept up-to-date. Also, applicants must ensure that email from CCSF is not blocked on their computer by a spam filter. To prevent blocking, applicants should set up their email to accept CCSF mail from the following addresses (@sfgov.org, @sfdpw.org, @sfport.com, @flysfo.com, @sfwater.org, @sfdph.org, @asianart.org, @sfmta.com, @sfpl.org, @dcyf.org, @first5sf.org).

Applicants will receive a confirmation email that their online application has been received in response to every announcement for which they file. Applicants should retain this confirmation email for their records. Failure to receive this email means that the online application was not submitted or received.

All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline. Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications.

Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.
If you have any questions regarding this recruitment or application process, please contact the exam analyst, Tamara Ranney, by telephone at 415.557.5453, or by email at tamara.ranney@sfgov.org

Selection Procedures

The selection process will include evaluation of applications in relation to minimum qualifications of the position. Depending on the number of applicants, the Department may establish and implement additional screening mechanisms to comparatively evaluate the qualifications of candidates. If this becomes necessary, only those applicants whose qualifications most closely meet the needs of the Department will be invited for an interview. Note: Applicants who meet the minimum qualifications are not guaranteed to advance through all of the steps in the selection process. The department may administer additional selection procedures to make final hiring decisions.   

Conviction History

As a selected candidate for a job, you will be fingerprinted, and your fingerprints will be sent to the California Department of Justice (DOJ) and the Federal Bureau of Investigation (FBI). The resulting report of your conviction history (if any) will be used to determine whether the nature of your conviction (or arrest, in limited circumstances) conflicts with the specific duties and responsibilities of the job for which you are a selected candidate. If a conflict exists, you will be asked to present any evidence of rehabilitation that may mitigate the conflict, except when federal or state regulations bar employment in specific circumstances, such as:

Candidates for positions with the Unified School District and the Community College District may be disqualified from consideration should their conviction history not meet the standards established under the California Education Code.

Candidates for positions with the Recreation and Park Department may be disqualified from consideration should their conviction history not meet the standards established under California Public Resources Code 5164.

Having a conviction history does not automatically preclude you from a job with the City.

If you are a selected candidate, the hiring department will contact you to schedule a fingerprinting appointment.


Disaster Service Workers

All City and County of San Francisco employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employment with the City requires the affirmation of a loyalty oath to this effect. Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.

Conclusion

GENERAL INFORMATION CONCERNING CITY AND COUNTY OF SAN FRANCISCO EMPLOYMENT POLICIES AND PROCEDURES: 

Important Employment Information for the City and County of San Francisco can be obtained at http://sfdhr.org/information-about-hiring-process or hard copy at 1 South Van Ness Avenue, 4th Floor. 

COPIES OF APPLICATION DOCUMENTS: 

Important Employment Information for the City and County of San Francisco can be obtained at http://sfdhr.org/information-about-hiring-process or hard copy at 1 South Van Ness Avenue, 4th Floor.
 
CLERICAL ERRORS: 

May be corrected by the posting of the correction on the Department of Human Resources website at: http://www.sfdhr.org/index.aspx?page=20#announcementsdefinitions

REASONABLE ACCOMMODATION REQUEST: 

Information on requesting reasonable accommodation for persons with disabilities can be found at: http://www.sfdhr.org/index.aspx?page=20#reasonableaccommodation

DRIVER’S LICENSE REQUIREMENT: 

Most positions require a valid California’s driver’s license: http://www.sfdhr.org/index.aspx?page=20#license

RIGHT TO WORK: 

All persons entering the City and County of San Francisco workforce are required to provide verification of authorization to work in the United States. http://www.sfdhr.org/index.aspx?page=20#identification

Exam Type: Temporary Exempt - TEX
Issued: February 20, 2020
Micki Callahan, Human Resources Director 
Department of Human Resources 
Recruitment ID Number: TEX-1053-103300 
HSA/ TR / 415-557-5453

Benefits

All employees hired on or after January 10, 2009 will be required (pursuant to San Francisco Charter Section A8.432) to contribute 2% of pre-tax compensation to fund retiree healthcare. In addition, most employees are required to make a member contribution towards retirement, ranging from 7.5%-13.25% of compensation. For more information on these provisions, please contact the personnel office of the hiring agency.

For more information about benefits, please click here.

 



Powered by JobAps