1051 IS Business Analyst-Assistant
Data Reporting Analytics
|Department||San Francisco Public Works|
|Date Opened||12/6/2018 1:00:00 PM|
|Filing Deadline||2/8/2019 5:00:00 PM|
|Salary||$35.95 - $45.21/hour; $6,231.00 - $7,837.00/month; $74,776.00 - $94,042.00/year|
|Job Type||Permanent Exempt|
APPOINTMENT TYPE: Permanent - Exempt. The General Services Agency Department of Public Works has an opening for an exempt appointment in San Francisco. The position is excluded by the Charter from competitive civil service examination process. The successful candidate shall serve at the discretion of the appointing officer. This position has an anticipated duration of no more than three (3) years.
SF Public Works is planning on a major redesign of the existing Reporting and Analytics data platform, with plans for a rebuild of the Service Order, Capital Projects and Financial subject areas to allow a cohesive and unified data infrastructure to enable the business to have more visibility into their processes. The position will be responsible for requirements gathering as well as designing and building creating new reports and dashboards against the redesigned data structures.
Under general supervision, assists in the performance of various aspects of the systems development cycle; and may include needs analysis, structured systems analysis and design, feasibility analysis, technology and software assessment, project planning and management, system installation, implementation and testing, conversion to production status, technical and procedural documentation, user training, and post-implementation assessment and administration, and performing other related duties as assigned.
1. Design, develop and generate routine and ad hoc reports in response to user needs.
2. Familiarity with SQL with the ability to create and/or modify SQL queries
3. Assist in the analysis of user needs and requirements.
4. Assist in conducting systems analysis for moderately complex systems; document new and modified systems and programs.
5. Identify opportunities for improving business processes through automation; assist in the preparation of proposals to develop new systems.
6. Assist in the design of new and/or revised systems and programs, and in the coordination of integration into existing systems and procedures.
7. Provide technical support to users; conduct feasibility studies.
8. Familiarity with the Agile Development methodology using agile management tools such as Team Foundation Server.
9. Coordinate with users and outside vendors, when necessary, to respond to service requests; implement solutions to problems.
10. Participate in user meetings or meetings of related committees.
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].
License and Certification:
Experience in the information systems field, including technical support, content management, administration of network applications or system analysis 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.
Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.
• Experience with business intelligence tools such as Tableau, Power BI
• Experience with relational databases such as Microsoft SQL Server
• Experience in writing SQL queries
• Experience with Team Foundation Server
• Experience with SSMS
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 PEX-1051-092164
- 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, Maria Chan, by telephone at (415) 554-6002, or by email at firstname.lastname@example.org.
Verification (proof) of Education:
Applicants may be required to provide a copy of diploma or official transcript to verify qualifying education at any time in the application, examination and/or departmental selection process to show that the minimum qualifications have been met. For more information, please visit: http://sfdhr.org/index.aspx?page=456
Applicants who have obtained education form a foreign college or university must provide a Foreign Transcript Evaluation letter from a National Association of Credential Evaluation Service (NACES) approved agency. A list of approved agencies can be found at: http://www.naces.org
Verification (proof) of Experience:
Applicants may be required to provide written verification (proof) of qualifying work experience at any time in the application, examination and/or departmental selection process to show that the minimum qualifications have been met. Verification of qualifying experience must be signed by the employer’s authorized representative on the employer's business letterhead, and specify the name of the applicant, dates of employment, job title(s), dates of service and duties performed. City and County of San Francisco employees do not need to submit verification of their City employment, but must submit verification of outside experience. City employment will be verified by the employee’s record. City and County of San Francisco employees will not receive credit for experience obtained outside of their classification unless recorded in accordance with the provisions of the Civil Service Rule 110.9.1. For more information, please visit: http://www.sfdhr.org/index.aspx?page=20#verification
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 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 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.