Senior Data Engineer: Data Quality & Systems Forensics

Dermalogica LLC; Carson (CA); Hybrid; USD 70,000 - 80,000; Full time

Job summary

Dermalogica LLC seeks a senior, hands-on data engineer to strengthen the global data environment. You will investigate complex systems, fix root causes, and implement controls to prevent recurrence across ERP, e-commerce, and data warehousing layers.

You will inherit a backlog of data quality and integration issues, perform end-to-end data tracing, and drive remediation through to closure in a hybrid/remote setup with strong Pacific Time overlap.

Qualifications

• : Seven plus years of hands-on data engineering in production environments.

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 prioritized backlog of data quality issues from investigation through remediation and closure.
• Audit SQL jobs, stored procedures, ETL processes, dependencies, and transformation logic for fragility.
• Identify and eliminate hardcoded rules, silent failures, and incomplete loads.
• Replace fragile manual data processes with governed, automated pipelines where appropriate.
• Build automated reconciliation and alerting to detect data failures quickly.
• Document critical data lineage, dependencies, transformations, and ownership.

Skills

Data quality analysis

Root cause analysis

Backlog management

Independent problem solving

Communication with stakeholders

Tools

Microsoft SQL Server

T-SQL

BigQuery

SSIS

SQL Agent

Data warehouse

ERP data integrations

Job description

Dermalogica LLC seeks a senior, hands-on data engineer to strengthen the global data environment. You will investigate complex systems, fix root causes, and implement controls to prevent recurrence across ERP, e-commerce, and data warehousing layers.

You will inherit a backlog of data quality and integration issues, perform end-to-end data tracing, and drive remediation through to closure in a hybrid/remote setup with strong Pacific Time overlap.