Senior Data Engineer: Data Quality & Forensics

dermalogica; Seattle (WA); Hybrid; USD 70,000 - 80,000; Full time

Job summary

Dermalogica seeks a senior data engineer to strengthen data quality and forensics across our global data environment. You will identify root causes, fix underlying issues, and implement controls to prevent recurrence in ERP, e-commerce, and cloud data warehousing environments.

This role involves owning a backlog of data quality issues, auditing SQL jobs, and collaborating with IT, Finance, and external partners to ensure accurate reporting and trusted analytics in a hybrid/remote setup.

Qualifications

• Strong analytical and forensic problem-solving skills.
• Clear written and verbal communication skills.
• Ability to work independently and drive issues to resolution.
• Skeptical mindset with attention to data integrity.

Responsibilities

• Investigate and root-cause data discrepancies across source systems, databases, integrations, data warehouses, and reporting layers.
• Trace data end-to-end to understand transformations and business rules causing incorrect results.
• Own a backlog of data quality issues from investigation through remediation and closure.
• Audit SQL jobs, stored procedures, ETL processes, and data dependencies for reliability.
• Identify and eliminate hardcoded rules, silent failures, and incomplete loads.
• Recover and backfill historical data and reconcile with source systems.
• Improve master-data mappings and automated reconciliation, health checks, and alerting.

Job description

Dermalogica seeks a senior data engineer to strengthen data quality and forensics across our global data environment. You will identify root causes, fix underlying issues, and implement controls to prevent recurrence in ERP, e-commerce, and cloud data warehousing environments.

This role involves owning a backlog of data quality issues, auditing SQL jobs, and collaborating with IT, Finance, and external partners to ensure accurate reporting and trusted analytics in a hybrid/remote setup.