Career Opportunity

Senior Technical Business Analyst (1053) - Department of Human Resources

Recruitment: RTF0140868-01103325

Published: March 18, 2024

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

About:

• Application Opening: Monday, October 16, 2023
• Application Deadline: Tuesday, October 31, 2023
• Application Extended Deadline: Friday, March 29, 2024
• Annual salary range: $120,536 - $151,658
• Work schedule: Hybrid, Onsite and Remote
• Appointment Type: Permanent Exempt (PEX): This position is excluded by the Charter from the competitive Civil Service examination process and shall serve at the discretion of the Appointing Officer. The duration of the appointment shall not exceed 36 months. 
• List ID: RTF0140868-01103325

Role description

The Department of Human Resources Information Technology team is seeking a talented Technical Senior Business Analyst who would play a pivotal role in our organization’s strategic initiatives by leveraging your advanced analytical skills and business acumen. Your main role, but not limited to, involves the management and supervision of the current SQL server environment, SharePoint sites and collaborate with cross-functional teams to elicit, analyze, and document business requirements, translating them into effective solutions that drive innovation and operational excellence.

Position Responsibilities:

• Analyze existing business processes to identify areas for improvement, efficiency enhancements, and opportunities for automation.
• Provide daily operational support, troubleshoot, and resolve production application, integration, and systemwide problems,
• Collaborate with stakeholders to gather and document business requirements, ensuring a clear understanding of the project’s goals and objectives.
• Coordinate with city vendors, contractors, and other city departments on current and future projects.
• Provide guidance and mentorship to junior business analysts or IT staff, sharing best practices and helping them develop their skills.
• Proficient in SQL language programming and query optimization.
• Proficient in using Microsoft Power BI.
  • Be able to develop interactive reports and dashboards using PowerBI’s visualizations and tools.
  • Ensure that visualizations are clear, concise, and aligned with the goals of the analysis.
  • Implement appropriate data security measures to ensure that sensitive information is protected within Power BI.
  • Integrate Power BI with other tools and services, such as Excel, SQL Server, etc… to enhance data analysis capabilities.
• Proficient in Microsoft SharePoint.
  • Can assist end-users with basic troubleshooting, answering questions, and providing guidance on using SharePoint effectively.
  • Can create and configure SharePoint sites and subsites to facilitate collaboration and content sharing among teams and other city departments.
  • Can design and implement workflows to automate business processes.
• Provide related duties and responsibilities, as assigned.

How to qualify

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.

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.

SUPPLEMENTAL INFORMATION

Essential duties require the following physical skills and work requirements: Some positions may require sufficient strength and coordination for lifting, pushing, pulling and/or carrying the weight of computer equipment. May require hand/eye coordination for semi-skilled movements, such as taking apart casings, installing parts and reconnecting computers and for performing data entry. May involve extensive VDT exposure.

Verification of Education and Experience:
Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. More information can be found at: https://sfdhr.org/information-about-hiring-process#verification

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.

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:

• 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.sf.gov/ 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.

If you have any questions regarding this recruitment or application process, please contact the Analyst, Gary Chen at gary.w.chen@sfgov.org

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.