5640 Environmental Specialist

Recruitment #TEX-5640-109995


Data Coordinator
San Francisco Department of Environment
5640 – Environmental Specialist

Deadline to apply extended - new deadline is April 12, 2021 at 8:00 AM. 

Previous Applicants Do Not Need to Reapply.

Are you a wiz at improving organizational systems and workflows? Do you have experience administering Salesforce and identifying data management solutions that may not be obvious? Are you excited at the prospect of using data as a tool to drive action for a healthier environment? If so, we invite you to take advantage of an opportunity to use your skills to build a better future for San Francisco.

Who We Are
The San Francisco Department of the Environment (SF Environment) provides solutions that advance climate protection and enhance quality of life for all San Franciscans. SF Environment is recognized worldwide for its environmental policies and programs, which center on achieving zero waste, reducing toxic chemical hazards, advancing environmental justice, promoting sustainable transportation modes, expanding clean energy infrastructure, greening our built environment, and protecting our urban forest. We’re a passionate, mission-driven team that values credibility, collaboration, impact, innovation and equity. SF Environment is also a great place to work, offering an attractive benefits package that includes healthcare and retirement.

San Francisco Department of the Environment Racial Equity Statement
For over 20 years, SF Environment has worked with San Francisco’s Black, indigenous, and people of color (BIPOC) communities to mitigate environmental burdens, increase accessibility of environmental programs and benefits, engage community members, and improve health outcomes. BIPOC communities are disproportionately exposed to environmental stressors that include air and soil pollution, illegal dumping of toxics and other materials, industrial land uses and transportation impacts. They are more likely to live in housing conditions with limited access to green space and where poor indoor air quality from pests, mold, and the use of toxic products contributes to the prevalence of asthma and other health disparities. They are more likely to be employed in areas with high levels of exposure to toxics. Now, they are the first communities feeling the impacts of climate change, with the fewest resources to respond. SF Environment has a longstanding commitment to the principles of environmental justice, whereby communities most impacted by environmental stressors and climate change are prioritized and the long-time work of community leaders is recognized and supported. We are committed to uplifting the contributions of local environmental leaders of diverse racial backgrounds and ensuring that racial equity is the cornerstone of all of our programs, policies, and services.

Who You Are
As the Data Coordinator, you will play a central role in building and maintaining a collaborative culture of information-sharing throughout SF Environment. You’re an analytical, solutions-oriented self-starter who will create reliable and scalable data management systems that enable data analysis, reporting, and program evaluation. You’re excited to work with colleagues and external collaborators to understand team workflows, scope needs, and identify and implement appropriate data management solutions. Because Salesforce is integral to current and future data and relationship management processes at the Department, you will draw upon your experience with Salesforce to help develop, build, and maintain Salesforce systems in collaboration with colleagues representing various program areas.

Serving in a coordinator-level position (Class 5640), you’ll work under the supervision of a Class 5642 Senior Environmental Specialist responsible for defining annual goals and project scopes.

What You'll Likely Do
According to Civil Service Commission Rule 109, the duties specified below are representative of the range of duties assigned to this class and are not intended to be an inclusive list.

• Serve as Salesforce (SFDC) administrator responsible for the configuration of process and workflow rules, database objects, form page layouts, and other back-end customizations that assist SF Environment teams in streamlining communication and processes relevant to their needs
• Ensure SFDC data quality by coordinating regular, and often complex, data uploads; support data cleaning as needed
• Develop and maintain a backup of SFDC data
• Manage an IT ticketing system for data support and troubleshooting requests, recommending and/or implementing solutions in SFDC as well as other appropriate software
• Coordinate and lead regular meetings and trainings with SFDC users to address process improvements and related needs
• Develop training materials on SFDC-specific processes and other tools and technologies
• Enable the Department’s higher-level utilization of data, including visualization and reporting, using programs that may include PowerBI, Tableau, Excel, SQL, GIS or PowerPoint
• Manage and support project scoping and planning with internal and external teams
• Maintain a catalog of departmental datasets and coordinate annual data publishing
• Coordinate with Web Coordinator to interface data with web published content, as needed
• Scope and coordinate requests for external technical software support, as needed
• Maintain subject-matter expertise in best practices for optimizing software usage and costs
• Present project updates to senior management and other key stakeholders, as directed
• Support budget and invoice tracking and other administrative needs
• Attend Salesforce Community Meetings with other City departments
Supervision Exercised

Appointment Type
This position is a Temporary Exempt Appointment, with an anticipated duration of 36 months. The position is excluded by the Charter from the competitive civil service examination process and shall serve at the discretion of the appointing officer.

Minimum Qualifications

Possession of a baccalaureate degree from an accredited college or university in a field related to data coordination, management or analysis (including but not limited to computer science, engineering, mathematics, statistics, finance, economics), or public administration, business administration, accounting, biology, environmental sciences, or a related field; AND

Two (2) years of experience planning, coordinating, implementing evaluating, or analyzing environmentally related programs within the specialty area of data coordination.

Desirable Qualifications

SF Environment encourages applicants to apply regardless of if they meet all desirable qualifications below. The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred for hiring.

• Experience working on multiple, ongoing technology and/or data projects, with the ability to lead or support the development of project requirements, craft realistic timelines for deliverables, and ensure timely completion of project phases
• Experience in data management, including data mining, data validation and quality assurance, analysis, visualization, and dashboard creation to determine trends and provide recommendations
• Salesforce Administrator certification and at least two years of experience serving in a Salesforce administrator role
• Experience building applications in Salesforce Lightning framework or another comparable technology
• Ability to communicate effectively in writing and orally to create use cases, test cases, training materials, conduct user training sessions and presentations, and communicate with non-technical colleagues as well as technical/functional experts
• An understanding of and commitment to racial equity, inclusion, and diversity principles
Additional Application 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. Applicants must meet the minimum qualification requirement by the final filing date, unless otherwise noted.

Candidates are requested to submit a 1) resume and 2) transcript or diploma, and attach both to their application. Upload these documents as a PDF or Word file, under the “Other” tab in the application system.

How To Apply

Applications for City and County of San Francisco jobs are only accepted through an online process. Visit https://jobapscloud.com/sf/ to register an account (if you have not already done so) and begin the application process.
    1. Select the desired job announcement
    2. Select “Apply” and read and acknowledge the information
    3. Select either “I am a New User” if you have not previously registered, or “I have Registered Previously”
    4. Follow instructions on the screen
    5. Attach two documents - 1) a resume, and 2) an official or unofficial copy of your transcripts or diploma. Upload the documents as PDF or Word files.
      Applicants may be contacted by email about this announcement 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).

      Applicants will receive a confirmation email that their online application was 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 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. Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.

      Please email Adam Romoslawski, Senior Human Resources Consultant, at Adam.Romoslawski@sfgov.org should you have questions about the application process. For questions regarding the status of your application or the selection process, please refer to the ‘Timeline’ section under the Selection Procedures heading.

      Selection Plan

      Online application filing deadline will conclude at 8am on Monday, April 5th, 2021. Due to the volume of inquiries we receive, we are unable to give application status updates. While we are not able to reach out to every applicant, the hiring manager will contact you directly after the filing deadline if your skills and experiences are a strong match for the position.

      The selection process will include an evaluation of applications and an assessment of candidates' relative job-related knowledge, skills and abilities. This includes knowledge of: basic data management theory, principles, and best practices; data structure and formats most suited to reporting; visualization software (e.g. Power BI, Tableau, SQL, R, RStudio, Python, GIS). This also includes the ability to: survey current data landscape, identify gaps, and recommend solutions; analyze organizational, administrative and procedural problems, then conceptualize and recommend appropriate software, technology, and/or best practices to resolve these problems; collaborate with internal and external stakeholders to map existing business processes into technical requirements; perform data validation and quality assurance; work agilely and iterate with business stakeholders to achieve goal; comfortably and flexibly work with remote staff; work independently with high-level direction as well as collaboratively with cross-functional teams.

      Only those applicants most closely meeting the needs of the Department will be invited to participate in the interview selection process. Applicants meeting the minimum qualifications are not guaranteed advancement to the interview.

      Conviction History

      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 applying 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 applying 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 City & 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.


          1. Your application must 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 to determine whether you meet the minimum qualifications.

          2. Verification: 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. 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.

          3. Requests: Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable ADA Accommodation at:

          4. Applicants are advised to keep copies of all documents submitted. Submitted documents become a permanent part of the exam record and will not be returned. The hiring department may require applicants to present additional material at the time of appointment and/or at a later date.

          5. For general information concerning City and County of San Francisco employment policies and procedures, please refer to this web URL: http://www.sfdhr.org/index.aspx?page=20

          6. For Right to Work policy, please refer to this web URL: http://www.sfdhr.org/index.aspx?page=20#identification

          7. Terms of Announcement: Applicants must be guided solely by the provisions of this announcement, including requirements, time periods and other particulars, except when superseded by federal, state or local laws, rules or regulations. Clerical errors may be corrected by the posting the correction on the Department of Human Resources website at www.jobaps.com/sf. The terms of this announcement may be appealed under Civil Service Rule 111A.35.1. The standard for the review of such appeals is ‘abuse of discretion’ or ‘no rational basis’ for establishing the position description, the minimum qualifications and/or the certification rule. Appeals must include a written statement of the item(s) being contested and the specific reason(s) why the cited item(s) constitute(s) abuse of discretion by the Human Resources Director. Appeals must be submitted directly to the Executive Officer of the Civil Service Commission within five business days of the announcement issuance date.

          ISSUED: March 15, 2021; 4/2/21 - deadline extended to 4/12/21
          ANNOUNCEMENT NO: TEX-5640-109995

          8. In line with the Official Public Health Order to slow the spread of COVID-19, “shelter-in-place” has been issued for all San Francisco residents that is expected to be in effect until further notice. As a result, Department of Human Resources (DHR)’s office (located at 1 South Van Ness Avenue, 4th Floor, San Francisco, CA 94103) is currently closed to the general public. If you have any questions, please feel free to email the Human Resources Analyst listed on this announcement at Adam.Romoslawski@sfgov.org.


          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.

          For more information about benefits, please click here.

          Powered by JobAps