Skill: Snowflake DBT
Exp: 6 to 12 years
Location: Pune
Key Responsibilities:
Snowflake & DBT Development
- Design, develop, and maintain DBT models across staging, intermediate, and mart layers, following modular architecture and industry best practices.
- Create and manage DBT assets including tests, documentation, sources, macros, and packages.
- Build scalable, reusable, and maintainable data transformation frameworks.
Data Pipeline Engineering
- Design, develop, and optimize ELT pipelines using DBT integrated with orchestration tools such as Airflow, Dagster, or Prefect.
- Work extensively with AWS and Snowflake-based cloud data platforms.
- Develop, maintain, and tune Snowflake schemas, virtual warehouses, and SQL workloads for optimal performance.
- Ensure efficient execution of data transformations and analytical queries across the data warehouse.
Data Quality, Security & Governance
- Implement and maintain data quality validations within DBT, including uniqueness, null checks, and referential integrity testing.
- Contribute to source control, CI/CD processes, documentation standards, and engineering best practices.
- Establish monitoring, alerting, and failure-handling mechanisms to ensure pipeline reliability.
- Enforce Snowflake security controls such as RBAC, secure views, and cost/performance optimization strategies.
Collaboration & Stakeholder Engagement
- Partner with business stakeholders, analysts, and data consumers to gather requirements and translate them into scalable data models.
- Deliver well-documented, user-friendly datasets and maintain comprehensive DBT documentation.
- Participate in peer code reviews and provide technical mentorship and engineering guidance to team members.
Required Experience & Qualifications
- 3+ years of experience in Data Engineering, Data Warehousing, or ELT development.
- Strong expertise in writing and optimizing complex SQL queries.
- Minimum 2 years of hands-on experience with DBT Cloud in a production environment.
- Proven experience working with AWS-based data ecosystems and Snowflake data warehousing solutions.
- Solid understanding of Git, CI/CD pipelines, and modern data stack practices.
- Strong knowledge of dimensional modeling methodologies, including Kimball, Data Vault, Star Schema, and Snowflake Schema designs.
- Experience integrating DBT with orchestration platforms such as Airflow, Dagster, or Prefect.
What we offer
- The chance to work with impact. Here, you’re empowered to bring your biggest thinking to help our company and clients improve everyday life.
- Ownership over your career. Stay at the top of your game through our award-winning learning and development ecosystem. And when your ambitions change or we offer new opportunities, we help you pivot by providing reskilling, on-the-job learning and guidance to find new roles that might be a better fit.
- The opportunity to thrive on a high caliber team with heart. We celebrate each other’s experiences and perspectives and promote a sense of belonging through our affinity groups and diversity and inclusion initiatives.
- A comprehensive total rewards package, including a competitive salary and a pension plan with matching contributions.
- Flexible health and financial benefits to support you and your eligible dependents—from day one.
- True work-life balance. Be at your best through paid time off, flexible work arrangements, volunteering opportunities, social events, and so much more.
About us
Cognizant (Nasdaq: CTSH) is an AI Builder and technology services provider, building the bridge 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, realize tangible returns and keep global enterprises ahead in a fast-changing world. See how at www.cognizant.com or @cognizant.
Other employment-related information
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.
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.
Language requirements vary depending on roles, but 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.
