Data Engineer (Hybrid)

As a Data Engineer, you will be designing, developing, and maintaining the infrastructure and systems required for data storage, processing, and analysis. The Data Engineer plays a crucial role in building and managing the data pipelines that enable efficient and reliable data integration, transformation, and delivery for all data users across the enterprise.

What we offer:

• Work environment – Work in our beautiful home office building with access to a fitness facility, onsite nurse, and a café
• Hybrid Work Model – Allows for a blend of in-office and work-from-home days
• Competitive compensation – Includes an annual bonus plan, pension plan, and parking allowance
• Flexible Benefits Plan – In effect from day one and offers three levels of coverage to select from to meet your unique, personal needs
• Paid vacation – There is an annual option to purchase additional vacation, too
• Wellness support – With an annual wellness allowance, paid personal care days and a 24/7 Employee & Family Assistance Program
• Opportunity to give back to some amazing causes in our community – Choose when and where to make an impact with a paid volunteer day, company volunteer opportunities, and a donation-matching program

Your Responsibilities:

• Design and develop data pipelines that extract data from various sources, transform it into the desired format, and load it into the appropriate data storage systems
• Collaborate with data architects and analysts to optimize models and algorithms for data quality, security, and governance
• Integrate data from different sources, including databases, data warehouses, APIs, and external systems
• Ensure data consistency and integrity during the integration process, performing data validation and cleaning as needed
• Transform raw data into a usable format by applying data cleansing, aggregation, filtering, and enrichment techniques
• Optimize data pipelines and data processing workflows for performance, scalability, and efficiency
• Monitor and tune data systems, identify and resolve performance bottlenecks, and implement caching and indexing strategies to enhance query performance
• Implement data quality checks and validations within data pipelines to ensure the accuracy, consistency, and completeness of data
• Take authority, responsibility, and accountability for exploiting the value of enterprise information assets and of the analytics used to render insights for decision-making, automated decisions, and augmentation of human performance
• Work with stakeholders to establish the vision for managing data as a business asset
• Establish the governance of data and algorithms used for analysis, analytical applications, and automated decision-making

Your Skills:

• Strong communication and interpersonal skills
• Ability to multi-task and shift priorities
• Proven time management and organizational skills
• Aptitude to embrace ongoing change in technology
• Strong sense of urgency

Your Experience:

• College diploma or university degree in computer science, information systems, or computer engineering
• Minimum of 5 years’ experience in a Data Engineering or a similar role
• Experience in data management disciplines, including data integration, modeling, optimization, and data quality, or other areas directly relevant to data engineering responsibilities and tasks
• Experience developing and maintaining data lakes and data warehouses
• Experience with Microsoft Intelligent Data Platform (Fabric, Purview, etc.) or similar data platforms
• Proficiency in SQL and experience with database management systems
• Experience with data integration tools and technologies (e.g. Azure Data Factory, DataFlow Gen2, etc.)
• Experience with cloud platforms, particularly Microsoft Azure
• Experience with data visualization tools (e.g. Power BI)
• Experience with database platforms, including Oracle, MS SQL, DB2, Sybase, etc.

Job Requirements - Work Experience: Information Technology

Job Requirements - Education: Diploma / Certification: Information Technology

Irving Oil is committed to supporting a diverse and inclusive work environment. We thrive on the good energy that’s created when our people from different backgrounds, identities, cultures, and experiences share their unique perspectives. Diversity is key to our success and inclusion is everyone’s responsibility.