Advanced Hires · 5 days ago

Oracle Analytics Reporting and Technical Developer

St Louis, MO

Full-time

Onsite

Senior Level

5+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

Staffing and Recruiting

Insider Connection @Advanced Hires

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Responsible for designing, developing, and optimizing data pipelines, reports, and dashboards based on business stakeholder requirements.

Build data pipelines on Oracle Analytics Cloud using Oracle OTB data replication from Oracle, with experience in ERP and HCM subject areas.

Configure and perform data replication inside Oracle Analytics Cloud on DBCS to extract fusion SaaS data.

Lead projects for special systems and application development in areas of complex problems.

Translate business requirements into technical designs and requirements.

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.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Oracle Fusion CloudOracle Fusion ModulesWeb servicesSQLDatabase conceptsData pipelinesTechnical designsOracle Cloud ERPFAWDBCSOTBIBICCEnd-to-end projectsMigrationsData modelsDashboardsOracle Analytics CloudODIETLData integrationCommunicationCollaborationOICApp ComposerGitHubP6GIS DBEPBCSOracle certifications

Required

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

Bachelor’s Degree – Information technology discipline or computer engineering