Oracle Business Intelligence Reporting Analyst (Hybrid Workplace) - Controller's Office (1053)
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 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) years in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management.
License and Certification:
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:
The stated desirable qualifications will be used to identify job finalists at the end of the selection process when candidates are referred for hiring.
Additional Information
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.
Resumes will not be accepted in lieu of a completed City and County of San Francisco application.
SELECTION PLAN
** Interviews:** Selected candidates will be invited to participate in one or more interviews at the Controller’s Office.
Additional Information Regarding Employment with the City and County of San Francisco:
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.