Intermediate Data Engineer

Northland Properties•Vancouver, BC

20h•CA$75,000 - CA$85,000•Hybrid

About The Position

We're looking for a Data Engineer to design and build the pipelines and data architecture that power analytics, reporting, and governance across the business. You'll spend most of your time moving and transforming data into Snowflake and Azure, and shaping the data models and structures that everything else depends on. It's a hands-on engineering role with room to influence how we build and scale our data platform.

Requirements

Bachelor's degree in Computer Science, Engineering, or a related field.
3+ years of professional experience in software or data engineering.
Strong SQL skills, including complex queries and performance optimization.
Hands-on experience building data solutions in Snowflake, ADF and Azure Functions.
A solid grounding in relational databases and data modeling fundamentals.
Proficiency with Python for data processing and automation.
Working knowledge of PowerShell for scripting and automation.
A strong software development foundation: Git/version control, testing, clean and maintainable code, and sound problem-solving.
A clear communicator who collaborates well in a hybrid team setting.

Nice To Haves

Experience with Azure data services (e.g., Azure SQL, Synapse, or Microsoft Fabric).
Familiarity with data governance, cataloging, or data quality frameworks.
Exposure to Microsoft Dynamics 365 Finance and/or the Power Platform (Dataverse, Power BI, Power Automate) — helpful, but not required.
Experience with ELT/orchestration tooling, dbt, or other modern data stack components.
Relevant certifications (e.g., Microsoft Certified: Azure Data Engineer Associate, SnowPro).

Responsibilities

Design, build, and maintain reliable, scalable data pipelines that move and transform data from source systems into Snowflake and Azure data stores.
Develop and optimize integrations between operational systems (including our D365 Finance and Power Platform environments) and the central data platform.
Design, document, and evolve data models, schemas, and the broader data architecture to support analytics, reporting, and governance.
Write efficient, maintainable SQL, and tune queries and warehouse performance.
Build automation, tooling, and operational scripts using Python and PowerShell.
Contribute to data quality, lineage, and governance standards, and keep documentation current.
Apply solid software engineering practices — version control, code review, testing, and CI/CD — to data workflows.
Partner with analysts, platform owners, and business stakeholders to translate requirements into well-structured data solutions.
Monitor, troubleshoot, and continuously improve the reliability and performance of data pipelines.