Business Intelligence Platform Change Project
The Controller’s Office is working in a multi-year project to migrate the Reports and Analytics solution into a unified Snowflake-based platform. The BI Platform Change will provide departments with secure, streamlined access to PeopleSoft data, improving efficiency, governance, and standardizing data sharing citywide. By replacing outdated processes, this modern framework supports transparency, accountability, collaboration, better service delivery, strategic growth, and public trust.
Job Description:
This Senior Technology Engineer position will be part of the BI Platform Change project and will work with members of the SF Reports & Analytics Team, Functional Teams and other City and County staff to support the project. The analyst will perform both functional (business process and systems analysis) and technical (report, query and dashboard development, data extract, load and transformation, metadata modeling, tuning, and troubleshooting) tasks.
This position will be instrumental in designing, building, and managing the new business intelligence platform using tools such as dbt, sql, and other tools with a Snowflake database source and target.
Essential duties include but are not limited to:
Education: An associate degree in computer science, computer engineering, information systems, 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].
Experience: Three (3) year of experience analyzing, installing, configuring, enhancing, and/or maintaining the components of a system or platform.
Substitution: One year of additional experience as described above may be substituted for the required degree; or Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.
DESIRABLE QUALIFICATIONS:
Technical Knowledge
Collaboration and Communication Skills
Mission alignment
Selection Procedures
The selection process will include evaluation of applications in relation to minimum requirements. Candidates whose qualifications most closely meet the needs of the Department will move forward in the recruitment process.
Additional Information Regarding Employment with the City and County of San Francisco:
Where to Apply
All job applications for the City and County of San Francisco must be submitted through our online portal. Please visit https://careers.sf.gov/ to begin your application process.
Computers are available for the public (9:00 a.m. to 4:00 p.m. Monday through Friday) to file online applications in the lobby of the Dept. of Human Resources at 1 South Van Ness Avenue, 4th Floor and at the City Career Center at City Hall, 1 Dr. Carlton B. Goodlett Place, Room 110.
Ensure your application information is accurate, as changes may not be possible after submission. Your first and last name must match your legal ID for verification, and preferred names can be included in parentheses. Use your personal email address, not a shared or work email, to avoid unfixable issues.
Applicants will receive a confirmation email from [email protected] 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 Nancy Giang at [email protected]. Recruitment ID: RTF0168331-01159491
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.
Job details are sourced from the employer's original posting.
Open job postingAbout the company
The San Francisco City Attorney’s Office is an innovative, nationally-recognized municipal law office working to protect and advance the rights and interests of the City and County of San Francisco and its residents. With nearly 350 talented and dedicated employees, the Office provides exceptional legal services to the City’s Mayor, Board of Supervisors, officials, and departments.