Job Description

Under the general direction of the Data and Performance Manager, the Product Solutions and Business Analyst will function as the primary management information systems analyst tasked with identifying and documenting business processes and requirements, in order to support the design, development, and implementation of data collection and reporting systems. The Product Solutions and Business Analyst will work closely with business owners by participating in quality improvement projects, improving staff capacity for using data tools, and researching operational gaps raised by analysis_._ __ They will support department-wide efforts to improve data access and analytical capacity for Department staff, the public, decision-makers, and other agencies, including modernization and integration of various key data products, tools and workflows. The role calls for an organized and thoughtful team player, that can excel in a matrix management environment to support Divisions in advancing the mission and goals of OEWD.

Essential responsibilities include:

• Collaborate with program staff to elicit, analyze, communicate, and validate requirements for changes to business processes, policies, and information systems.
• Lead coordination among OEWD staff who are delivering Dream Keeper programs and projects, to create or identify data systems or business applications to track program delivery.
• Work with program staff in data system improvement projects, that identify operational gaps, resource limitations, and system improvements that increase program staff proficiency in use of systems
• Increase communication and collaboration with IS staff of other City departments implementing Dream Keeper programs and projects in order to create efficiencies in data collection systems, tracking outcomes, and measuring impact
• Assist program staff in implementing stakeholder surveys, extracting data points and key metrics, analyzing information, and reporting findings and recommendations.
• Collaborate with Data and Performance team peers and business tools users to maintain, support, and troubleshoot the various application interfaces and connectivity
• Collaborate with program staff, business users, and third-party vendors to efficiently respond to, troubleshoot, and successfully resolve reported problems.
• Prepare user and application support, documentation, and provide training as needed.
• Assist with building dashboards and reports that allow for Dream Keeper Program Staff and OEWD Leadership to evaluate program performance and allow for data driven decision making.
• Act as an advocate for organizational change while working with Manger of Information Systems, IPC Team, Finance and Admin Team and City GSAIT Team to identify opportunities for improvements in efficiency and data security.
• Provide excellent customer service to our program staff and maintain positive collaboration with team peers and everyone associated with OEWD and City.
• BE COMMITTED TO WORKING IN A COLLABORATIVE TEAM ENVIRONMENT

Qualifications

DESIRABLE QUALIFICATIONS:

• Knowledge of San Francisco’s diverse neighborhoods and communities
• Demonstrated ability to work under pressure, remain flexible, positive, proactive, resourceful and efficient, with a high level of professionalism.
• Excellent communications and consensus-building skills with diverse stakeholders
• Strategic thinker with the ability to develop and pursue a coherent theory of change
• Ability to coordinate and manage various working groups and consultants within an organization
• Demonstrated ability to manage multiple staff and projects, while balancing multiple priorities and timelines
• Ability to analyze information, identify problems and opportunities, consider alternative courses of action and propose and communicate appropriate solutions in an effective manner.
• Experience working with a variety of databases, APIs, and formats to extract and transform data
• Experience using Salesforce products and services
• Experience with ETL design, implementation, and maintenance
• Programming proficiency in SQL and Python
• Experience with data visualization tools, such as PowerBi
• Experience with GIS and mapping concepts and tools or equivalent

The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred for hiring.

MINIMUM QUALIFICATIONS:

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].

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.

License and Certification: 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.

NOTES:

APPLICANTS MUST MEET THE MINIMUM QUALIFICATION REQUIREMENTS BY THE FINAL FILING DATE UNLESS OTHERWISE NOTED.

Applications will be screened for relevant qualifying experience and education.  Additional screening mechanisms may be implemented in order to determine candidates’ qualifications. Only those applicants who most closely meet the needs of the Department will be invited to continue on in the selection process.  Applicants meeting the minimum qualifications are not guaranteed advancement in the process.

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. 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. 

Additional Information

ADDITIONAL INFORMATION REGARDING EMPLOYMENT WITH THE CITY AND COUNTY OF SAN FRANCISCO:

APPLICATION DEADLINE: FRIDAY, JUNE 3, 2022 - 11:59PM

• Compensation
• 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

HOW TO APPLY

Applications for City and County of San Francisco jobs are ONLY accepted through an online process. Visit https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ and begin the application process OR Select the “I’m Interested” button and follow instructions on the screen.

Applicants may be contacted by email about this recruitment 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, @smartalerts.info, and @smartrecruiters.com).

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 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.

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.

All your information will be kept confidential according to EEO guidelines.

If you have any questions regarding this recruitment or application process, please contact: Anabel Simonelli-Kupelian, Chief People Officer, anabel.simonelli@sfgov.org.

CONDITION OF EMPLOYMENT:  All City and County of San Francisco employees are required to be fully vaccinated against COVID-19 as a condition of employment. Someone is fully vaccinated when 14 days have passed since they received the final dose of a two-shot vaccine or a dose of a one-shot vaccine. Any new hire must present proof of full vaccination status to be appointed. Any new hire who will be routinely assigned or occasionally enter High-Risk Settings, must provide proof of having received a COVID-19 booster vaccine by March 1, 2022, or once eligible.

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.