Data Engineer

Capgemini is hiring a Data Engineer for a contract role based in Hanover, NH (onsite). In this position, you will design, develop, and support enterprise data solutions, with a focus on scalable ETL/ELT pipelines that enable reliable data conversion and operational analytics across Salesforce and partner systems.

What you’ll do

• Design, build, test, and support scalable ETL/ELT pipelines for data conversion and future Connected onboarding analytics.
• Create reusable utilities to support source-to-target transformation, data cleansing, validation, reconciliation, exception handling, and controlled data loads.
• Develop data utilities and curated datasets that can be consumed by Connected and related capabilities.
• Write, optimize, and maintain advanced SQL, Python, and data-processing code across enterprise data platforms.
• Support conversion rehearsals, cutover, hypercare, defect analysis, and post-production reconciliation.
• Analyze Salesforce object data, including schema, relationships, record lifecycle, and data dependencies to support conversion, reporting, and production issue analysis.
• Partner with Salesforce Administrators and Product Owners to build advanced Salesforce reports and custom report types for operational and leadership metrics.
• Trace failures across Salesforce Standard and Custom objects and processes using Salesforce data knowledge.
• Assess downstream impact of data and schema changes, then translate findings into data requirements, controls, and reporting solutions.
• Analyze recurring data failure patterns and connect Salesforce failures with Middle and Back Office data to identify root causes, trends, and business impact.
• Build Tableau dashboards, scorecards, and analytical datasets for IS leadership and business stakeholders.
• Develop proactive alerts, monitoring reports, data-quality controls, reconciliation views, and exception reporting.
• Quantify impacted records, users, transactions, customers, and business processes to support defect triage and data-driven prioritization.
• Monitor pipeline and data-product performance, troubleshoot production issues, and support data-delivery service levels.
• Collaborate across architects, Product Owners, IS teams, business analysts, data teams, integration teams, Salesforce Administrators, and reporting teams to deliver end-to-end solutions.
• Develop and support cloud data warehouse and data lake solutions using dimensional modeling and data warehousing best practices.
• Conduct code reviews and contribute to CI/CD, version control, testing, deployment, documentation, and engineering standards.
• Ensure solutions align with enterprise data governance, security, privacy, lineage, and quality standards.
• Participate in Agile delivery, continuous improvement, and knowledge-sharing, including mentoring junior team members as appropriate.

Minimum qualifications

• 5+ years designing and developing enterprise data solutions, including production ETL/ELT pipelines and large-scale data integration.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, Data Science, or a related field, or an equivalent combination of education and experience.
• Hands-on experience with Salesforce data, including standard and custom objects, object relationships, data extraction, reporting, and schema-level analysis.
• Strong skills in SQL development, data analysis, and query optimization.
• Experience with Snowflake or a comparable modern cloud data platform.
• Experience with Matillion or similar cloud-based integration and ELT technologies.
• Experience with Python or another modern programming language for automation, data processing, and reconciliation.
• Experience building operational reports, analytical datasets, dashboards, monitoring, or alerting solutions.
• Experience partnering with Product, application, technical, and business stakeholders in an Agile delivery environment.

Technologies

• Snowflake, Salesforce, SQL, APIs
• ETL/ELT, Matillion
• DevOps & CI/CD, Git
• Tableau, Python
• Data validation, data warehousing, data lakes, dimensional modeling

Contract details and location

• Location: Hanover, NH, United States (onsite)
• Job type: contract
• Compensation: USD 48 - 75 per hourly

Benefits

• Medical, dental, vision and retirement benefits

Preferred qualifications

• Experience supporting Salesforce-based enterprise applications, data migrations, conversions, or production operations.
• Experience creating advanced Salesforce reports and collaborating with Salesforce Administrators on custom report types.
• Experience with Tableau dashboard development, data-source design, and leadership reporting.
• Experience integrating Salesforce data with Middle Office, Back Office, ERP, finance, onboarding, or operational platforms.
• Snowflake architecture and performance tuning; familiarity with Matillion, dbt, Informatica, or comparable ELT platforms.
• Knowledge of Salesforce APIs, Bulk API, data-loader patterns, change-data-capture concepts, or enterprise integration patterns.
• Experience implementing automated data-quality checks, reconciliation frameworks, proactive monitoring, and alerting.
• Familiarity with cloud data services, AI/ML data engineering concepts, and enterprise data governance practices.
• Foundational knowledge of Salesforce Data Cloud, including data ingestion, harmonization, identity resolution, and data activation concepts.

Core competencies

• Critical thinking and structured problem solving
• Clear communication with technical and business audiences
• Cross-functional relationship building
• Accountability and ownership
• Results orientation and delivery discipline
• Ability to manage complexity and ambiguity
• Situational adaptability and continuous improvement mindset