Data Engineer

Capgemini is hiring a Data Engineer on a contract basis in Hanover, NH (onsite). In this role, you’ll design and support enterprise data solutions, build scalable ETL/ELT pipelines, and enable reliable conversion and operational analytics across Salesforce and related partner systems.

• Design, build, test, and support scalable ETL/ELT pipelines for data conversion and future Connected onboarding analytics activities.
• Develop reusable source-to-target transformation utilities
  , including data cleansing, validation, reconciliation, exception handling, and controlled data loads.
• Create data utilities and curated datasets that can be consumed by Connected and related capabilities.
• Write, optimize, and maintain advanced SQL and Python 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 Standard/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.
• Identify root causes and business impact by analyzing recurring Salesforce data failure patterns and connecting them with Middle and Back Office data.

• 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.

• Partner with 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.
• Perform code reviews and contribute to CI/CD
  , version control, testing, deployment, documentation, and engineering standards.
• Ensure solutions comply with enterprise data governance, security, privacy, lineage, and quality standards.
• Participate in Agile delivery and continuous improvement; mentor junior team members as appropriate.

• Bachelor’s degree in Computer Science, Information Systems, Engineering, Data Science, or related field, or an equivalent education/experience combination.
• 5+ years designing and developing enterprise data solutions, including production ETL/ELT pipelines and large-scale data integration.
• Hands-on experience with Salesforce data
  , including standard/custom objects, relationships, data extraction, reporting, and schema-level analysis.
• Strong SQL development, data analysis, and query optimization skills.
• 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…