Let’s get started
By clicking ‘Next’, I agree to the Terms of Service
and Privacy Policy
Jobs / Job page
1054-IS Business Analyst-Principal image - Rise Careers
Job details

1054-IS Business Analyst-Principal

Company Description

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. 

Job Description

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.

Qualifications

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

Additional information regarding Employment with the City and County of San Francisco: 

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.

Average salary estimate

$175513 / YEARLY (est.)
min
max
$144846K
$206180K

If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.

What You Should Know About 1054-IS Business Analyst-Principal, City and County of San Francisco

Join the San Francisco Fire Department as a Principal IS Business Analyst, where you'll play a vital role in shaping how we use data to enhance emergency services for our community. It’s a unique opportunity to channel your analytical skills and creativity to develop an array of Power BI dashboards that provide real-time insights into operations. You'll get to work closely with talented developers and key stakeholders, ensuring that the dashboards are relevant and user-friendly. Your daily tasks will include integrating data from various sources to ensure our data is accurate and up to date, all while keeping a focus on fire safety inspections and emergency response. You'll also migrate legacy reports to a modern platform, allowing for more streamlined processes in light of our ongoing commitment to public safety and innovation. We're looking for someone with a strong foundation in information systems, particularly those experienced with SQL and Python. A collaborative spirit and a passion for public service will help you thrive in this role. Your work will directly impact the safety and well-being of the 1.5 million residents and visitors within San Francisco. If you are eager to make a difference using data analytics in a time-honored department that values diversity and wellness, this is the perfect position for you. We can't wait to meet you and hear how your skills can contribute to our mission!

Frequently Asked Questions (FAQs) for 1054-IS Business Analyst-Principal Role at City and County of San Francisco
What are the qualifications for the Principal IS Business Analyst position at the San Francisco Fire Department?

To become a Principal IS Business Analyst at the San Francisco Fire Department, candidates need to hold an associate degree in public administration, business administration, or a closely related field, along with five years of experience in the information systems field. Substitutions may apply, allowing additional experience to replace educational requirements on a year-for-year basis.

Join Rise to see the full answer
What is the primary responsibility of the Principal IS Business Analyst at the San Francisco Fire Department?

The primary responsibility of the Principal IS Business Analyst is to create a comprehensive suite of Power BI dashboards that deliver real-time insights into the department's operations, specifically focusing on emergency response and community safety. This involves working closely with development teams to analyze business requirements and plan data migrations.

Join Rise to see the full answer
How does the San Francisco Fire Department integrate SharePoint with the Principal IS Business Analyst role?

In the Principal IS Business Analyst role at the San Francisco Fire Department, integration with SharePoint is essential. The dashboards developed will be embedded within the SFFD SharePoint site to ensure automated updates and real-time accuracy of the data presented.

Join Rise to see the full answer
Is previous experience with Business Intelligence important for the Principal IS Business Analyst role?

Yes, previous experience with Business Intelligence (BI) reporting is highly beneficial for the Principal IS Business Analyst at the San Francisco Fire Department. Familiarity with tools like Power BI helps streamline the process of developing impactful dashboards that support data-driven decision-making.

Join Rise to see the full answer
What skills are required for handling data in the Principal IS Business Analyst position at the San Francisco Fire Department?

Candidates for the Principal IS Business Analyst position should be skilled in data integration tools, with proficiency in SQL and Python for data extraction and transformation. Additionally, knowledge of ETL processes and data visualization techniques is vital to successfully delivering actionable insights.

Join Rise to see the full answer
What does the compensation package look like for the Principal IS Business Analyst at the San Francisco Fire Department?

The compensation range for the Principal IS Business Analyst position at the San Francisco Fire Department is between $144,846.00 and $206,180.00 annually, reflecting the significant responsibilities and impact of this role on departmental operations.

Join Rise to see the full answer
How does the San Francisco Fire Department promote diversity in the Principal IS Business Analyst hiring process?

The San Francisco Fire Department is committed to promoting diversity and inclusivity within its workforce. Applicants for the Principal IS Business Analyst position will be considered without regard to gender, race, age, or other protected categories, fostering an environment that values diverse perspectives.

Join Rise to see the full answer
Common Interview Questions for 1054-IS Business Analyst-Principal
How do you approach developing dashboards for operational data?

In answering this question, focus on your process of gathering requirements from stakeholders, understanding their needs and concerns, and utilizing tools like Power BI to visualize the data effectively. Highlight the importance of iterative feedback and improvements.

Join Rise to see the full answer
Describe your experience with Python and SQL in handling data.

When answering, emphasize specific projects where you used Python for data manipulation and SQL for querying databases. Discuss how these skills helped you improve data quality or streamline reporting processes.

Join Rise to see the full answer
What strategies do you employ for data quality assurance?

Discuss the importance of validating data sources, implementing automated checks, and performing regular audits. Address how you set up processes to ensure consistent and reliable data across your dashboards.

Join Rise to see the full answer
Can you describe a time you had to adapt quickly to new software or technology?

Share a specific example where you had to learn a new tool rapidly. Discuss how you approached the learning curve, any resources you utilized, and how quickly you were able to implement what you learned in your workflows.

Join Rise to see the full answer
How do you handle conflicting stakeholder requirements?

In your response, explain your approach to communication and negotiations, showcasing how you work to find common ground while addressing the needs of all parties. Highlight the value of transparency and collaboration in these discussions.

Join Rise to see the full answer
Explain your experience with embedding dashboards into SharePoint.

Outline any previous projects where you successfully integrated dashboards into SharePoint sites. Discuss the technical aspects involved as well as how this integration improved accessibility and data sharing among stakeholders.

Join Rise to see the full answer
What is your experience with GIS tools in data analysis?

Discuss your familiarity with GIS platforms such as Google Earth or ArcGIS. Provide examples of how you've used GIS data to inform decisions or improve operational efficiencies in previous roles.

Join Rise to see the full answer
Describe your experience in documenting technical specifications.

Provide details on how you ensure comprehensive documentation throughout your projects. Discuss the types of documentation you create, such as technical specifications and user manuals, and their importance in facilitating project success.

Join Rise to see the full answer
How do you prioritize your tasks in high-pressure environments?

Share your methods for task prioritization, such as using project management tools or creating timelines. Describe how you assess urgency versus importance and any processes you follow to manage deadlines effectively.

Join Rise to see the full answer
What motivates you to work in public service, particularly with the San Francisco Fire Department?

Express your passion for making a tangible difference in the community. Connect your personal values with the mission of the San Francisco Fire Department, highlighting how this aligns with your professional aspirations.

Join Rise to see the full answer
Similar Jobs
Photo of the Rise User
City and County of San Francisco Hybrid 375 Laguna Honda Blvd, San Francisco, CA 94116, USA
Posted 11 days ago
Photo of the Rise User
Publicis Groupe Hybrid 375 Hudson St, New York, NY 10014, USA
Posted yesterday
Photo of the Rise User
Trendyol Remote Istanbul / Maslak
Posted yesterday
Photo of the Rise User
Posted 9 days ago
Photo of the Rise User
Posted 10 days ago
Photo of the Rise User
Capgemini Remote No location specified
Posted 11 days ago
Photo of the Rise User
Posted 2 days ago
Photo of the Rise User
Posted 8 days ago
Dental Insurance
Vision Insurance
Performance Bonus
Paid Holidays

The mission of The San Francisco Department of Human Resources is to recruit, engage, and develop the City's workforce to meet the expectations and service needs of San Franciscans. DHR administers the City's civil service system, ensures payment ...

208 jobs
MATCH
VIEW MATCH
FUNDING
SENIORITY LEVEL REQUIREMENT
TEAM SIZE
No info
EMPLOYMENT TYPE
Full-time, on-site
DATE POSTED
November 24, 2024

Subscribe to Rise newsletter

Risa star 🔮 Hi, I'm Risa! Your AI
Career Copilot
Want to see a list of jobs tailored to
you, just ask me below!