Capgemini is seeking a Senior Data Engineer to design, build, optimize, and maintain scalable cloud-based data platforms with strong Snowflake expertise. In this role, you will coordinate with business stakeholders and engineering teams to deliver dependable, high-performance data solutions across reporting, analytics, and advanced data initiatives.
Key Responsibilities
- Design, develop, and maintain scalable data pipelines and data integration solutions.
- Build and optimize data warehouse solutions using Snowflake.
- Create ETL/ELT processes to ingest, transform, and load data from multiple source systems.
- Apply data modeling approaches, including dimensional modeling and star schema design.
- Optimize Snowflake performance, storage usage, and cost management.
- Maintain 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 reinforce data engineering best practices.
- Participate in architecture reviews and technology evaluations.
Required Qualifications
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field.
- 5+ years of experience in Data Engineering, Data Warehousing, or BI Engineering.
- 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, including 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
Location
Houston, TX (onsite)
Compensation
The base compensation range for this role in the posted location 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.
Benefits
- Paid time off based on employee grade (A-F) per company policy: Vacation 12-25 days depending on 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 a 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.