Oracle Analytics Engineer -- Fulltime -- Philadelphia, PA (Hybrid)

Lorven Technologies - Philadelphia, PA

Full-time

Philadelphia, PA

Professional, Scientific, and Technical Services

About the position

The Oracle Analytics Engineer will be responsible for leveraging Oracle technologies to design, implement, and maintain data solutions that support advanced analytics and business intelligence initiatives. This role requires a strong understanding of data warehousing concepts, data modeling, and the ability to work with large datasets to ensure data integrity and quality for analysis.

Responsibilities

• Experience in OBIEE /Oracle Analytics Cloud, Data Warehouse, or Oracle SQL experience, ideally with integration to/from Oracle Fusion (AR, AP, Procurement & GL modules) and EPM applications.
• Solid grasp of Oracle Database, Data Modelling, Oracle SQL Developer, Data Warehouse concepts, advanced analytics concepts, and implementation.
• Experience with the following Oracle solutions is greatly desired: Autonomous Data Warehouse (ADW), Oracle Analytics Cloud (OAC), Oracle Business Intelligence Application (OBIA) / Oracle Fusion Analytics Warehouse (FAW), JDBC/ODBC.
• Experience in data design, data modeling, data mapping, data interrogation, data quality, and master data management is desired.
• Experience in Building data pipelines from multiple data sources by performing necessary ETL tasks including processing, cleansing, and verifying the integrity of data used for analysis.
• Hands-on development with Oracle Integration Cloud.
• Experience in handling large data sets by writing python programs using Apache spark.
• Good interpersonal and communication skills.

Requirements

• Experience in OBIEE /Oracle Analytics Cloud, Data Warehouse, or Oracle SQL experience.
• Solid grasp of Oracle Database, Data Modelling, Oracle SQL Developer, Data Warehouse concepts, advanced analytics concepts, and implementation.
• Experience with Autonomous Data Warehouse (ADW), Oracle Analytics Cloud (OAC), Oracle Business Intelligence Application (OBIA) / Oracle Fusion Analytics Warehouse (FAW), JDBC/ODBC.
• Experience in data design, data modeling, data mapping, data interrogation, data quality, and master data management.
• Experience in Building data pipelines from multiple data sources by performing necessary ETL tasks.
• Hands-on development with Oracle Integration Cloud.
• Experience in handling large data sets by writing python programs using Apache spark.

Nice-to-haves

• Good interpersonal and communication skills.