Oracle Analytics Reporting and Technical Developer

Savi 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 areas. Job Responsibilities: 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. 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. 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. 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. 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. Savi Gurus is a fast-growing St. Louis-based business and technology consulting firm with competitive salary, annual bonus, matching retirement plan, company-paid healthcare, dental, vision and pharma, 4 weeks of PTO, 10 holidays, and a nominal training budget. We hire consultants to keep. We're not turning and burning our folks. Join us and become One of the Savi Gs. ** Only applicants who are legally authorized to work in the US and not represented by anyone else will be considered. This position requires the consultant to be at the client site 4 days a week. This person needs to be able to do that without travel expenses. Savi Gurus does not provide any work authorization sponsorship, or any assistance in securing, maintaining or extending work authorization. ** E04JI800im7o406p747