Data Engineer

The Data Engineer designs, develops, and supports enterprise data solutions for data conversion, operational analytics, and production monitoring.

The role combines core enterprise data engineering expertise with hands‑on knowledge of the Salesforce data model and a foundational understanding of Salesforce schema, objects, relationships, and reporting.

This position partners closely with Application Product Owners, IS teams, architects, Salesforce administrators, and business stakeholders to deliver reliable conversion pipelines, reusable data utilities, leadership reporting, Tableau dashboards, and proactive insights across Salesforce and partner systems (Middle and Back Office).

Design, build, test, and support scalable ETL/ELT pipelines for data conversion and future Connected - onboarding systems analytics activities.

Develop reusable utilities for source-to-target transformation, 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, 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 support conversion, reporting, and production issue analysis.

Work with Salesforce Administrators and Product Owners to build advanced Salesforce reports and custom report types that support operational and leadership metrics.

Use Salesforce data knowledge to trace failures across various Standard/Custom objects and processes.

Assess the downstream impact of data and schema changes and translate findings into data requirements, controls, and reporting solutions.

Analyze recurring data failure patterns in Salesforce and connect them 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.

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.

Conduct 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, technical design, continuous improvement, and knowledge-sharing activities; mentor junior team members as appropriate.

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 working with Salesforce data, including standard and custom objects, object relationships, data…