Data Engineer - Snowflake
Job Description
Capgemini is building cloud-based data platforms that help teams move from data to decisions. In this onsite role in Houston, TX, you will design and deliver reliable, high-performance data solutions that support reporting, analytics, and advanced data initiatives. You will work with business stakeholders and engineering teams while focusing on strong Snowflake expertise and scalable platform engineering.
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 multiple source systems.
- Apply data modeling techniques such as dimensional modeling and star schema design.
- Optimize Snowflake performance, storage, and cost management.
- Ensure data quality, integrity, governance, and security across the data platform.
- Partner 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.
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
- 5+ years of experience in Data Engineering, Data Warehousing, or BI Engineering.
- 3+ years of hands-on Snowflake experience.
- Strong SQL development skills, including query optimization.
- 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.
Technologies
Snowflake, SQL, ETL, ELT, Cortex, Natural language querying, Semantic search, Document processing, Text analytics, Generative AI, Python, AWS, Azure, Google Cloud Platform
Benefits
- Paid time off based on employee grade (A-F), defined by policy: Vacation 12-25 days depending on grade, Company paid holidays, Personal Days, Sick Leave
- Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
- Retirement savings plans (for example, 401(k) in the U.S., RRSP in Canada)
- Life and disability insurance
- Employee assistance programs
- Other benefits as provided by local policy and eligibility
Compensation
The base compensation range for this role in Houston, TX is $76,730 - $150,800 per year.
In addition to base salary, this role may be eligible for additional compensation such as variable incentives, bonuses, or commissions, depending on the position and applicable laws.