Junior Data Engineer

BC Financial Services Authority (BCFSA) helps to protect British Columbians during the biggest financial decisions in their lives. We regulate B.C. ’s financial services sector, including credit unions, real estate licensees, registered pension plans, insurance and trust companies and mortgage brokers. Through modern, effective and efficient oversight, BCFSA protects consumers by impartially setting and enforcing standards across the entire sector ensuring the prosperity of the province.

BCFSA is an equal opportunity employer and welcomes applications from all groups. This includes Indigenous Peoples, women, visible minorities, persons with disabilities, persons of diverse sexual orientation, gender identity or expression (LGBTQ2S+), and others who may contribute to diversity at BCFSA.

We recognize unique styles, perspectives, beliefs, and creativity that support a diverse, respectful, inclusive and collaborative work environment. To achieve this, we are committed to:

• Hiring team members who represent the population we serve;
• Removing barriers that may prevent equitable employment;
• Supporting respectful work environments where everyone feels included and able to produce excellent results.

BCFSA is proud to be selected as one of BC's Top Employers (2025) in recognition of our competitive compensation, work-life balance, and progressive programs.

WHAT WE OFFER:

When you join us, you become part of a high-performing team. Here, each Team Member can bring their unique talent to make outstanding contributions as we work towards the common goal of protecting British Columbians during the most important financial transactions in their lives. We offer:

• Healthy living and work-life balance
• Comprehensive health and wellness benefits plan
• Opportunities for personal and professional development
• A challenging and engaging team environment
• Defined benefits pension plan
• Our team members enjoy the flexibility of a hybrid work model. They can choose every day where they want to work to be the most effective, from the comfort of their home to our beautiful office in downtown Vancouver. (Eligibility may vary, depending on position).

SUMMARY

The Junior Data Engineer is an early-career technical role that supports the development, validation, documentation, and sustainment of trusted data products and analytical foundations used for regulatory decision-making. This role completes assigned tasks across data ingestion, transformation, testing, documentation, reporting support, and operational follow-up. This role is designed for a recent graduate or early-career candidate with relevant education, co‑op, internship, project, or portfolio experience who wants to grow on a data engineering career track while contributing to practical analytics, governance, and data product delivery.

ACCOUNTABILITIES

• Support the design, development, testing, and maintenance of data pipelines, notebooks, scripts, jobs, and reusable transformation logic under the guidance of senior data engineers and technical leads.
• Assist with data ingestion and integration from internal systems, external files, APIs, databases, regulated submissions, and enterprise platforms using approved patterns and standards.
• Write, review, and maintain basic SQL, Python, and related data transformation logic to clean, standardize, join, validate, and prepare data for downstream analytics, reporting, and data products.
• Create, run, and document data quality checks, reconciliation procedures, regression tests, validation rules, and issue investigations using established methods.
• Use Git, Azure DevOps, work items, peer review comments, release notes, and approved branching practices to support controlled code changes and deployment readiness.
• Monitor scheduled jobs, pipeline runs, data refreshes, and operational alerts; investigate common failures, document findings, support root-cause analysis, and elevate risks or unclear issues to senior team members.
• Prepare and maintain practical engineering documentation, including data dictionaries, technical notes, runbooks, test results, issue logs, decision records, and release support materials.
• Apply established standards for naming, modular code, reusable templates, data contracts, data quality, metadata, access control, privacy, security, version control, and release discipline.
• Support metadata and governan