Data Engineer

Capgemini is seeking a Data Engineer to design, build, and support enterprise data solutions with a focus on scalable ETL/ELT pipelines. This onsite contract role in Hanover, NH partners with Salesforce and IS stakeholders to deliver reliable data conversion capabilities, operational analytics, monitoring, and reporting.

Key Responsibilities

• Design, build, test, and support scalable ETL/ELT pipelines for data conversion and future Connected onboarding analytics activities.
• Create reusable source-to-target utilities for transformation, data cleansing, validation, reconciliation, exception handling, and controlled data loads.
• Develop data utilities and curated datasets that support 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, schema, relationships, record lifecycle, and data dependencies to enable conversion support, reporting, and production issue analysis.
• Collaborate with Salesforce Administrators and Product Owners to deliver advanced Salesforce reports and custom report types for operational and leadership metrics.
• Use Salesforce data knowledge to trace failures across Standard and Custom objects and associated processes.
• Assess downstream impacts from data and schema changes and translate findings into data requirements, controls, and reporting solutions.
• Identify root causes by analyzing recurring Salesforce data failure patterns and connecting them with Middle and Back Office data to determine trends and business impact.
• Build Tableau dashboards, scorecards, and analytical datasets for IS leadership and business stakeholders.
• Implement 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 align with enterprise data governance, security, privacy, lineage, and quality standards.
• Participate in Agile delivery, technical design, continuous improvement, and knowledge-sharing; mentor junior team members as appropriate.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, Data Science, or a related field, or an equivalent combination of education and experience.
• 5+ years of experience designing and developing enterprise data solutions, including production ETL/ELT pipelines and large-scale data integration.
• Hands-on experience with Salesforce data, including standard and custom objects, object 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 solutions.
• Experience partnering with Product, application, technical, and business stakeholders within an Agile delivery environment.

Technologies

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

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.
• Experience with Snowflake architecture and performance tuning; 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.

Technical Skills

• Salesforce data model, schema, objects, relationships, reporting, and data extraction
• Snowflake and advanced SQL development and optimization
• Matillion or comparable ETL/ELT tools
• Python and data automation
• Tableau and analytical data-source design
• Data warehousing, data lakes, and dimensional modeling
• Data integration, APIs, and batch-processing patterns
• Data conversion, migration, reconciliation, validation, and exception handling
• Production monitoring, alerting, and root-cause analysis
• CI/CD, Git, testing, and DevOps practices
• Data quality, lineage, governance, security, and privacy

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

Role Details

Location: Hanover, NH, United States (onsite)

Employment Type: contract

Compensation: USD 48 - 75 per hourly

Minimum Experience: 5 years