Oracle Data Warehouse Engineer | ETL & BI

Stantec; Edmonton; On-site; CAD 75,000 - 95,000; Full time

Benefits offered by this job

Health, dental, and vision plans

Wellness program

Employee stock purchase program

Job summary

A leading engineering firm is seeking a skilled data engineer to develop and maintain ETL processes and BI solutions. The ideal candidate will have extensive experience with Oracle Data Integrator and a strong background in data warehousing concepts. You'll work collaboratively with multiple teams, ensuring data quality and implementing governance policies. With a commitment to excellence and a focus on data-driven outcomes, this role offers the opportunity to significantly impact our analytics capabilities.

Qualifications

• 8+ years of application or data solution development experience, ideally in enterprise environments.
• Strong expertise in ETL development, ideally with Oracle Data Integrator or similar tools.
• Experience working with data warehousing and BI tools, especially Oracle.

Responsibilities

• Develop and maintain ETL, data model, and reporting standards.
• Design and implement BI solutions leveraging enterprise data warehouse models.
• Ensure data quality through thorough testing and validation.

Skills

ETL development expertise

Data warehousing concepts

Advanced SQL skills

BI and analytics tools experience

Problem-solving abilities

Attention to detail

Agile experience

Education

Bachelor’s degree in Computer Science or related field

Tools

Oracle Data Integrator (ODI)

Oracle Analytics Server (OAS)

Oracle Analytics Cloud (OAC)

Job description

A leading engineering firm is seeking a skilled data engineer to develop and maintain ETL processes and BI solutions. The ideal candidate will have extensive experience with Oracle Data Integrator and a strong background in data warehousing concepts. You'll work collaboratively with multiple teams, ensuring data quality and implementing governance policies. With a commitment to excellence and a focus on data-driven outcomes, this role offers the opportunity to significantly impact our analytics capabilities.