Senior Data Analyst - Office of Economic and Workforce Development (1823)

Career Opportunity

Senior Data Analyst - Office of Economic and Workforce Development (1823)

Recruitment: REF2147Y

Published: April 11, 2022

Contact:

Anabel Simonelli - anabel.simonelli@sfgov.org

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

Department: Economic & Workforce Development
Job class: 1823-Senior Administrative Analyst
Salary range: $121,836.00 - $148,070.00
Role type: Permanent Exempt What does this mean?
Hours: Full-time

About:

***Please note that we are re-opening this recruitment for another 3 weeks. If you have already applied, please do not re-apply***

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 San Francisco Office of Economic and Workforce Development (OEWD) supports the City's ongoing economic vitality through key programs focused on neighborhood commercial corridors, workforce development, joint development projects, industry focused business recruitment and retention, small business assistance, and international business development. OEWD’s goal is to work continually to make San Francisco an even better place to live, work and do business. OEWD is a dynamic Department in the City and County of San Francisco that reports directly to the Mayor.

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. Toward this mission, OEWD connects job seekers in San Francisco with employment opportunities in growing industries such as Technology, Health Care, Hospitality, and Construction. We provide industry aligned job training and access to job search assistance at community-based neighborhood access points throughout the City, to help provide employers with skilled workers.

Role description

Under the direction of the Data and Performance Manager, the Senior Data Analyst will plan, organize, and conduct important, difficult, complex, and sensitive analytical work that has a substantive impact on the operations and business processes for OEWD’s Workforce Development and Economic Development divisions. As the Senior Data Analyst, your role will be to work independently with program staff to define and operationalize key program metrics and indicators; analyze and present data to internal and external stakeholders; evaluate the impact of existing and newly enacted programs; and assist with the improvement of existing data collection and reporting systems by facilitating process improvement efforts.

The ideal candidate will understand contemporary tools available and standard methodology for collecting, managing and analyzing data of a municipal department to enable the department to engage in strategic planning and business analytics; strong analytical skills; project and time management experience within a complex governance system; and the ability to incorporate problem solving, critical thinking and tactical execution into their daily work.

Key Responsibilities:

Conduct complex 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.
Develop and maintain dashboards for both public reporting and internal management purposes.
Support organizational data governance by acting as a data steward, working cross functionally with various program teams and by developing policies and standards to be used across OEWD’s data systems, including WorkforceCentral and WorkforceLink.
Support OEWD with the development of a comprehensive set of key performance indicators and program metrics that align with funding source requirements, best practices, and organizational priorities and goals.

Compile and report socioeconomic data and labor market data for use by internal and external stakeholders.
Project manage data reporting and data system improvement efforts.
Respond to informational requests, including those of a highly sensitive nature.

Performs related duties as required.

How to qualify

Minimum Qualifications

These minimum qualifications are to be used as a guide for establishing the education, training, experience, special skills and/or license which may be required for employment in the class. Although these minimum qualifications are typical of the class, additional minimum qualifications and special conditions may apply to a particular position and will be stated on the job announcement.

1. Possession of a graduate degree (Master's degree or higher) from an accredited college or university and three (3) years of 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 college coursework as described in Note B and two (2) years full-time equivalent experience performing professional level analytical work as described in Note A; OR

3. Possession of a baccalaureate degree from an accredited college or university and four (4) 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 college coursework as described in Note B and three (3) years full-time equivalent 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 1823, 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 1822 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 1823.

Applicants must meet the Minimum Qualification requirements by the final filing date unless otherwise noted.

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.

Desirable Qualifications

Experience using data visualization tools, such as PowerBi or Tableau to create compelling and informative data visualizations
Experience using Salesforce products and services
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 planning and managing multiple analytical projects independently, including working with clients
Project management experience
Passionate about improving government through data

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

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.