Senior Data Engineer
Posted Updated
Description
Apply Digital in Vancouver, Canada is seeking a senior Data Engineer to design and implement scalable data pipelines and architecture. You will define data requirements, migrate sources, and build transformation layers using dbt on Snowflake, plus identity resolution and semantic layers for reporting.
You will work with CRM/email platforms, engage stakeholders, enforce data security, and contribute to best practices in ELT/ETL, data governance and cloud data warehousing.
Define data requirements and technology stack for projects. Audit source systems and define migration guidelines. Translate business requirements into technical specs including data streams and warehouses. Design and build dbt transformations on Snowflake. Build pipelines that activate data in engagement platforms. Run audits of digital products and provide data foundation recommendations. Work in git-based workflows with CI/CD for warehouse objects. Define data architecture standards and optimize models for performance and cost. Plan activities to populate new solutions with current and historical data. Implement data security and access controls. Document data sources, ELT/ETL processes, and data lineage for discovery. Bachelor's degree in Computer Science, Information Systems, or a related field. At least 5 years of experience in data engineering or related fields. Expert-level SQL and strong experience in ELT/ETL and cloud data warehousing, with hands-on Snowflake experience. Strong hands-on experience with dbt (modelling, tests, documentation, macros) and git-based workflows (branching, code review, CI/CD). Proven experience in data modelling (dimensional and semantic layers) and analysis techniques. Experience with customer data modelling and identity resolution across CRM, marketing and product sources. Experience integrating data with customer engagement platforms.Skills
Sign in to read and join the discussion.