Oracle Data Warehouse Developer
Stantec · Edmonton, Alberta, CA
Key Responsibilities DevOps - Develop and maintain ETL, data model, and reporting standards.
Job description
Key Responsibilities DevOps: - Develop and maintain ETL, data model, and reporting standards. - Provide regular updates and communications on development and operational support activities including status updates, and setting priorities - Assist with the maintenance of existing Analytical UX and dashboards that support the business that leverage the Data Warehouse. - Support the administration of ETL components of development and production data warehouse reporting environments. - Assist with general Enterprise DW database maintenance activities as required . Architecture: - Provide subject matter expertise and support the creation of architectural and technical deliverables. - Design, develop, and implement data warehouse and BI solutions leveraging: - Enterprise data warehouse models - Oracle Data Integrator (ODI) - Oracle Business Intelligence Applications (OBIA) mappings and Oracle BI Repository (RPD) modeling - OAS/OAC (Oracle Analytics Server/ Oracle Analytics Cloud) dashboards and analytics components - Assess and document the impact of enhancements and customizations. - Participate in architecture reviews, code reviews, and planning sessions. - Ensure alignment with enterp...