1052 IS Business Analyst
|Department||Municipal Transportation Agency|
|Date Opened||6/1/2018 2:00:00 PM|
|Filing Deadline||6/18/2018 5:00:00 PM|
|Salary||$86,606.00 - $108,914.00/year|
|Job Type||Permanent Exempt|
The following information describes the civil service classification for which applications are being solicited.
Make sure you read the entire announcement before completing the application form.
The purpose of this announcement is to fill a vacant position in this classification.
Division: Finance & Information Technology
Section/Unit: Capital Finance – Capital Procurement and Management
Work Location: 1 South Van Ness, 8th Floor, San Francisco, CA
Appointment Type: Permanent Exempt-Full Time 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 the general direction of the 9174 Manager IV, the 1052 IS Business Analyst will develop reporting platforms and standardize data under the Agency’s capital program. This position will be the project lead within the section responsible for developing analyzing data source systems and business processes, developing sustainable automated methods to extract data from enterprise databases and static spreadsheets into reports, managing and improving on data stewardship and standards within the organization, developing sustainable self-service environments that allow business users to explore their data, and modeling enterprise data to meet the needs of multiple business areas. Key responsibilities will include leading the section’s automated reporting initiative, gaining a deep understanding of the business’ information needs and data constraints, developing analytical tools using data-visualization programs, and working to improve data quality through cleansing and standardization efforts. This position will also hold administrative and management duties for an Agency capital fund to-be-determined.
EXAMPLES OF IMPORTANT AND ESSENTIAL DUTIES:
• Develops scripts to extract data from multiple sources including enterprise databases and static spreadsheets and create standard reporting templates.
• Develops reports from ad hoc requests and long-term scheduled reporting based upon large datasets and complex queries.
• Qualifies and improves data quality for the purpose of accurate and efficient reporting.
• Facilitates data cleansing and enrichment through data standardization.
• Manipulates and analyzes large datasets using excel.
• Develops data-visualization tools to analyze data for management using tools such as Tableau.
• Supports business users in retrieving data that is not readily available to them through already established systems.
• Works with Capital Finance staff, Capital Project and Grants Accounting staff, project managers, and grantors to identify capital rules and requirements.
• Understands current business practices and recommend/implement process improvements.
• Manages a capital fund by preparing monthly/quarterly progress reports, submitting amendment requests and submitting closeout requests
• Performs other duties as assigned.
• Experience implementing process improvements using relational databases and developing and enhancing data pipeline, workflow, and querying.
• Experience with scripting and data analysis languages, such as Python, MATLAB, and R.
• Hands-on experience with SQL, dashboards, and reporting, involving large datasets and multiple data sources.
• Experience collecting, merging, organizing, cleaning, manipulating, and analyzing large datasets.
• Ability to collect and understand business reporting objectives and requirements.
• Ability to qualify and continuously improve data quality for the purpose of accurate and efficient reporting.
• Experience in reporting and monitoring involving both ad hoc requests and longer-term scheduled reporting based upon large datasets and complex queries.
• Knowledge or interest in accounting, budgeting, financial management or in local, regional, state and federal grant government practices.
1. 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. One (1) year in the information systems field, including technical support, content management, administration of network applications or system analysis.
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:
City and County of San Francisco employment applications for this position will be accepted through an on-line process only. A resume and cover letter must be attached to the online application. Mailed, hand delivered or faxed applications will not be accepted. Visit www.jobaps.com/sf to begin the application process.
• Click and select 1052 IS Business Analyst (PEX-1052-086476)
• Click on “Apply” and read and acknowledge the information
• Click on “I am a New User” if you have not previously registered, or on “I have REGISTERED PREVIOUSLY”
• Follow instructions given on the screen.
To submit resume using the online application:
• Select the “Resume” tab in the online application
• Follow instructions given on the screen
To submit cover letter using the online application:
• Select the “Other” tab in the online application
• Choose “Upload” as your method of submittal
• Click on “Upload Attachment”
• Follow instructions given on the screen
If you are having trouble attaching your resume and cover letter to the online application, you may submit by fax to (415) 581-5120, ATTN: 1052 IS Business Analyst (PEX-1052-086476). Résumé will not be accepted in lieu of completing the online application.
Computer kiosks 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 Department of Human Resources, 1 South Van Ness Avenue, 4th Floor, San Francisco and in the lobby of SFMTA Human Resources office, 1 South Van Ness Avenue, 6th Floor, San Francisco.
Applicants may be contacted by e-mail. It is their responsibility to ensure that their registered e-mail 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).
Upon successful submittal of the application online, the applicant will receive a notification on the screen, as well as in the applicant’s e-mail inbox, acknowledging the receipt of the application by the SFMTA – Operations Section. If you are having difficulty submitting your application online, please contact us at (415) 646-2744 between 8:30 a.m. – 12:00 p.m. and 1:00 p.m. - 4:30 p.m. Monday through Friday or by e-mail at Lisamarie.Gibson@sfmta.com.
Applicants may be required to submit verification of qualifying education and experience at any point in the application and/or departmental selection process. Written verification (proof) of qualifying experience must verify that the applicant meets the minimum qualifications stated on the examination announcement. Written verification must be submitted on employer’s official letterhead, specifying dates of employment, types of employment (part-time/full-time), job title(s), description of duties performed, and the verification must be signed by the employer. City employees will receive credit for the duties of the class to which they are appointed. Credit for experience obtained outside of the employee’s class will be allowed only if recorded in accordance with the provisions of the Civil Service Commission Rules. Experience claimed in self-employment must be supported by documents verifying income, earnings, business license and experience comparable to the minimum qualifications of the position. Copies of income tax papers or other documents listing occupations and total earnings must be submitted. 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.
Applications will be screened for relevant qualifying experience. Additional screening mechanisms may be implemented in order to determine candidates’ qualifications. Only those applicants who most closely meet the needs of the Agency will be invited to participate in the selection process. Applicants meeting the minimum qualifications are not guaranteed advancement to the interview.
Qualified applicants with disabilities requiring reasonable accommodation in the selection process must contact the SFMTA by phone at (415) 646-2744 or, if hearing impaired at (415) 701-5043 (TTY) or in writing to the SFMTA Human Resources, HR Operations Section, 1 South Van Ness Avenue, 6th Floor, San Francisco, CA 94103 (specify Class 1052).
Make sure your application and any attachments to the application submitted at the time of filing are complete and accurate and include details on all experience, education, training and other information that qualifies you for this recruitment. Failure to submit a complete and accurate application at the time of filing may result in your ineligibility for this recruitment or inability to receive full credit for scoring purposes. Any new information concerning work experience, education, training and other information that is submitted after the filing deadline may not be used for scoring or considered to determine whether you meet the minimum qualifications.
Women, Minorities, and Persons with Disabilities are encouraged to apply
An Equal Opportunity Employer
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.