Oracle Data Warehouse Developer

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 enterprise architecture and integration patterns.
• Provide configuration, environment setup, and performance optimization.

Data Engineering

• Develop data designs and scripts for new projects of moderate to high complexity.
• Execute hands-on ETL and BI development delivery tasks, specifically; ETL job development, technical data model design, and development.
• Ensure data quality through thorough testing and validation of new or updated analytical subject areas.
• Design dimensional and relational structures optimized for reporting and analytics.
• Build and maintain data integrations from multiple operational systems.
• Create summarization, aggregation, and reporting logic for high‑volume datasets.

Collaboration and Stakeholder Management

• Engage with cross-functional work teams including Finance, HR, Projects, etc. to enhance understanding of the subject areas.
• Analyze and troubleshoot tool, data, and access issues by collaborating with the Support Management team.
• Manage the stakeholder expectations on what can and cannot be incorporated into the BI subject areas and help them make the best use of the presentation layer of the subject areas.

Security and Data Governance

• Enforce data governance policies, ensuring compliance with data privacy regulations and implementing application roles or LDAP groups to control access to the dashboards.
• Implementing row level security when appropriate or required to ensure users access only the data they are authorized to view.

Additional Duties

• Develop structures and standards for use and maintenance of the Oracle-based data warehouse and surrounding BI tools and infrastructure.
• Define and enforce database design and management standards with the database administrator and document new and existing database systems and procedures.
• Provide performance tuning guidance and advice for database systems for query and data loading performance, including data partitioning, indexing, etc.
• Identify opportunities to improve or extend frameworks and standards.
• Participate in code reviews
• Support programming policies, procedures, and quality assurance best practices as it relates to business intelligence.

At Stantec, we have some of the world's leading professionals passionate about enabling our business to be its best. Our business teams include finance, procurement, human resources, information technology, marketing, corporate development, HSSE, real estate, legal, and practice services. We bring diverse backgrounds, skills, and expertise and create a caring culture where everyone can thrive. Through teamwork and collaboration, we're building a stronger, more resilient Stantec every day.