Oracle Business Intelligence Reporting Analyst (Hybrid Workplace) - Controller's Office (1053)

Company Description

Hybrid Workplace:
Our workplace has a hybrid/flexible weekly schedule, where colleagues work 1 day onsite (in the San Francisco office) and 4 days from home, subject to periodic review and approval.

Controller’s Office
The Controller is the City’s chief financial officer.  Our team includes financial, technology, analytical, and other professionals who work hard to secure the City’s financial integrity and promote efficient, effective, and accountable government.  We hold ourselves to high standards and strive to be a model for good government.  We value the diverse backgrounds, perspectives and lived experiences of our teams and clients in everything we do.  We work in a collaborative and inclusive environment, promote equal opportunity, and invest in the professional development and well-being of our team members.  You can expect to work alongside colleagues who are committed to serving the public with integrity and want to see positive impacts from their work.  We are looking for smart, motivated individuals who want to make a difference and use government to play a role in solving our City’s issues, including addressing long-standing and harmful disparities in our communities.  For a career with purpose and professional growth, join us in the Controller’s Office!  

Systems Division of the Controller’s Office:
The Systems Division of the Controller’s Office manages the City and County of San Francisco’s Enterprise Oracle and PeopleSoft Applications, which include Oracle Interaction Hub, PeopleSoft Human Capital Management (HCM), PeopleSoft Financials and Supply Chain Management (FSCM), PeopleSoft Enterprise Learning Management (ELM), and Oracle Business Intelligence.  These applications are branded locally as our SF Employee Portal, SF People & Pay, SF Financials, SF Procurement, SF Learning, and SF Reports and Analytics systems.  Collectively, these applications provide a robust, integrated platform that delivers mission-critical services to 55 City Departments, eliminating the need for hundreds of independent legacy systems and customized applications.  The division serves over 35,000 active City employees, 75,000 retirees and 25,000 City vendors (bidders and suppliers).  Peripheral and legacy applications also leveraged by the division include Oracle Identify & Access Management, Sherpa Budget Formulation & Management, Phire Architect, Control-M, and FreshWorks.  The technology implemented and maintained by the Systems Division provides standardization, transparency, and efficiency for the City’s crucial business processes. Users are fully supported to ensure adoption of these interconnected functionalities.

Specific information regarding this recruitment process are listed below:  

• Application Opening:  10/29/2024
• Application Deadline:  Continuous 
• Compensation:  $125,086 - $157,378

Job Description

The Reporting Analyst position will be part of the Business Intelligence and Reporting Team and will work with members of the project’s Functional and Change Management Teams and other City and County staff to Develop and Maintain Oracle Business Intelligence (OBIEE) system. The reporting analyst will perform both functional (business process and systems analysis, testing, user support) and technical (data extract, load and transformation, metadata modeling, Dashboard Development, Query tuning, and troubleshooting) tasks. Working knowledge with Oracle Business Intelligence tool sets like Oracle ODI/ OBIA / OBIEE is strongly desired.

Essential duties include but are not limited to: analyzing the interrelationships of business processes, complex financial data and systems to develop reporting requirements and data structures; performing fit/gap analysis; defining and implementing application configuration settings; working with the project team on transition plans for re-engineered business processes; analyzing and testing security roles and permissions; writing technical specifications; designing and building solutions to specifications; developing and executing system and user acceptance test plans and evaluating test results; developing and providing support and training for users in person, on the phone and in workshops; writing business and system process and technical documentation; identifying, managing and escalating issues and risks throughout software development life cycle; performing other duties as assigned.

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