IS Business Analyst-Assistant - Information Technology - Public Works (1051 PEX) (152540)

*This job announcement has been amended to reflect additional Desirable Qualifications

Specific information regarding this recruitment process is listed below.

Application Opening: Friday, November 8, 2024
Application Deadline: Applicants are encouraged to apply immediately as this recruitment may close at any time, but no earlier than Friday, November 15, 2024.
Salary Range: $93,314 to $117,390 annually
Recruitment ID: PEX-1051-152540 - RTF0152539-01124965

Appointment Type: Permanent-Exempt (PEX), Category 18. This position is excluded by the Charter from the competitive Civil Service examination process and shall serve at the discretion of the Appointing Officer. The duration of the appointment is not to exceed 36 months.

San Francisco Public Works (Public Works) has a far-reaching portfolio with a $453 million annual operating budget, an active capital portfolio that exceeds $3 billion and a workforce of 1,700-plus employees. The department operates around the clock, touching every neighborhood in San Francisco. The staff designs and manages the construction of civic buildings and streets; cleans and greens the right of way; maintains civic buildings; manages multi-million-dollar bond programs; trains people for jobs; keeps the right of way free of hazards; paves the roads; repairs bridges and public stairways; expands accessibility; and works at the forefront addressing some of San Francisco’s biggest challenges. With a mission to enhance the quality of life in San Francisco for residents, visitors and business owners, Public Works is committed to providing outstanding public service through an equity lens.

Please visit the “About Us” section of our website at https://www.sfpublicworks.org/about to learn more about the department’s core values, Racial Equity Initiative, leadership team, history, budget and more.

The Information Technology Division designs, programs, operates and maintains all department-wide automated information systems and equipment. Services include process analysis and planning; software development; configuration and implementation; network and hardware installation; technology operations; help desk and security; and software support and system compliance functions.

Public Works currently has a vacancy for an IS Business Analyst-Assistant within our Information Technology Division.  

Under general supervision, as an IS Business Analyst-Assistant you will assist in the performance of various aspects of the systems development cycle and may include needs analysis, cost-benefit analysis, structured systems analysis and design, feasibility analysis, technology and software assessment, telecommunications needs analysis, project planning and management, system installation, implementation and testing, conversion to production status, technical and procedural documentation, user training, post-implementation assessment and administration.

Important and Essential Duties:

• Assist in system deployments and SQL server agent job execution monitoring.
• Analyze data and design data visualizations to identify opportunities for improving business processes.
• Assist in the design of new or revised systems and programs, and in the coordination of integration into existing systems and procedures.
• Assist in conducting systems analysis for applications, databases and other systems.
• Assist in the analysis of user needs and requirements.
• Document new and modified systems and programs.
• Assist in the preparation of proposals to develop new systems.
• Assist in the testing of new or modified systems.
• Provide technical support to users.
• Assist in conducting feasibility studies.
• Respond to service requests and implement solutions to problems.
• Work on-site at the yard once or twice a week to support operations and collaborate with team members.

Minimum Qualifications

Education:
An associate degree in business administration, public administration, information systems, economics, finance, 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 one of the fields above or a closely-related field).

Substitution:
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 one of the fields above or a closely related field.

Completion of the 1010-Information Systems Trainee program may be substituted for the required degree.

CONDITION OF EMPLOYMENT
Valid Driver’s License: Applicants must possess a valid State of California driver’s license with no restrictions that would prohibit them from legally performing the essential functions and duties of the role. 

Desired Qualifications:

• Experience with SQL and Microsoft SQL Server databases and the ability to create and/or modify SQL queries.
• Experience with data cleansing and data extract, transform, and load (ETL) process.
• Experience with programming languages such as Python, C#, NET, JavaScript and HTML.
• Experience with data visualization tools such as Excel, Power BI and Tableau.
• Ability to reason logically and to communicate effectively with system users to translate application concepts into system applications.
• Ability to translate technical concepts and terminology in terms understandable to system users.
• Ability to establish and maintain effective relationships with user departments, administrative officials, and employees.

Verification:
Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. More information can be found at: https://sfdhr.org/recruitment-details#verification

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.

Resumes will not be accepted in lieu of a completed City and County of San Francisco application. 

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.

Selection Procedures:
After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process, which includes the following:

The selection process will include an evaluation of applications in relation to minimum requirements. 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 move forward in the recruitment process.

Minimum Qualification Supplemental Questionnaire (MQSQ):
Candidates may be required to complete an MQSQ as part of the employment application. This MQSQ is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications (MQ) for this position. The MQSQ will be used to evaluate if the applicant possesses the required minimum qualifications.

Applicants who meet the minimum qualifications are not guaranteed advancement through all of the steps in the selection procedure.

Additional Information Regarding Employment with the City and County of San Francisco:

• Information About the Hiring Process
• Conviction History
• Employee Benefits Overview  
• Equal Employment Opportunity 
• Disaster Service Worker
• ADA Accommodation
• Right to Work
• Copies of Application Documents
• Diversity Statement

Statement on Diversity, Equity, and Inclusion: At the City and County of San Francisco, we share a commitment to a diverse, inclusive and equitable community. Each member of our organization is responsible and accountable for what they say and do to make San Francisco an inclusive and equitable place to live and work by employing fair and just practices to and for all.

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.

If you have any questions regarding this recruitment or application process, please contact the analyst, Humera Rahman-Power, at [email protected]

The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.