City and County of San Francisco
Oracle Business Intelligence Reporting Analyst Hybrid Workplace Controllers Offi
City and County of San Francisco, San Francisco, California, United States, 94199
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 the 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: Hands on working experience with OBIA 11g (with ODI 12C), including the following: Oracle ODI Load Plans from PeopleSoft 9.2 FSCM (GL, AP, AR, BI, Contracts, PO, Project Costing) and HCM (Time and Labor, Payroll) OBIEE 12.2.1.1 and above (RPD and Dashboard Development) Extending out-of-the-box OBIA RPD with custom fact tables and metrics Strong hands on experience with SQL Scripting and PL/SQL experience Setup and integration of OBIEE/OBIA/ODI with various systems such as PeopleSoft and / or EBS Working with DBAs, BI Dev, PeopleSoft and / or EBS Functional Teams, and Security teams to improve performance and data quality using Agile sessions Deep understanding of Data Warehouse concepts and working knowledge of data modeling in large data warehouses. Working knowledge with Business Intelligence tool sets like Oracle OBIEE/ SAP Business Objects / IBM Cognos / MS Power BI. Experience analyzing, creating, documenting functional business/application solutions with clients and/or end users for large complex BI systems. This experience must include: Experience with formal software development life cycle methodologies i.e. SDLC. Working knowledge of business process flows used to support a complex Data warehouse, and experience in developing and executing Data Extraction and Dashboards. Expertise in utilizing appropriate tools for analyzing data, documenting processes, developing and testing prototype solutions, including Oracle SQL Query, Visio, MS Access, FTP. Senior level experience in enterprise relational database and/or On-line Analytical Processing (OLAP) modeling and design.
#J-18808-Ljbffr
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 the 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: Hands on working experience with OBIA 11g (with ODI 12C), including the following: Oracle ODI Load Plans from PeopleSoft 9.2 FSCM (GL, AP, AR, BI, Contracts, PO, Project Costing) and HCM (Time and Labor, Payroll) OBIEE 12.2.1.1 and above (RPD and Dashboard Development) Extending out-of-the-box OBIA RPD with custom fact tables and metrics Strong hands on experience with SQL Scripting and PL/SQL experience Setup and integration of OBIEE/OBIA/ODI with various systems such as PeopleSoft and / or EBS Working with DBAs, BI Dev, PeopleSoft and / or EBS Functional Teams, and Security teams to improve performance and data quality using Agile sessions Deep understanding of Data Warehouse concepts and working knowledge of data modeling in large data warehouses. Working knowledge with Business Intelligence tool sets like Oracle OBIEE/ SAP Business Objects / IBM Cognos / MS Power BI. Experience analyzing, creating, documenting functional business/application solutions with clients and/or end users for large complex BI systems. This experience must include: Experience with formal software development life cycle methodologies i.e. SDLC. Working knowledge of business process flows used to support a complex Data warehouse, and experience in developing and executing Data Extraction and Dashboards. Expertise in utilizing appropriate tools for analyzing data, documenting processes, developing and testing prototype solutions, including Oracle SQL Query, Visio, MS Access, FTP. Senior level experience in enterprise relational database and/or On-line Analytical Processing (OLAP) modeling and design.
#J-18808-Ljbffr