Oracle Business Intelligence Reporting Analyst Hybrid Workplace Controllers Office 1053

5 days ago


San Francisco, California, United States City and County of San Francisco Full time

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

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

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

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:

Information About The Hiring Process
Conviction History
Employee Benefits Overview
Equal Employment Opportunity
Disaster Service Worker
ADA Accommodation
Veterans Preference
Right to Work
Copies of Application Documents
Diversity Statement

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.



  • San Francisco, California, United States City and County of San Francisco Full time

    Job DescriptionPeopleSoft Functional Analyst - Office of the Controller for the People & Pay Benefits Functional TeamThe Senior PeopleSoft Benefits Functional Business Analyst serves as a key point of contact for San Francisco Health Service System staff that are responsible for providing benefits coverage to eligible employees/retirees. In addition to...


  • San Francisco, California, United States Autodesk Full time

    Job Requisition ID # 24WD78622 Position Overview Were looking for a passionate and driven Business Intelligence Analyst to join our Customer Experience (CX) Analytics team. You will report into the Senior Manager of Business Analytics and partner with Product Managers across our Digital Experience & Customer Empowerment (DXC) organization to provide unbiased...


  • San Francisco, California, United States Stantec Consulting International Ltd. Full time

    Stantec - Project Controls AnalystStantec, a company committed to shaping communities through innovative design, is seeking a dedicated Project Controls Analyst to join their team. As a Project Controls Analyst, you will play a vital role in ensuring the financial success of building sector projects, contributing to the overall profitability of the...


  • San Francisco, California, United States Chime Full time

    About the RoleAs a Business Intelligence Engineer, you will democratize data and drive data-obsessed decision making for all employees by helping to build and manage Chime's Looker instance. In this particular role, you will support Chime's cross functional teams by building reporting products that provide business/data insights. You will additionally assist...


  • San Francisco, California, United States Check Full time

    Check is leading a revolution in the payroll industry. Payroll is the backbone of the US economy, and yet it has not undergone significant innovation in decades. We invented the embedded payroll space to change that (see: Check: Solving the $150 Billion Payroll Problem, Bank On It; Episode 438), both for the business owners who spend countless hours per week...


  • San Francisco, California, United States Square Inc. Full time

    Block is one company built from many blocks, all united by the same purpose of economic empowerment. The blocks that form our foundational teams — People, Finance, Counsel, Hardware, Information Security, Platform Infrastructure Engineering, and more — provide support and guidance at the corporate level. They work across business groups and around the...


  • San Francisco, California, United States Strategic Resilience Group Full time

    SRG is seeking an experienced Senior Intelligence Analyst to join our team of Cyber Operation Analysts and Subject Matter Experts (SMEs) to support planning, coordination, synchronization, and execution of offensive cyberspace operations in support of aligned combatant command and designated sub-unified commands. This includes a deep understanding and...

  • NSI Business Analyst

    2 weeks ago


    San Francisco, California, United States Zoom Corporation Full time

    What You Can Expect Zoom's Business Applications team is looking for a Business Systems Analyst (BSA) who will support our New Service Introduction team. You will partner with Product Managers to elicit business requirements, collaborate with technology teams, and improve customer adoption. About The Team Team focuses on New Service Introduction (NSI) offer...


  • San Jose, California, United States Calix, Inc. Full time

    ANALYST Calix, Inc. in San Jose, CA seeks Bus. Sys.Analyst, Finance Oracle Cloud: Evaluate business cases & options for Oracle Cloud modules & enhancements by staying up to date on Oracle Cloud's features & quarterly releases. Coordinate with the IT organization to ensure the accounting team's needs are met. Full-time telecommuting allowed....


  • San Francisco, California, United States Central California Alliance for Health Full time

    We have four opportunities to join the Alliance as an Operations Reporting Analyst in the Operations Management Department. ABOUT THE DEPARTMENTThe Operations Management Department is a new department at the Alliance, developed to bring health plan operations data management and reporting under one umbrella to help drive timely business decisions through...


  • San Francisco, California, United States Hybrid Pathways Full time

    About the Opportunity:Hybrid Pathways, a New Era Company, is seeking a Security Threat Detection Engineer Consultant to support client's Threat Management objectives to build, maintain and improve threat detections and alerting infrastructure and to ensure the right data collection and detections are in place to discover threats against infrastructure, data,...


  • San Francisco, California, United States City and County of San Francisco Full time

    Job DescriptionUnder general supervision, the 1634 performs difficult bookkeeping and financial record keeping operations within complex accounting systems and may direct the work of other clerical staff. The person selected for this position will be required to interpret, enforce and carry out existing policies and procedures relative to financial record...


  • San Francisco, California, United States City and County of San Francisco Full time

    Job DescriptionUnder general supervision, the 1634 performs difficult bookkeeping and financial record keeping operations within complex accounting systems and may direct the work of other clerical staff. The person selected for this position will be required to interpret, enforce and carry out existing policies and procedures relative to financial record...


  • San Francisco, California, United States Hybrid Pathways Full time

    About the Opportunity: Hybrid Pathways, a New Era Company, is seeking a Security Threat Detection Engineer Consultant to support clients Threat Management objectives to build, maintain and improve threat detections and alerting infrastructure and to ensure the right data collection and detections are in place to discover threats against infrastructure, data,...

  • Oracle SCM

    2 weeks ago


    San Francisco, California, United States AppLab Systems Inc Full time

    Hi,Hope you are doing good...I am Ram represented to Applab Systems and I have an excellent job opportunity for you. Please find the below job description and if you are comfortable, please reply or contact me for further discussion.Job Title: Oracle SCM / OM AnalystLocation: Bay Area / San Francisco Area (Should work in-person from Fremont office, CA)Job...


  • San Francisco, California, United States University of California , San Francisco Full time

    Donor Relations Data AnalystDevelopment Full Time 78669BR Job Summary Are you a data wizard who loves to help your colleagues? Do you spot that one glitch no one else sees? Can you foresee data problems no one else has imagined? Under the supervision of the Senior Director of Donor Relations, the Donor Business Intelligence Specialist plays a key role in...


  • San Clemente, California, United States JobsRUs Full time

    is seeking hire a Data Reporting Analyst for our client in San Clemente, CA Benefits Available Weekly Pay 20.76 per Hour 8a to 5pM Primary Responsibilities Manage IBuy setup and Wholesaler Acquisition Cost in Oracle. Additional Responsibilities Monitor and process sales in i Hold queue. Support customer setup and identify correct class of trade. Assist in...


  • San Clemente, California, United States CyberTec Full time

    Only USC/GC/GC-EAD/H4-EAD Life Sciences Senior Business Systems Analyst/Supply Chain and Operations- Oracle EBS San Clemente- (Remote with infrequent travel 5% of the time) 12+ Month Contract Phone then Video $75-80/hr on C2C Job Description: The BSA for supply chain and operations responsible for working with the Business to document requirements and...

  • Business Analyst

    4 weeks ago


    San Jose, California, United States e-walkwater Technologies Full time

    Role DutiesThe role that you will be performing is that of a "Oracle ERP Analyst". What this role entails is working with our various clients understanding what their business process is come up with the "AS IS" process and the derive the "TO BE" process keeping in mind that they will using Oracle ERP to perform their operations. In this role there is a lot...


  • San Jose, California, United States Tekfortune Inc Full time

    Tekfortune is a fast-growing consulting firm specialized in permanent, contract & project-based staffing services for world's leading organizations in a broad range of industries. In this quickly changing economic landscape, virtual recruiting and remote work are critical for the future of work. To support the active project demands and skills gaps, our...