Skip to main content

dbt Data Engineer / Developer (Snowflake)

00070498321

Role Overview:

We are looking for a hands-on dbt Data Engineer / Developer to build, test, and maintain scalable ELT transformation pipelines using dbt, SQL, Snowflake, and modern cloud data platforms.

· Design, develop, and maintain dbt models for staging, intermediate, and mart layers.

· Build ELT pipelines using SQL, dbt, and Snowflake, including staging, transformation, and data mart layers; exposure to Databricks, BigQuery, Redshift, or Azure Synapse is an added advantage.

· Implement dbt tests, documentation, source freshness checks, snapshots, and reusable macros.

· Optimize SQL queries and dbt models for performance, reliability, and maintainability.

· Work with analysts, business users, and senior data engineers to translate requirements into data models and transformation logic.

· Support Git-based development, pull requests, code reviews, CI/CD deployments, and environment management.

· Exposure to legacy data warehouse migration or modernization initiatives, preferably involving Teradata to Snowflake migration, including support for SQL conversion, data validation, reconciliation, and defect fixes.

· Troubleshoot pipeline failures, data quality issues, and production defects in collaboration with platform and support teams.

Required Skills and Experience:

· Strong experience in data engineering, ETL/ELT development, analytics engineering, or data warehousing.

· Strong hands-on experience with dbt Core or dbt Cloud.

· Advanced SQL skills with experience in complex transformations and performance tuning.

· Good understanding of dimensional modelling, star schema, data marts, and warehouse concepts.

· Hands-on experience with Snowflake, including SQL development, warehouse usage, schemas, tables, views, access roles, and performance-aware query design.

· Good understanding of Snowflake objects such as databases, schemas, virtual warehouses, stages, file formats, streams, tasks, and secure views.

· Good understanding or hands-on exposure to Teradata concepts, SQL, data warehouse objects, BTEQ scripts, stored procedures, views, and migration activities from Teradata to Snowflake.

· Experience supporting migration testing, source-to-target validation, record count checks, data quality checks, and comparison of migrated data between Teradata and Snowflake.

· Good-to-have exposure to mainframe data sources, including COBOL copybooks, VSAM files, DB2 on z/OS, JCL, batch files, flat files, and mainframe-to-cloud data extraction patterns.

· Experience with Git, branching strategies, pull requests, and code review processes.

· Strong analytical, problem-solving, communication, and team collaboration skills.

#LI-1_MS1

Things to know before you apply

  • Work authorization: Cognizant will only consider applicants for this position who are legally authorized to work in Canada without requiring employer sponsorship, now or at any time in the future.
  • Accommodations: If you have a disability that requires reasonable accommodation to search for a job opening or submit an application, please email [email protected] with your request and contact information.
  • AI in hiring: We use artificial intelligence (AI) tools to help us screen and assess applications more efficiently. Our team performs additional human review and ultimately decides who moves forward in our hiring process.
  • Open position: Unless otherwise stated, this job posting is for an open position on our team.
  • Language proficiency: We ask that all candidates have basic English proficiency for company-wide communications purposes. For roles based in Quebec, professional English proficiency is required, as you’ll deliver services to and collaborate with stakeholders outside the province who may not speak French.
  • Inclusion: Cognizant is an equal opportunity employer. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other characteristic protected by federal, provincial or local laws.

About Cognizant
Cognizant (Nasdaq: CTSH) is an AI Builder and technology services provider, bridging the gap between AI investment and enterprise value by building full-stack AI solutions for our clients. Our deep industry, process and engineering expertise enables us to build an organization’s unique context into technology systems that amplify human potential, drive tangible outcomes and keep global enterprises ahead in a fast-changing world. See how at cognizant.ai or @cognizant.

Benefits that help you thrive and grow

Our benefits program is built with you in mind—so you can enjoy a fulfilling, balanced and healthy life.

a blue line drawing of a plant with leaves

Financial wellbeing

We regularly review market data to ensure compensation reflects the value you bring. Your benefits extend beyond pay and may include financial education, a pension plan with matching contributions, etc.

Stay Healthy Midnight Blue RGB

Physical and mental health

We empower you to prioritize your wellbeing through paid time off, flexible working where possible, healthcare plans, counselling, our Mental Health Allyship program and more. 

Build The Career You Want Midnight Blue RGB

Your career, your way

With 350,000+ roles at Cognizant, you’ll have opportunities explore new technologies, industries and locations—and build the skills you need to grow your career.

Making A Meaningful Impact Midnight Blue RGB

Real-world impact

Think about the biggest brands you rely on. Chances are, they rely on us to help strengthen their business. Here, you’ll turn bold ideas into solutions that improve lives everywhere.

Your path to Cognizant

Here’s what you can expect from our hiring process. Please keep in mind that it may vary by role and location. Explore our FAQs to learn more.

a person sitting at a table using a laptop

Step 1: Apply to the right opportunity

Find an open role that matches your skills and career goals and show us why you’re the person for the job. Don’t see the right opportunity? Consider joining our Talent Community.

a person holding a tablet and talking on the phone

Step 2: Connect with your recruiter

If one of our recruiters sees a fit, they’ll set up a short intro call to learn more about you and how your experiences and skills match the role.

a person smiling at a table with a laptop

Step 3: Show off your skills

If you and our team would like to continue the process, you’ll interview with our hiring team. Some roles may also require technical assessments and/or client interviews.

a group of people sitting around a table

Step 4: Decision time

Our team will then review each candidates’ potential to succeed in the role. This step may take some time because we want to find the right fit for both you and us—but you can count on us to keep you updated.

CAN Brigitte
Cognizant is great for those wanting to make the world a better place, as we create solutions with top technology partners to address complex problems for our clients.
Brigitte Roy Director of Strategy Alliances
CAN Rahul
I’m supported by motivational leaders who empower me to grow in my career through learning programs, industry conferences and internal job moves. I’m proud of the career progression I’m making here.
Rahul Sathe Principal Product Architect – Insurance
Can Amita
The moment I joined Cognizant, I felt like I belonged. I was heard and empowered to challenge ideas—and I still am to this day.
Dr. Amita Oppal Gill Service Line Sales Manager
a person in a blue jacket
Cognizant has one of the best learning ecosystems you can ask for. From sponsored certifications to training platforms to mentorship, we have all that we need to grow.
Debashish Mishra SAP MM Developer

Haven't yet found the right opportunity?

Get the latest updates on job opportunities, recruitment events and company news—tailored just for you!

Be in the know