1052 - IS Business Analyst
|Specialty||Title 4E Project|
|Date Opened||9/6/2019 08:00:00 AM|
|Filing Deadline||10/18/2019 5:00:00 PM|
|Salary||$43.31 - $54.48/hour; $7,508.00 - $9,442.00/month; $90,090.00 - $113,308.00/year|
|Job Type||Permanent Exempt|
THIS ANNOUNCEMENT HAS BEEN REOPENED, PREVIOUS APPLICANTS DO NOT NEED TO REAPPLY.
Appointment Type: Permanent Exempt appointment not to exceed three (3) years. This position is excluded by the Charter from the competitive Civil Service examination process and shall serve at the discretion of the Appointing Officer.
Under general direction of the Information Technology (IT) Director, the 1052 IS Business Analyst is responsible for working with the project lead, will be managing Title 4E claim projects including: day-to-day production database maintenance, working with finance office for updating any Title 4E claim requirements, writing SQL queries and store procedures to capture the data entry elements, maintaining State requirement and code for Title 4E time study applied to both peace officer and civil service employee, creating all the necessary quarterly reports and electronics notification during the time study month, and creating automated reports to analyze any discrepancy between time study entries and respective payroll records.
Examples of Important and Essential Duties:
· Ability to create the web front end to capture the time study data entry.
· Export data tables from various SQL databases to MS Access for analytical purpose.
· Create various reports and deploy them in SQL reporting server.
· Backup and Restore all the mission critical databases.
· Perform the day-to-day database maintenance.
· Perform systems analysis and support for a large Microsoft SQL Server Database system
· Assist the lead business analyst to maintain and develop an in-house VB.NET web enabled application via SQL2014 database system as the backend.
· Assist the lead business analyst to maintain and develop ASP.Net web enable application with existing data sets.
· Assist the lead business analyst to maintain and develop SQL stored procedure and modules, creating SQL reporting server reports and statistical performance dashboard.
· Performs other related duties and responsibilities as assigned by the department manager.
· Three years of verifiable working experience with a complex Microsoft SQL Server Database system.
· Database Administrator (DBA) experiences - writing scripts for maintenance and updates.
· Experience with VB.net and ASP.net coding.
· Experience with writing stored procedure in Microsoft SQL 2008/2014 environment.
· Experience with creating SQL Server Reporting Services (SSRS) report.
These minimum qualifications establish the education, training, experience, special skills and/or license(s) which are required for employment in the classification. Please note, additional qualifications (i.e., special conditions) may apply to a particular position and will be stated on the exam/job announcement.
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].
One (1) year in the information systems field, including technical support, content management, administration of network applications or system analysis.
License and Certification:
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.
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
- 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, @famsf.org, @ccsf.edu).
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, Joanna Luong, by telephone at 415-753-7523, or by email at Joanna.Luong@sfgov.org.
Only those candidates who most closely meet the needs of the Department will be invited to continue in the selection process. Applicants who meet the minimum qualifications are not guaranteed to advance through all the steps in the selection process.
Verification: Applicants will be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at http://sfdhr.org/index.aspx?page=456. 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.
As a finalist 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 finalist. 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 applying 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 applying 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 selected as a finalist, the hiring department will contact you to schedule a fingerprinting appointment.
Disaster Service Workers
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.