Sr. Data Modeler to implement Oracle Fusion Analytics Warehouse (FAW) data models and schemas for a major insurance client-778

Position: Sr. Data Modeler to implement Oracle Fusion Analytics Warehouse (FAW) data models and schemas for a major insurance client-778

Duration: 4 months with possible extension

Location: Hybrid (Toronto or Montreal)

Must haves:

• 5+ yrs exp as a Data Modeler implementing Oracle Fusion Analytics Warehouse (FAW)
• PL/SQL and BI reporting
• Functional understanding of Oracle Fusion Applications (ERP and EPM modules), Oracle Fusion Cloud’s Financial Management (FCFM)
• SQL Query and debugging exp

Nice to haves:

• Oracle Fusion Financial Reporting Studio (FRS)

This role will offer you the chance to:

• Design and implement data models and schemas to support analytical reporting requirements, reports, and dashboards, manage data model and data pipelines.
• Build Analytics and provide support on aspects such as data model changes and security configuration.
• Enable Fusion Analytics Warehouse (FAW) augmentation to support external data integration with other data platforms.
• Collaborate with data engineers and ETL developers to design, implement, and optimize data integration processes for loading data from various source systems into the Oracle Fusion Analytics data warehouse.
• Monitor and optimize the performance of the Oracle FAW, including database queries, data pipelines, and system resources. Identify and address performance bottlenecks and optimization opportunities. Requires close collaboration with Oracle product support team.
• Implement data modeling best practices and standards to ensure data consistency and integrity.
• Provide data modeling expertise and support to cross-functional teams.
• May prepare or review product documentation, written instructions or technical literature for accuracy and completeness.
• Participate in the fulfillment of ad-hoc data requests from internal business owners.
• Participate and guide vendor teams in implementing solutions to fit current architecture.