Senior Data Engineer - Data Quality & Forensics (Hybrid/Remote)

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

Job summary

Dermalogica LLC is seeking a senior, hands-on data engineer to strengthen our global data environment. You will investigate data discrepancies across ERP, e-commerce, marketplace data, and SQL Server, tracing data end-to-end from source to reporting.

The role focuses on root-cause analysis, durable fixes, and automated controls. You will work in a hybrid/remote setup with strong Pacific Time overlap, collaborating with IT, Finance, and external partners.

Qualifications

• 7+ years of hands-on data engineering, database engineering, or closely related experience in production environments.
• Strong understanding of ETL/ELT pipelines, system integrations, database dependencies, and data warehouse architecture.
• Experience with data observability and automated reconciliation or data-quality monitoring.

Responsibilities

• Investigate and root-cause data discrepancies across source systems, databases, integrations, data warehouses, and reporting layers.
• Trace data end-to-end to understand where transformations and rules produce incorrect results.
• Own a backlog of data quality issues from investigation through remediation and closure.
• Audit SQL jobs, stored procedures, ETL processes, dependencies, and transformation logic to identify fragile or undocumented behavior.
• Identify and eliminate hardcoded business rules and recurring data quality problems.
• Replace fragile manual data processes with governed, scheduled pipelines where appropriate.
• Build automated reconciliation, feed-health checks, and alerting for data failures.

Skills

Data engineering

Data quality

Problem solving

Independent work

Analytical thinking

Tools

SQL Server

SSIS

SQL Agent

BigQuery

Cloud data warehouse

Job description

Dermalogica LLC is seeking a senior, hands-on data engineer to strengthen our global data environment. You will investigate data discrepancies across ERP, e-commerce, marketplace data, and SQL Server, tracing data end-to-end from source to reporting.

The role focuses on root-cause analysis, durable fixes, and automated controls. You will work in a hybrid/remote setup with strong Pacific Time overlap, collaborating with IT, Finance, and external partners.