Data Engineer - Snowflake

Capgemini • Houston, TX

1d • $76,730 - $150,800

About The Position

Capgemini is seeking a Senior Data Engineer to design, build, optimize, and maintain scalable cloud-based data platforms. The role focuses on Snowflake, modern data warehousing, ETL/ELT development, cloud technologies, and data modeling. The engineer will work with business stakeholders, analysts, data scientists, and engineering teams to deliver reliable, high-performance solutions for reporting, analytics, and advanced data initiatives. The position also includes designing AI-enabled data solutions in Snowflake using Cortex capabilities.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.
• At least 5 years of experience in Data Engineering, Data Warehousing, or BI Engineering.
• At least 3 years of hands-on Snowflake experience.
• Strong SQL development and query optimization skills.
• Experience building large-scale ETL/ELT pipelines.
• Ability to design and implement AI-enabled data solutions within Snowflake using Cortex capabilities for natural language querying, semantic search, document processing, text analytics, and generative AI applications.
• Experience with cloud platforms such as AWS, Azure, or Google Cloud Platform.
• Proficiency in Python for data engineering and automation.
• Experience with data modeling and warehouse design.
• Strong understanding of data quality, data governance, and security principles.

Responsibilities

• Design, develop, and maintain scalable data pipelines and data integration solutions.
• Build and optimize data warehouse solutions using Snowflake.
• Develop ETL/ELT processes to ingest, transform, and load data from various source systems.
• Implement data modeling techniques, including dimensional modeling and star schema design.
• Optimize Snowflake performance, storage, and cost management.
• Ensure data quality, integrity, governance, and security across the data platform.
• Collaborate with business users, analysts, and architects to gather requirements and deliver data solutions.
• Troubleshoot and resolve data pipeline and performance issues.
• Support CI/CD deployment processes and infrastructure automation.
• Mentor junior engineers and promote data engineering best practices.
• Participate in architecture reviews and technology evaluations.

Benefits

• Paid time off, including vacation (12–25 days depending on employee grade), company-paid holidays, personal days, and sick leave.
• Medical, dental, and vision coverage, or provincial healthcare coordination in Canada.
• Retirement savings plans, such as 401(k) in the U.S. or RRSP in Canada.
• Life and disability insurance.
• Employee assistance programs.
• Other benefits as provided by local policy and eligibility.
• The role may be eligible for variable incentives, bonuses, or commissions, depending on the position and applicable laws.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior