Oracle BI Reporting Specialist

2 weeks ago

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

Company Overview

Hybrid Work Environment:
Our organization promotes a flexible work schedule, allowing employees to work 1 day onsite and 4 days remotely, subject to regular assessments and approvals.

Controller's Office Overview
The Controller serves as the chief financial officer for the City. Our team comprises financial, technological, analytical, and other professionals dedicated to maintaining the City's financial integrity and fostering efficient, effective, and accountable governance. We uphold high standards and aim to exemplify good governance. We appreciate the diverse backgrounds, perspectives, and experiences of our teams and clients in all our endeavors. Our collaborative and inclusive environment promotes equal opportunity and invests in the professional development and well-being of our team members. You will collaborate with colleagues committed to public service and making a positive impact through their work. We seek intelligent, driven individuals eager to contribute to solving the City's challenges, including addressing long-standing disparities in our communities. For a meaningful career with opportunities for professional advancement, consider a position in the Controller's Office.

Systems Division of the Controller's Office:
The Systems Division manages the City and County of San Francisco's Enterprise Oracle and PeopleSoft Applications, which encompass various systems such as 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, branded locally, provide a comprehensive platform delivering essential services to numerous City Departments, reducing reliance on numerous independent legacy systems. The division supports over 35,000 active City employees, 75,000 retirees, and 25,000 City vendors. The technology maintained by the Systems Division ensures standardization, transparency, and efficiency in the City's critical business processes, with full user support to promote the adoption of these interconnected functionalities.

Position Overview

The Reporting Analyst role is integral to the Business Intelligence and Reporting Team, collaborating with members of the Functional and Change Management Teams, as well as other City staff, to develop and maintain the Oracle Business Intelligence (OBIEE) system. The Reporting Analyst will engage in both functional (business process and systems analysis, testing, user support) and technical (data extraction, loading and transformation, metadata modeling, dashboard development, query optimization, and troubleshooting) activities. Proficiency with Oracle Business Intelligence tools such as Oracle ODI/OBIA/OBIEE is highly desirable.

Key Responsibilities:

- Analyze the interconnections of business processes, complex financial data, and systems to establish reporting requirements and data structures.
- Conduct fit/gap analysis and define application configuration settings.
- Collaborate with the project team on transition plans for re-engineered business processes.
- Analyze and test security roles and permissions.
- Draft technical specifications and design solutions according to specifications.
- Develop and execute system and user acceptance test plans, evaluating test outcomes.
- Provide user support and training through various formats, including in-person, phone, and workshops.
- Document business and system processes, as well as technical specifications.
- Identify, manage, and escalate issues and risks throughout the software development lifecycle.
- Perform additional 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 institution, or equivalent coursework totaling at least sixty (60) semester or ninety (90) quarter credits, with a minimum of twenty (20) semester or thirty (30) quarter credits in one of the specified fields.

Experience: A minimum of three (3) years in the information systems sector, encompassing system analysis, business process design, development, and implementation of business application solutions or IT project management.

Desirable Qualifications:

The following qualifications will be utilized to identify finalists at the conclusion of the selection process:

  • Practical experience with OBIA 11g (with ODI 12C), including Oracle ODI Load Plans from PeopleSoft FSCM and HCM.
  • Strong proficiency in SQL scripting and PL/SQL.
  • Experience in setting up and integrating OBIEE/OBIA/ODI with various systems.
  • Collaboration with DBAs, BI Developers, and Functional Teams to enhance performance and data quality.
  • Comprehensive understanding of Data Warehouse concepts and data modeling in extensive data warehouses.
  • Familiarity with Business Intelligence tools such as Oracle OBIEE, SAP Business Objects, IBM Cognos, and MS Power BI.
  • Experience in analyzing, documenting, and creating functional business/application solutions for large BI systems.
  • Knowledge of formal software development life cycle methodologies (SDLC).
  • Understanding of business process flows supporting complex Data Warehouses and experience in Data Extraction and Dashboard development.
  • Expertise in utilizing tools for data analysis, process documentation, and prototype solution development.
  • Senior-level experience in enterprise relational database and/or OLAP modeling and design.

Additional Information

Verification: Applicants may be required to provide verification of qualifying education and experience at any stage during the recruitment and selection process. Falsifying educational or work experience information may result in disqualification from this and future job opportunities.

Selection Process: Selected candidates will be invited to participate in interviews.

Equal Opportunity Employment: The City and County of San Francisco encourages applications from women, minorities, and individuals with disabilities. All applicants will be considered without regard to sex, race, age, religion, color, national origin, ancestry, physical or mental disability, medical condition, HIV/AIDS status, genetic information, marital status, sexual orientation, gender identity, gender expression, military and veteran status, or any other protected category under the law.

  • Oracle BI Reporting Specialist

    2 weeks ago

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

    Company Overview Hybrid Work Environment: Our organization promotes a flexible work schedule, allowing employees to work 1 day onsite and 4 days remotely, with periodic assessments and approvals. Financial Management Division The Financial Management Division serves as the chief financial authority of the City. Our team comprises financial,...

  • Oracle BI Reporting Specialist

    2 weeks ago

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

    Hybrid Work Environment:Our organization embraces a hybrid work model, allowing team members to work 1 day onsite and 4 days remotely, with flexibility subject to periodic review and approval.Controller's Office Overview:The Controller serves as the chief financial officer for the City, leading a team of financial, technological, and analytical professionals...

  • Oracle BI Reporting Specialist

    7 days ago

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

    Company Overview Work Environment: Our organization embraces a hybrid work model, allowing employees to balance their time between remote work and occasional in-office presence. Controller's Office Overview The Controller's Office serves as the primary financial authority for the City. Our team comprises professionals from various fields, including...

  • Oracle Fusion Applications Technical Specialist

    1 week ago

    San Francisco, California, United States Cortex consultants LLC Full time

    Job OverviewPosition: Oracle Fusion Applications Technical SpecialistCompany: Cortex Consultants LLCContract Duration: 6 MonthsPosition Summary:The ideal candidate will possess a robust technical foundation, demonstrating a proven track record in the implementation and integration of Oracle Fusion applications, alongside a comprehensive understanding of...

  • Oracle Fusion Integration Specialist

    2 weeks ago

    San Francisco, California, United States Atem Corp Full time

    Job OverviewPosition: Oracle Fusion Technical ConsultantCompany: Atem CorpContract Duration: 6 MonthsEssential Skills: Oracle ERP, Oracle OIC, Oracle Accounts ReceivableRole Summary:The ideal candidate will possess a robust technical foundation with proven expertise in deploying and integrating Oracle Fusion applications. A comprehensive understanding of...

  • Oracle Record-to-Report Consultant

    2 weeks ago

    San Francisco, California, United States Resource Logistics Full time

    Job OverviewAs an Oracle Record-to-Report (R2R) Consultant at Resource Logistics, you will play a pivotal role in enhancing our financial processes through the Oracle E-Business Suite or Oracle Cloud ERP system. Your expertise will guide the entire accounting cycle, from documenting financial transactions to generating comprehensive financial reports.Key...

  • Oracle HCM Business Intelligence Analyst

    2 days ago

    San Francisco, California, United States LHH Recruitment Solutions Full time

    Job SummaryWe are seeking an experienced Oracle HCM Business Intelligence Analyst to join our team at LHH Recruitment Solutions. As a key member of our team, you will be responsible for designing, developing, and delivering critical HCM reporting dashboards and analytics using Oracle Transactional Business Intelligence (OTBI) and Business Intelligence...

  • Oracle EBS Technical Lead

    4 days ago

    San Francisco, California, United States Outdefine Full time

    Oracle EBS Technical LeadLocation: Not SpecifiedAbout the Job Overview:The senior technical lead would oversee and support the Oracle product and technology landscape enterprise, with end-to-end responsibility from solution architecting to standards compliance.Key Responsibilities:Design, develop, convert, customize, interface, and implement Oracle...

  • Oracle EBS Specialist

    4 days ago

    San Francisco, California, United States Outdefine Full time

    Job Title: Oracle EBS DeveloperAbout the Role:We are seeking an experienced Oracle EBS Developer to join our team at Outdefine. As an Oracle EBS Developer, you will be responsible for designing, developing, and customizing Oracle EBS solutions to meet business requirements.Key Responsibilities:Design and Develop Oracle EBS Solutions: You will be responsible...

  • Advanced BI Reporting Specialist

    2 weeks ago

    San Diego, California, United States Akraya Inc. Full time

    JOB SUMMARY:The role of the BI Reporting Analyst III involves utilizing advanced analytical skills to drive business improvements through data insights.KEY SKILLS:Expertise in SQL and QuickBase is essential.Familiarity with Tableau or QlikSense is beneficial.Experience with AWS QuickSight is a plus.CONTRACT DETAILS:Contract Type: W2 OnlyDuration: 12+ Months...

  • Lead Financial Reporting Specialist

    2 weeks ago

    San Francisco, California, United States Discord Full time

    About the RoleDiscord is seeking a Lead Financial Reporting Specialist to enhance our expanding team. This role is pivotal in the formulation of the organization's financial reports and associated disclosures, conducting accounting analysis, drafting position papers, and managing intricate aspects of the business's financial operations.This position will...

  • Senior Oracle SOA Integration Specialist

    2 weeks ago

    San Francisco, California, United States ShiftCode Analytics Full time

    Position OverviewWe are seeking a Senior Oracle SOA Integration Specialist for a contract-to-hire opportunity with our esteemed client in the healthcare sector. This role is designed for candidates who are local to California and will initially offer remote work flexibility for a specified duration before transitioning to a full-time position in the Los...

  • Oracle Integration Cloud Specialist

    2 days ago

    San Jose, California, United States SRI Tech Full time

    Job Description:**About the Role:**We are seeking a highly skilled Oracle Integration Cloud (OIC) specialist to join our team at SRI Tech Solutions. As an OIC specialist, you will be responsible for designing, implementing, and maintaining integration solutions using Oracle's cloud-based platform.Key Responsibilities:Design and develop integration solutions...

  • Oracle HFM Developer

    1 day ago

    San Francisco, California, United States Atria Group LLC Full time

    We specialize in providing IT services to small to medium size companies, helping them maximize their IT resources and meet the ever-changing IT needs and challenges.In addition, we offer enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration...

  • Oracle Integration Cloud Specialist

    2 weeks ago

    San Jose, California, United States SRI Tech Full time

    Position: Oracle Integration Cloud (OIC) SpecialistCompany Overview: SRI Tech Solutions is a prominent provider of innovative technology solutions, focusing on Oracle Integration Cloud and other advanced technologies.Role Overview:Minimum of 6 years of expertise in Oracle Integration Cloud (OIC) frameworksFamiliarity with Oracle PaaS offerings and...

  • Oracle HCM Functional Consultant

    2 days ago

    San Jose, California, United States Siri InfoSolutions Inc Full time

    Job DescriptionSiri InfoSolutions Inc is seeking a highly skilled Oracle HCM Functional Consultant to join our team. As a key member of our organization, you will be responsible for designing, developing, maintaining, and delivering key HCM (OTBI and BI Publisher) reporting dashboards, analytics, and extracts.Key Responsibilities:Design and Development:...

  • Oracle EBS Developer

    4 days ago

    San Francisco, California, United States Outdefine Full time

    Job Title: Oracle EBS DeveloperAbout the Role:We are seeking an experienced Oracle EBS Developer to join our team at Outdefine. As an Oracle EBS Developer, you will be responsible for designing, developing, and customizing Oracle EBS solutions to meet business requirements.Key Responsibilities:Design and Develop Oracle EBS Solutions: You will be responsible...

  • Program Management Specialist

    4 days ago

    San Jose, California, United States Oracle Full time

    Job DescriptionJob Summary:We are seeking a highly skilled Technical Program Manager to join our team at Oracle. As a Technical Program Manager, you will be responsible for owning the execution of Oracle Health Data & Analytics initiatives, working closely with cross-functional teams to deliver sophisticated programs with competing priorities.Key...

  • BI Program Manager

    7 days ago

    San Francisco, California, United States SA TECHNOLOGIES Full time

    SA Technologies is a prominent player in the IT consulting sector, recognized for its rapid growth and extensive operations across various regions. As an Oracle Gold Partner, SAP Services Partner, and IBM Certified enterprise, we are committed to delivering exceptional value to our clients.We offer competitive compensation that reflects your skills and...

  • Lead Oracle Hyperion Specialist

    2 weeks ago

    San Ramon, California, United States Info Way Solutions Full time

    Lead Oracle Hyperion Specialist Contract Duration: 6 months Work Arrangement: Onsite preferred, with remote options for exceptional candidates in the PST time zone. Key Responsibilities: Over a decade of extensive experience in the implementation, configuration, and support of Oracle Hyperion Planning and Essbase applications.Proficient in integrating with...