1054-IS Business Analyst-Principal

Established in 1866, the San Francisco Fire Department is rich in tradition and history. From the Great Earthquake and Fire of 1906 to the Loma Prieta Earthquake of 1989, the Department has grown to meet the many challenges along the way. Today, the San Francisco Fire Department serves an estimated 1.5 million people, providing fire suppression, fire prevention and emergency medical services to the residents, visitors and workers within San Francisco's 49 square miles.

The Mission of the Fire Department is to protect the lives and property of the people of San Francisco from fires, natural disasters, and hazardous material incidents; to save lives by providing emergency medical services; to prevent fires through prevention and education programs; and to provide a work environment that values health, wellness, and cultural diversity and is free of harassment and discrimination.

Application Opening: November 22, 2024

Application Filing Deadline:  December 11, 2024

Compensation Range: $144,846.00 - $206,180.00 annually

Recruitment ID: PEX-1054-153093

Appointment Type: Permanent Exempt, full-time position up to three years. This position is excluded by the Charter from the competitive Civil Service examination process, is considered "at will" and shall serve at the discretion of the Department Head. 

Under general direction, the Principal IS Business Analyst will be responsible for the creation of a comprehensive suite of Power BI dashboards delivering real-time insights into fire department operations, specifically focusing on emergency response, community paramedicine, and fire safety inspections.

The position will work closely with the development group and provide support researching, analyzing, and documenting business requirements for system changes and enhancements.

The Principal IS Business Analyst will also plan the migration of multiple legacy reports (currently integrated into multiple Oracle applications) into a more modern platform.

Essential Duties and Responsibilities:

1. Development of SFFD Dashboards: Design and implement the dashboard series in collaboration with key stakeholders to ensure relevance and usability.
2. SharePoint Integration: Embed the dashboards within the SFFD SharePoint site, ensuring automated data source updates for real-time accuracy.
3. Data Integration Tools: Build and deploy necessary data integration tools using Python and SQL scripts to support data extraction, transformation, and loading (ETL).
4. Comprehensive Documentation: Provide all required documentation, including technical specifications, user guides, and data workflows.
5. Data Source Definition: Integrate both real-time and historical data from key sources, including the fire department’s incident reporting system, GIS mapping data, and inspection databases.
6. Data Processing and Transformation: Implement ETL processes within Power BI or through external tools to cleanse, transform, and ensure data consistency across the dashboards.
7. Security and Access Control: Establish role-based access to protect sensitive data, while enabling a public-facing view for high-level metrics and trends.
8. Automation and Refresh Scheduling: Configure automatic refreshes and notifications to keep dashboard data current and relevant.
9. Respond to report requests and data requests.
10. Write and modify SQL queries as needed to meet business needs.

Education: 

An associate degree in business administration, public administration, information systems, economics, finance, 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 one of the fields above or a closely-related field].

Experience: 

Five (5) years of experience 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 one of the fields above or a closely related field.

Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.

Desirable Qualifications

• Experience with Geographic Information System (GIS): Google Earth Pro, Google Maps or ArcGIS
• Experience with Business Intelligence (BI) Reporting
• Experience developing reports using SAP Crystal Reports

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 https://sfdhr.org/how-verify-education-requirements

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.

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.

Selection Procedure:

The selection process may include an oral interview and an evaluation of candidates’ training and experience.  In the event that a large number of qualified applications are received, only those candidates who most closely meet the needs of the Department will be invited to participate.  Applicants who meet the minimum requirements are not guaranteed advancement in the selection process.

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 Workers
• Reasonable Accommodation
• Right to Work
• Copies of Application Documents
• Diversity Statement
• Veterans Preference
• Seniority Credit in Promotional Exams

HOW TO APPLY:

Applications for City and County of San Francisco jobs are only accepted through an online process.

Interested individuals must submit an online employment application and a resume to:  https://careers.sf.gov by clicking on the 1054 Job Ad link and clicking on “Apply Now” once taken to the 1054 Job Ad. Follow all screen prompts thereafter to complete your submission.

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

Exam Analyst Information: If you have any questions regarding this recruitment or application process, please contact the exam analyst, Jesusa Bushong, [email protected].

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.