Data Analyst- Office of Economic and Workforce Development (1822)

Career Opportunity

Data Analyst- Office of Economic and Workforce Development (1822)

Recruitment: REF9722Z

Published: April 11, 2022

No recruiter found for this role, please contact the Department of Human Resources for assistance

Apply using SmartRecruiters, the City and County of San Francisco's application portal.

Department: Economic & Workforce Development
Job class: 1822-Administrative Analyst
Salary range: $102,440.00 - $124,566.00
Role type: Permanent Exempt What does this mean?
Hours: Full-time

About:

Appointment Type: Permanent -Exempt (PEX) Appointment. This position is excluded by the Charter from the competitive civil service examination process and shall serve at the discretion of the appointing officer.

We Value Equal Employment Opportunity!

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.

About the Office of Economic and Workforce Development (OEWD)

The Office of Economic and Workforce Development (OEWD) advances equitable and shared prosperity for San Franciscans by growing sustainable jobs, supporting businesses of all sizes, creating great places to live and work, and helping everyone achieve economic self-sufficiency.

OEWD’s programs are responsible for strengthening San Francisco’s many diverse neighborhoods and commercial corridors, creating a business climate where companies can grow and prosper, and ensuring a continually high quality of life for all San Franciscans. By providing one point of contact for a variety of essential City programs and services, OEWD’s goal is to ensure that San Francisco will always be what it is today: one of the best places on the planet to live, work, and play. OEWD’s portfolio of work includes major programs and projects such as the Dream Keeper Initiative, the City’s economic recovery from the COVID-19 pandemic, job sector training programs, neighborhood access centers, small business grant and loan programs, and housing development and delivery.

OEWD’s Data and Performance Team is housed under the Impact, Policy, and Communications (IPC) Division of the Department. The IPC Divisions is a shared service of the department providing organization wide support to the program and project delivery divisions. Ensuring that our work incorporates community input and data to drive programming and decision making is critical for the organization.

Role description

Under direction of the Data and Performance Manager, the Data Analyst will be a key member of the Data and Performance Team, supporting department-wide efforts to improve the analytical capacity of department staff, non-profit service providers, other City agencies, and the public. With an emphasis on Invest In Neighborhoods and OEWD small business programs, the Data Analyst will work with program staff to analyze and present data to internal and external stakeholders; help evaluate the impact of existing and newly enacted programs; help define and operationalize key program metrics and indicators; and assist with the improvement of existing data collection and reporting systems. The ideal candidate will possess strong analytical skills and an understanding of contemporary tools and methodologies for collecting, managing, and analyzing data of a municipal department. The role calls for an organized and thoughtful team player, that can excel in a matrix management environment to support operational divisions in advancing the mission and goals of OEWD.

This position while supporting the work of the entire organization, will primarily be focused on supporting OEWD’s work focused on small business services. This position will interface with the Invest in Neighborhoods Team, the Office of Small Business Team, and the Business Development Team. The position will work with other members of the Data and Performance Team to support development of data solutions and analysis in OEWD’s current effort to improve service delivery to the entrepreneurs and small businesses of San Francisco.

Key Responsibilities:

Create monthly, quarterly, and annual data reports on OEWD-led economic and workforce development programs and services.
Develop and maintain dashboards for both public reporting and internal management purposes.
Conduct data analysis related to program utilization, outcomes, and operations for the purposes of meeting regulatory or funding requirements, satisfying ad hoc requests, or supporting program evaluation and performance accountability needs.
Support organizational data governance by working cross functionally with program teams to support the development of data policies, procedures, and standards to be used across OEWD’s data systems.
Assist with the creation user guides for OEWD data systems for program staff and non-profit grantees providing direct services to clients.
Support OEWD staff and grantees by conducting trainings on use of data systems.
Compile and report socioeconomic data and labor market data for use by internal and external stakeholders.
Support OEWD’s development of a key performance indicators and program metrics that align with funding source requirements, best practices, and organizational priorities and goals.

How to qualify

Desirable Qualifications:

Experience using data visualization tools, such as PowerBi or Tableau to create compelling and informative data visualizations
Experience using statistical software, such as STATA, SPSS, or R to analyze large and complex datasets
Experience in GIS and mapping concepts and tools or equivalent
Experience in using SQL to query data from relational database management systems
Experience working on multiple analytical projects, including working with clients
Passionate about improving government through data
Experience working with and compiling demographic data and labor market information

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:

1. Possession of a graduate degree (Master's degree or higher) from an accredited college or university; and one (1) year full-time equivalent experience performing professional-level analytical work, as described in Note A; OR

2. Possession of a graduate degree (Master's degree or higher) from an accredited college or university with major coursework as described in Note B; OR

3. Possession of a baccalaureate degree from an accredited college or university, and two (2) years full-time equivalent experience performing professional-level analytical work as described in Note A; OR

4. Possession of a baccalaureate degree from an accredited college or university with major coursework as described in Note B and one (1) year full-time equivalent experience performing professional-level analytical work as described in Note A;

SUBSTITUTION: Applicants may substitute up to 2 years of the required education with additional qualifying experience in budget analysis, financial analysis and reporting, legislative/policy analysis, or contract/grant administration. One year (2000 hours) of additional qualifying experience will be considered equivalent to 30 semester units/45 quarter units.

Notes on Qualifying Experience and Education:

A. Qualifying professional-level analytical experience must be in one or more of the following functional areas: complex budget analysis, development and administration; complex financial/fiscal analysis and reporting; development of complex contracting systems and administration of competitive bid processes and complex contractual agreements; development and evaluation of complex management/administrative policy; complex grant administration and monitoring; complex program evaluation and planning; complex legislative analysis; complex economic analysis; or other functional areas related to the duties of positions in Class 1822, where the primary focus of the job is complex professional-level analysis for evaluation, recommendation, development and implementation of major programs and functions of department/organization. Analytical experience equivalent to the duties of Class 1820 is considered qualifying.

B. Coursework applicable to a baccalaureate or higher degree in specialized subject matter areas such as public or business administration, management, business law, contract law, public policy, urban studies, economics, statistical analysis, finance, accounting or other fields of study closely related to the essential functions of positions in Class 1822.

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

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.

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.

What else should I know?

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

APPLICATION DEADLINE: Friday, April 29, 2022 - 11:59PM

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.

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