We are seeking a Senior Data Engineer who is able to provide end-to-end technical leadership for the enterprise Customer Data Platform (CDP) in Snowflake, including architecture, engineering standards, solution design, delivery governance, capacity planning, modernization, and platform quality. The role converts complex marketing, analytics, privacy, and customer-data needs into scalable Snowflake-based solutions. The Technical Lead is the primary technical decision-maker for CDP enhancements and must balance new demand against committed work, resource capacity, platform dependencies, and technical debt. The client is highly AI-forward; this role must aggressively champion responsible use of AI-assisted engineering, Snowflake Cortex, automation, and reusable patterns that improve speed and quality.
Your role
- Own CDP solution architecture across Snowflake, dbt, Matillion, Fivetran, AWS S3, and Control-M.
- Lead technical discovery and convert business requirements into architecture decisions, data models, integration patterns, and implementation plans.
- Perform impact analysis for new requests, including effects on sprint commitments, upstream and downstream dependencies, operating costs, and delivery capacity.
- Review and approve logical and physical data models, dbt designs, Matillion workflows, orchestration approaches, and release plans.
- Establish coding, testing, observability, security, privacy, and documentation standards for engineering teams.
- Guide source onboarding, data-product design, identity and customer-data use cases, audience activation, and reporting enablement.
- Lead performance tuning, scalability planning, cost optimization, and remediation of recurring technical issues.
- Partner with Product Management and the Delivery Lead on estimates, sequencing, staffing, risks, and roadmap trade-offs.
- Mentor senior and mid-level engineers, conduct design reviews, and raise engineering maturity.
- Champion AI-assisted development and identify work that can be accelerated or automated using copilots, Cortex, agents, testing automation, or metadata-driven patterns.
- Coordinate with Analytics, Data Science, Privacy, Campaign Technology, EDM, and governance teams.
- Serve as escalation point for high-severity production defects requiring engineering intervention.'
Skills and experience
- Strong Snowflake expertise with experience in architecture, solution design, performance tuning, scalability, and cost optimization.
- Hands-on experience with CDP/Data Platform technologies, including dbt, Matillion, Fivetran, AWS S3, and Control-M.
- Technical leadership experience leading architecture decisions, technical discovery, and translating business requirements into scalable solutions.
- Data modeling and integration expertise, including logical/physical data models, ETL/ELT processes, and customer data management.
- Team leadership and stakeholder management, including mentoring engineers, conducting design reviews, and partnering with product and business teams.
- AI and automation mindset, with exposure to Snowflake Cortex, Copilot, AI-assisted development, and process automation.
The base compensation range for this role in the posted location is: $145,000 - $175,000.
Capgemini provides compensation range information in accordance with applicable national, state, provincial, and local pay transparency laws. The base compensation range listed for this position reflects the minimum and maximum target compensation Capgemini, in good faith, believes it may pay for the role at the time of this posting. This range may be subject to change as permitted by law.
The actual compensation offered to any candidate may fall outside of the posted range and will be determined based on multiple factors legally permitted in the applicable jurisdiction.
These may include, but are not limited to: Geographic location, Education and qualifications, Certifications and licenses, Relevant experience and skills, Seniority and performance, Market and business consideration, Internal pay equity.
It is not typical for candidates to be hired at or near the top of the posted compensation range.
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.
Capgemini offers a comprehensive, non-negotiable benefits package to all regular, full-time employees. In the U.S. and Canada, available benefits are determined by local policy and eligibility and may include:
- 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 (e.g., 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
