DBT Developer

Cognizant; Remote; CAD 80,000 - 100,000; Full time

Job summary

A prominent technology firm is looking for a DBT Developer to design and implement scalable data architecture solutions in Calgary, Alberta. You will collaborate with cross-functional stakeholders to optimize performance using DBT Cloud, Snowflake, and advanced SQL techniques. The ideal candidate has extensive DBT experience, strong data transformation skills, and a Bachelor's degree in a relevant field, along with certifications like CDMP and DBT Cloud. This position is remote flexible, supporting work-life balance.

Qualifications

• Extensive experience in DBT Cloud and SQL performance tuning.
• Strong knowledge of data transformation techniques.
• Proficiency in Snowflake SQL and data integration.

Responsibilities

• Lead the design and implementation of data architecture solutions.
• Oversee development and deployment of DBT Cloud and Snowflake projects.
• Collaborate with stakeholders to capture requirements and deliver solutions.

Skills

DBT Cloud

SQL performance tuning

Data transformation techniques

Snowflake SQL

Workflow automation

Problem-solving

Communication skills

Education

Bachelor's degree in Computer Science or relevant field

Certified Data Management Professional (CDMP)

DBT Cloud Certification

Tools

DBT macros

Snowflake

Job description

About the role

As a DBT Developer, you will make an impact by designing and implementing scalable data architecture solutions that optimize performance and enable seamless data integration. You will be a valued member of our Technology & Engineering team, collaborating with cross‑functional stakeholders to deliver innovative solutions using DBT Cloud, Snowflake, and advanced SQL performance tuning techniques.

In this role, you will:

• Lead the design and implementation of data architecture solutions that enhance performance and scalability.
• Oversee development and deployment of DBT Cloud and Snowflake projects to ensure efficient data transformation.
• Provide expert guidance on Snowflake SQL performance tuning to improve query efficiency and responsiveness.
• Develop and maintain DBT macros to streamline workflows and automate data processing.
• Ensure data integrity and consistency across platforms through robust integration strategies.
• Collaborate with stakeholders to capture requirements and deliver solutions aligned with business objectives.
• Implement best practices for data governance and management to safeguard data assets.
• Facilitate workshops and training sessions to strengthen team capabilities in data transformation.
• Monitor system performance, troubleshoot issues, and drive continuous improvement initiatives.

Work model:

We strive to provide flexibility wherever possible. Based on this role’s business requirements, this is a remote position open to qualified applicants in city, state. Regardless of your working arrangement, we are here to support a healthy work‑life balance through our various wellbeing programs.

What you need to have to be considered:

• Extensive experience in DBT Cloud and SQL performance tuning with strong knowledge of data transformation techniques.
• Proficiency in Snowflake SQL and data integration for managing complex data environments.
• Strong background in developing and utilizing DBT macros for workflow automation.
• Bachelor’s degree in Computer Science, Information Technology, or related field.
• Relevant certifications: Certified Data Management Professional (CDMP) and DBT Cloud Certification.
• Excellent problem‑solving and analytical skills with the ability to interpret large datasets.
• Effective communication skills for collaboration with diverse teams and stakeholders.

These will help you stand out:

• Experience implementing best practices for data governance and security.
• Familiarity with emerging technologies and trends in data architecture.
• Ability to lead workshops and mentor teams on data transformation and integration.
• Strong stakeholder engagement and requirement‑gathering expertise.

We're excited to meet people who share our mission and can make an impact in a variety of ways. Don’t hesitate to apply, even if you only meet the minimum requirements listed. Think about your transferable experiences and unique skills that make you stand out as someone who can bring new and exciting things to this role.