Associate Data Engineer

Cooke Aquaculture Inc.; Saint John; On-site; CAD 55,000 - 75,000; Full time

Benefits offered by this job

Health benefits

Life & disability insurance

Employee Assistance Program (EAP)

RRSP matching

Paid vacation and holidays

Wellness programs

Career development

Employee discounts

On-site parking

Job summary

Cooke Aquaculture Inc. in Saint John, NB, is hiring an Associate Data Engineer to build and support basic data pipelines under guidance, ensuring data is extracted, transformed, and loaded accurately between systems using standard tools and SDLC practices.

You will work with foundational SQL, scripting, and data modeling, support ETL/ELT processes, monitor daily data flows, document datasets and workflows, and escalate complex issues to senior engineers as needed.

Qualifications

• Pursuing or recently completed a diploma or degree in Computer Science, Data Engineering, or related field.
• 0–2 years in data development or ETL support or related technical co-op or internship.
• Foundational SQL, scripting, and data modelling skills.
• Exposure to DBT, FiveTran, Boomi and API-based integrations is a plus.

Responsibilities

• Build and test basic data pipelines under supervision using standard tools and SDLC frameworks.
• Extract, transform, and load data from source systems following established design patterns.
• Monitor daily data flows and troubleshoot errors or failed jobs.
• Maintain and document datasets, workflows, and integration processes.
• Escalate complex issues or data anomalies to senior engineers or architects.

Skills

SQL

Scripting

Data modelling

ETL/ELT

Pipeline monitoring

Data quality

Education

Diploma or degree in Computer Science / Data Engineering

Tools

Snowflake

DBT

FiveTran

Boomi

API integrations

Job description

The Role

As an Associate Data Engineer, you will build and support basic data pipelines under guidance. You will help ensure data is extracted, transformed, and loaded accurately between systems using standard tools, established design patterns, and approved software development lifecycle practices.

Key Responsibilities

• Build and test basic data pipelines under supervision using standard tools and SDLC frameworks.
• Extract, transform, and load data from source systems following established design patterns.
• Monitor daily data flows and troubleshoot errors or failed jobs.
• Maintain and document datasets, workflows, and integration processes.
• Escalate complex issues or data anomalies to senior engineers or architects.

What Success Looks Like

• Basic data pipelines are built, tested, and supported accurately under guidance.
• Daily data flows are monitored consistently, with errors identified and escalated appropriately.
• Datasets, workflows, and integration processes are documented clearly and kept current.
• Work follows established design patterns, SDLC practices, and enterprise data standards.
• Learning progress is demonstrated through increased confidence with Cooke’s data platforms, tools, and engineering best practices.

Core Skills & Competencies

• Foundational data engineering skills, including basic SQL, scripting, data modelling, and understanding of data structures and relationships.
• Ability to support basic ETL and ELT processes, including data ingestion, transformation, integration, and pipeline monitoring under guidance.
• Exposure to modern data tools and platforms such as Snowflake, DBT, FiveTran, Boomi, and API-based integrations.
• Attention to data quality, including profiling datasets, identifying errors, applying validation checks, and following data security practices.
• Willingness to learn enterprise data standards, governance practices, metadata management, and engineering best practices while escalating complex issues appropriately.

Behaviors That Drive Success

• Adaptability: Adapts to minor changes with support; remains calm in routine disruptions.
• Business Acumen: Understands basic business processes and terminology.
• Collaboration & Synergy: Works cooperatively with team members on shared tasks.
• Decisiveness: Makes informed decisions in familiar situations; seeks guidance when uncertain.
• Design Thinking: Applies basic design or process improvement techniques to specific problems.
• Digital Acumen: Uses digital tools confidently and adapts to new systems.
• Diversity Mindset: Demonstrates openness to other perspectives and working styles.
• Growth Mindset: Seeks development opportunities and applies new skills to work.
• Innovative: Experiments with new approaches and learns from results.
• Outcome Driven: Focuses on completing assigned tasks accurately.
• Political Savviness: Aware of reporting structures and workplace etiquette.
• Risk Taking: Follows established procedures and avoids mistakes.

Experience & Qualifications

• Education: Currently enrolled in, or recently completed, a diploma or degree in Computer Science, Data Engineering, Information Systems, or a related field.
• Experience: 0-2 years in data development, ETL support, or a related technical co-op or internship.
• Skills: Basic SQL and scripting, data modelling fundamentals, attention to detail, and eagerness to learn.
• Organization-specific: Exposure to Cooke’s data pipelines, integration tools such as DBT, FiveTran, and Boomi, and an understanding of enterprise data standards and quality expectations.

Join our team and enjoy the benefits of full-time year-round employment with competitive rates and a comprehensive benefits package tailored to support your well-being and career growth.

Benefits Package:

• Health Benefits: Includes coverage for dental, vision, and extended medical care.
• Insurance: Life and disability insurance provided for financial security.
• Support Services: Access to an Employee Assistance Program (EAP).
• Financial Planning: Opportunity for RRSP matching to support your retirement savings.
• Time Off: Paid vacation, holidays, and sick leave for work-life balance.
• Wellness: Wellness programs and access to on-site gym facilities (available in some locations).
• Career Development: Professional growth opportunities and avenues for advancement.
• Perks: Employee discounts on company products or services.
• Convenience: On-site parking or parking allowance.

The Why

Why Cooke? Simple - because we are a company that rewards initiative, resourcefulness, and work ethic. We will champion your growth and provide you with the platform to create your path, your career, and your future.