Data Engineer (Hybrid)

First West Credit Union; City of Langley; On-site; CAD 90,000 - 140,000; Full time

Job summary

First West Credit Union is seeking a Data Engineer to design, build, and manage data pipelines and assets across Microsoft and Oracle environments. You will integrate large datasets from multiple sources to enable reporting, dashboards, and analytics, using Azure, SQL Server, Oracle Database, and Oracle Cloud Infrastructure.

In this role you will help ensure data quality, security, and governance while developing scalable data models and supporting BI work with Power BI and Oracle Analytics

Qualifications

• Bachelors degree in computer science, information systems, or a related field.
• 5 years of professional experience in data engineering or related roles.
• Experience with Microsoft Azure cloud services, SQL Server, Oracle Database, and Oracle Cloud Infrastructure.
• Ability to design scalable data pipelines and ensure data quality, governance, and security.
• Strong SQL, Python, and data modeling skills.
• Experience with Power BI and BI reporting.
• Excellent communication and ability to translate technical concepts to business terms.

Responsibilities

• Design and develop scalable data pipelines and ETL processes to extract, transform, and load data from Microsoft and Oracle systems.
• Create and manage databases, data warehouses, and data lakes on Microsoft SQL Server/Azure and Oracle.
• Ensure data quality, security, and governance across platforms.
• Develop data models and schemas for analytics and reporting on Azure and Oracle.
• Support analytics teams with curated datasets and dashboards for BI tools.
• Monitor data pipeline and database performance; optimize queries to reduce latency and cost.
• Design and develop reports and dashboards in Power BI and Oracle Analytics Cloud.

Skills

Analytical thinking

Problem solving

Communication skills

Attention to detail

Growth mindset

Time management

Collaboration

Education

Bachelors degree in Computer Science / Information Systems

Tools

SQL

Python

Azure

Oracle

Microsoft SQL Server

Power BI

Azure Data Factory

Oracle Data Integrator

Fabric

Oracle Analytics Cloud

Job description

Job Description

We are currently seeking a Data Engineer to join our team. The Data Engineer is responsible for designing, building, and managing assets and pipelines for data collection, storage, and analysis within Microsoft and Oracle environments. This role involves integrating large datasets from multiple sources to ensure that data is accessible, consistent, and of high quality for reporting/dashboards, insights, and analytics. Experience is required with Microsoft Azure cloud services, SQL Server, Oracle Database, and Oracle Cloud Infrastructure to develop scalable data solutions. Additionally, responsibilities include ensuring our data pipelines are robust and secure, supporting data-driven decision-making across the organization.

Here’s what would be included as a part of your typical day

• Design and Develop Data Pipelines: Creates scalable data pipelines and ETL processes to extract, transform, and load (ETL) data from Microsoft and Oracle systems into centralized repositories. Use Fabric, Azure Data Factory and Oracle Data Integrator for efficient data extraction and transformation.
• Data Storage & Management: Create and manage databases, data warehouses, and data lakes on Microsoft SQL Server/Azure and Oracle. Ensure high performance and reliability by designing, indexing, and partitioning relational databases. Monitor and tune database health to meet business needs.
• Ensure Data Quality, Security, and Governance: Implement data quality controls, validation rules, and cleansing processes to maintain the integrity and accuracy of data within pipelines. Adhere to data governance standards and security protocols across both platforms, incorporating data masking or encryption where necessary, to ensure compliance with industry regulations and corporate policies.
• Develop and Optimize Data Models: Design efficient data models and schemas for analytics and reporting on Azure and Oracle. Structure databases and data warehouses to support querying and BI reporting, and update architecture as needed.
• Data Insights Support: Work with analytics teams to ensure that data is available and appropriately structured for BI tools. Provide curated datasets or views for reporting and assist in the creation of dashboards and reports, particularly with Microsoft Power BI, to convert raw data into actionable insights.
• Performance Monitoring & Troubleshooting: Monitor data pipeline and database performance and quickly resolve any issues. Use monitoring tools and logs to identify anomalies or bottlenecks. Optimize SQL queries, ETL jobs, and storage designs to improve throughput and reduce latency or cost.
• Reporting and Dashboarding: Design and develop efficient reports and dashboards in Power Bi-Microsoft Fabric and Oracle Analytics Cloud Platforms.

Required Skills, Experience & Qualifications

• Bachelor’s degree in computer science, Information Systems, or a related field required.
• 5 years of professional experience in data engineering, data platform management or related roles, or a combination of education and experience
• Exceptional problem-solving and analytical skills to troubleshoot complex data issues and devise efficient solutions.
• Excellent communication skills, with the ability to translate complex technical information into business terms for non-technical stakeholders.
• Ability to work under pressure and manage multiple projects and deadlines efficiently.
• Meticulous attention to detail and a commitment to data accuracy and quality.
• A growth mindset and eagerness to stay updated with new technologies and industry best practices.
• Expertise in data engineering, data management and data integration tools and technology stack
• Expertise in data modeling, database design, and data integration.
• Proficiency in SQL, Python, and other relevant programming languages.
• Displays an understanding of risk and risk ownership by being able to demonstrate adherence to policies and procedures.