Capgemini · 2 months ago
Snowflake Data Engineer - DBT
New York, United States
Full-time
Onsite
Mid Level
$80K/yr - $106K/yr
3+ years expCapgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world. They are seeking a Data Engineer with expertise in DBT, Snowflake, and PL/SQL to design, develop, and maintain data transformation pipelines that support business intelligence and analytics initiatives.
ConsultingInformation TechnologyInsurTechIT ManagementSoftware
Responsibilities
Design and implement scalable data models and transformation pipelines using DBT on Snowflake
Write efficient and maintainable PL/SQL code for complex data processing and transformation tasks
Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and deliver high-quality solutions
Optimize Snowflake performance through query tuning, clustering, and resource management
Ensure data quality, integrity, and governance through testing, documentation, and monitoring
Participate in code reviews, architecture discussions, and continuous improvement initiatives
Maintain and enhance CI/CD pipelines for DBT projects
Qualification
Required
3+ years of experience in data engineering or a related field
Strong hands-on experience with DBT (modular SQL development, testing, documentation)
Proficiency in Snowflake (data warehousing, performance tuning, security)
Advanced knowledge of PL/SQL and experience with stored procedures, functions, and packages
Solid understanding of data modeling concepts (star/snowflake schemas, normalization)
Experience with version control systems (e.g., Git) and CI/CD practices
Preferred
Familiarity with orchestration tools (e.g., Airflow, dbt Cloud, Prefect) is a plus
Benefits
Flexible work
Healthcare including dental, vision, mental health, and well-being programs
Financial well-being programs such as 401(k) and Employee Share Ownership Plan
Paid time off and paid holidays
Paid parental leave
Family building benefits like adoption assistance, surrogacy, and cryopreservation
Social well-being benefits like subsidized back-up child/elder care and tutoring
Mentoring, coaching and learning programs
Employee Resource Groups
Disaster Relief
Company
Capgemini
Capgemini is a software company that provides consulting, technology, and digital transformation services.
10001+ employees
H1B Sponsorship
Capgemini has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2856)
2024 (3012)
2023 (3424)
2022 (4392)
2021 (3311)
2020 (5871)
Funding
Current Stage
Public CompanyTotal Funding
$4.72B2025-09-18Post Ipo Debt· $4.72B
1999-04-01IPO
Leadership Team
Aiman Ezzat
CEO, Capgemini Group
Anirban Bose
CEO of Americas Strategic Business Unit
Recent News
2026-01-08
2026-01-06
2026-01-05
Company data provided by crunchbase