Cognizant (NASDAQ: CTSH) is a leading provider of information technology, consulting, and business process outsourcing services, dedicated to helping the world's leading companies build stronger businesses. Headquartered in Teaneck, New Jersey (U.S.). Cognizant is a member of the NASDAQ-100, the S&P 500, the Forbes Global 1000, and the Fortune 500 and we are among the top performing and fastest growing companies in the world.
This role is not eligible for candidates who require visa sponsorship now or in the near future.
Title: Snowflake DBT Architect with Fivetran experience
Onsite – Oak Park Height MN / Hybrid - T, W, TResponsibilities:
Job Summary
We are seeking a highly skilled Data Engineer with strong expertise in Snowflake, dbt Cloud, and scalable data pipeline development. The ideal candidate will have a solid foundation in data modeling, SQL, DevOps practices, and cross‑functional collaboration within an agile environment. This role is critical for designing reliable data solutions that support analytics, reporting, and strategic business initiatives.
Key Responsibilities
1. Data Modeling
- Design, test, and maintain conceptual, logical, physical, and dimensional (star/snowflake) data models.
- Develop analytical data structures optimized for business intelligence and reporting.
- Improve data performance through partitioning, indexing, and SQL best practices.
- Conduct peer code reviews to ensure quality, accuracy, and consistency across data models.
2. Data Pipeline Development & Orchestration
- Design, build, and optimize scalable and resilient ETL/ELT data pipelines.
- Use orchestration tools for scheduling, dependency management, error handling, and workflow optimization.
- Work extensively with dbt Cloud for transformation logic, testing, documentation, and deployment.
- Conduct UAT, troubleshoot data issues, and manage code releases for seamless end‑to‑end data flow.
- Demonstrate strong SQL mastery for transformations, performance tuning, and troubleshooting.
3. DevOps & Code Management
- Leverage version control tools such as Azure DevOps and GitHub for collaborative development.
- Maintain best practices in branching, merging, CI/CD pipelines, and release management.
4. Monitoring & Observability
- Implement logging, metrics, monitoring, and alerting frameworks to ensure pipeline reliability.
- Proactively detect and resolve failures, performance bottlenecks, and data quality issues.
5. Collaboration & Communication
- Work closely with data analysts, data engineers, product owners, and solution architects.
- Translate business needs into scalable data solutions aligned with organizational goals.
- Communicate technical concepts to both technical and non‑technical stakeholders.
6. Agile Ways of Working
- Participate actively in agile ceremonies including standups, sprint planning, retrospectives, and demos.
- Apply agile principles to iterate quickly, adapt to change, and contribute to continuous improvement.
Required Skills & Qualifications
- Strong hands‑on experience with Snowflake and dbt Cloud.
- Advanced SQL skills with proven experience in analytical and performance‑optimized queries.
- Experience building and maintaining ETL/ELT pipelines in a cloud environment.
- Solid understanding of data warehouse concepts, dimensional modeling, and metadata management.
- Familiarity with orchestration tools (e.g., Airflow, Azure Data Factory, Prefect—customize if needed).
- Proficiency with Git-based version control, CI/CD principles, and DevOps workflows.
- Excellent communication, collaboration, and problem‑solving skills.
Preferred Qualifications
- Experience with Cloud platforms (Azure, AWS, or GCP).
- Exposure to monitoring/observability tools (Datadog, CloudWatch, Snowflake Query History, etc.).
- Knowledge of agile frameworks such as Scrum or Kanban.
- Background in analytics, BI tools, or data governance.
Application Accepted: 2/25/2026
This position is also eligible for Cognizant’s discretionary annual incentive program, based on performance and subject to the terms of Cognizant’s applicable plans.
Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:
- Medical/Dental/Vision/Life Insurance
- Paid holidays plus Paid Time Off
- 401(k) plan and contributions
- Long-term/Short-term Disability
- Paid Parental Leave
- Employee Stock Purchase Plan
Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.
Our strength is built on our ability to work together. Our diverse backgrounds offer different perspectives and new ways of thinking. It encourages lively discussions, creativity, productivity, and helps us build better solutions for our clients. We want someone who thrives in this setting and is inspired to craft meaningful solutions through true collaboration.
If you are content with ambiguity, excited by change, and excel through autonomy, we’d love to hear from you!
The Cognizant community:
We are a high caliber team who appreciate and support one another. Our people uphold an energetic, collaborative and inclusive workplace where everyone can thrive.
- Cognizant is a global community with more than 300,000 associates around the world.
- We don’t just dream of a better way – we make it happen.
- We take care of our people, clients, company, communities and climate by doing what’s right.
- We foster an innovative environment where you can build the career path that’s right for you.
About us:
Cognizant is one of the world's leading professional services companies, transforming clients' business, operating, and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build, and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant (a member of the NASDAQ-100 and one of Forbes World’s Best Employers 2025) is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital at www.cognizant.com
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, state or local laws.
Disclaimer:
Compensation information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.