Oracle BI Technical Lead

4 days ago


Saint Louis, United States Global Soft Systems Full time
Job DescriptionJob Description

Oracle BI Technical Lead

Location: St. Louis, MO (Onsite)

Long Term

Need onsite candidates for interview as well

End client is seeking a resource with the following skills:

Oracle Analytics Reporting and Technical Developer responsible for designing, developing, and optimizing data pipelines, reports, and dashboards based on business stakeholder requirements.

This role requires knowledge to build a data pipeline on OAC using Oracle OTB data replication from Oracle. User should have experience in ERP and HCM subject areas.

ODI and OIC are a plus.

Oracle BI Technical Lead

  • OAC reporting, configuration/OBIA/ADW/DBCS
  • BICC/UCM/Object storage/data replication/packages/interface development
  • Ability to configure and perform data replication inside OAC on DBCS to extract fusion SaaS data.
  • Experience with App Composer
  • GitHub best practices for OAC repositories and reports
  • Ability to schedule reports and smtp distribution/mail server distribution.
  • P6 knowledge, GIS DB knowledge, EPBCS for source connections and integrations on OAC
  • Propose, conceptualize, design, implement, and develop solutions for difficult and complex applications independently.
  • Define complex application development administration and programming standards.
  • Oversee the support, maintenance, operation, and upgrades of applications.
  • Troubleshoot and resolve complex technical problems.
  • Review the physical design of existing systems for optimizing performance and create/maintain eco-system diagrams.
  • Lead projects, as necessary, for special systems and application development in areas of complex problems.
  • 5 or more years of experience with Oracle Fusion Cloud and OAC
  • Functional understanding of Oracle Fusion Modules (AP, GL, FA, CM, Procurement, PPM).
  • Oracle Fusion Cloud applications development experience using web services (SOAP/REST APIs, and PVOs).
  • Expert level experience in writing complex SQL queries, SQL tuning and database concepts.
  • Strong ability to translate business requirements into technical designs and requirements.
  • Strong communication skills with both technical and non-technical team members.
  • Develop efficient data pipelines from Oracle Cloud ERP to OAC, leveraging features like FAW (Fusion Analytics Warehouse), using DBCS and with OTBI connection and BICC for data extraction and transformation.
  • Implement at least three end-to-end projects involving OAC, FAW, and BICC. These projects may include migrations and new implementations.
  • Collaborate with business leaders, users, and IT teams to plan, design, develop, test, and implement data models, dashboards, and reports primarily using Oracle Analytics Cloud
  • Leverage ODI for data integration, ETL (Extract, Transform, Load), and data movement tasks.
  • Experience with Oracle databases and SQL is essential.

Skills and Qualifications:

At least five years of consulting or professional experience implementing analytics reports and solutions using Oracle technologies.

Proficiency in OACS, ODI, and OBIEE repository (RPD) for all layers.

Experience building complex reports and dashboards.

Bachelor's Degree Information technology discipline or computer engineering

Oracle certifications are welcomed.



  • Lake Saint Louis, United States Apptad Inc Full time

    Job DescriptionJob DescriptionJob Title: Apptad - Oracle Analytics Reporting and Technical Developer/ Oracle BI Technical Lead Job Location: St Louis, MO (Onsite) Job Duration: Long-TermJob Description:Oracle Analytics Reporting and Technical Developer responsible for designing,developing, and optimizing data pipelines, reports, and dashboards based on...


  • Lake Saint Louis, United States Apptad Inc Full time

    Job DescriptionJob DescriptionJob Title: Apptad - Oracle Analytics Reporting and Technical Developer/ Oracle BI Technical Lead Job Location: St Louis, MO (Onsite) Job Duration: Long-TermJob Description:Oracle Analytics Reporting and Technical Developer responsible for designing,developing, and optimizing data pipelines, reports, and dashboards based on...


  • Saint Louis, United States VSG Business Solutions LLC Full time

    Job DescriptionJob DescriptionInterview process: Virtual Interview and compulsory F2F Client InterviewNotes: Candidate has to work onsite for the first 60 days - 4 days a week.Job Description Oracle Analytics Reporting and Technical Developer responsible for designing, developing, and optimizing data pipelines, reports, and dashboards based on business...


  • Saint Louis, United States VSG Business Solutions LLC Full time

    Job DescriptionJob DescriptionInterview process: Virtual Interview and compulsory F2F Client InterviewNotes: Candidate has to work onsite for the first 60 days - 4 days a week.Job Description Oracle Analytics Reporting and Technical Developer responsible for designing, developing, and optimizing data pipelines, reports, and dashboards based on business...


  • Saint Louis, United States ENVISN INCORPORATED Full time

    Job DescriptionJob DescriptionJob Title: Oracle Analytics Reporting and Technical DeveloperLocation: St. Louis, MODuration: Long term contract Onsite Interviews Responsible for designing, developing, and optimizing data pipelines, reports, and dashboards based on business stakeholder requirements.   This role requires knowledge to build a data pipeline...


  • Saint Louis, United States ENVISN INCORPORATED Full time

    Job DescriptionJob DescriptionJob Title: Oracle Analytics Reporting and Technical DeveloperLocation: St. Louis, MODuration: Long term contract Onsite Interviews Responsible for designing, developing, and optimizing data pipelines, reports, and dashboards based on business stakeholder requirements.   This role requires knowledge to build a data pipeline...


  • Saint Louis, United States VSG Business Solutions LLC Full time

    Job DescriptionJob DescriptionSummary:Oracle Analytics Reporting and Technical Developer is responsible for designing, developing, and optimizing data pipelines, reports, and dashboards based on business stakeholder requirements.Role requires the following skills: Reporting and BI work using the myriad of Oracle database, cloud apps and tools listed in the...


  • Saint Louis, United States ENVISN INCORPORATED Full time

    Job DescriptionJob DescriptionJob Title: Oracle Analytics Reporting and Technical DeveloperLocation: St. Louis, MODuration: Long term contractOnsite InterviewsResponsible for designing, developing, and optimizing data pipelines, reports, and dashboards based on business stakeholder requirements. This role requires knowledge to build a data pipeline on OAC...


  • Saint Louis, United States ENVISN INCORPORATED Full time

    Job DescriptionJob DescriptionJob Title: Oracle Analytics Reporting and Technical DeveloperLocation: St. Louis, MODuration: Long term contractOnsite InterviewsResponsible for designing, developing, and optimizing data pipelines, reports, and dashboards based on business stakeholder requirements. This role requires knowledge to build a data pipeline on OAC...


  • Lake Saint Louis, United States VSG Business Solutions LLC Full time

    Job DescriptionJob DescriptionOracle Analytics Reporting and Technical Developer responsible for designing, developing, and optimizing data pipelines, reports, and dashboards based on business stakeholder requirements. Oracle BI Technical Lead OAC reporting, configuration/OBIA/ADW/DBCSBICC/UCM/Object storage/data replication/packages/interface development...

  • ERP Analyst III

    1 month ago


    Saint Louis, United States Bi-State Development Full time

    Job DescriptionJob DescriptionERP Analyst III – Senior Techno Functional Analyst, FinanceTo lead and support development, maintenance, and deployment of functionality related to Metro’s Oracle E-Business Suite. This position will focus on the General Accounting and Financials functional areas and requires working with our business customers and our...


  • St Louis, United States SRI Tech Solutions Inc. Full time

    Oracle Analytics Reporting and Technical Developer/ Oracle BI Technical Lead St Louis, MO 6+ Months CTH Experience : 10+ Years Job Description Oracle Analytics Reporting and Technical Developer responsible for designing, developing, and optimizing data pipelines, reports, and dashboards based on business stakeholder requirements. This role requires...


  • Saint Louis, United States Savi Gurus Full time

    Job DescriptionJob DescriptionSavi Gurus is seeking an Oracle Analytics Reporting and Technical Developer to work with at a client site in St. Louis, MO. This is a hybrid work environment with 4 days required on-site. Fully remote job seekers need not apply. This is required by the client. Applicant must have experience in Oracle ERP and HCM subject...


  • Saint Louis, United States Savi Gurus Full time

    Job DescriptionJob DescriptionSavi Gurus is seeking an Oracle Analytics Reporting and Technical Developer to work with at a client site in St. Louis, MO. This is a hybrid work environment with 4 days required on-site. Fully remote job seekers need not apply. This is required by the client. Applicant must have experience in Oracle ERP and HCM subject...


  • Saint Louis, United States Savi Gurus Full time

    Job DescriptionJob DescriptionSavi Gurus is seeking an Oracle Analytics Reporting and Technical Developer to work with at a client site in St. Louis, MO. This is a hybrid work environment with 4 days required on-site. Fully remote job seekers need not apply. This is required by the client. Applicant must have experience in Oracle ERP and HCM subject...


  • Saint Louis, United States Savi Gurus Full time

    Job DescriptionJob DescriptionSavi Gurus is seeking an Oracle Analytics Reporting and Technical Developer to work with at a client site in St. Louis, MO. This is a hybrid work environment with 4 days required on-site. Fully remote job seekers need not apply. This is required by the client. Applicant must have experience in Oracle ERP and HCM subject...


  • Saint Louis, United States Edward Jones Full time

    Innovate here. And see your ideas come to life.It's an exciting time to work in tech at Edward Jones. We are making massive investments in emerging technologies to improve how we work with our clients and with each other. Relationships are the focus of our business model. And working in Technology here means using your skills to build, deliver and maintain...


  • Saint Louis, United States Edward Jones Full time

    Innovate here. And see your ideas come to life.It's an exciting time to work in tech at Edward Jones. We are making massive investments in emerging technologies to improve how we work with our clients and with each other. Relationships are the focus of our business model. And working in Technology here means using your skills to build, deliver and maintain...


  • Saint Louis, United States Spire Energy Full time

    Date: Apr 27, 2024 Location: Saint Louis, MO, US, 63101 Birmingham, AL, US, 35203 Company: Spire Inc. Company Overview At Spire, we believe energy exists to help people. To enrich their lives, grow their businesses, advance their communities. It's a simple idea, but one that's at the heart of everything we do. We are committed to understanding the needs...


  • St Louis, United States Sidram Technologies LLC Full time

    Role: Oracle BI Technical Lead Want to make an application Make sure your CV is up to date, then read the following job specs carefully before applying. Location: St. Louis Missouri (Hybrid) 3 days onsite mandatory 12+ years resume Experience with OBIEE 11G Expert knowledge of EBS modules Advanced knowledge of Fusion modules PLSQL knowledge - advanced...