Senior Data Engineer (Contract) - Data Quality & Systems Forensics

Job Description

Senior Data Engineer Data Quality \& Systems Forensics6 Month Contract Fixed Term Role Location Carson CA hybrid or remote with strong Pacific Time overlap Duration 6 months full time Compensation 70K to 80K for the six month engagement Team Global Data \& AI About the RoleDermalogica is looking for a senior hands on data engineer to help us strengthen the fundamentals of our global data environment This is not a traditional reporting role and it is not primarily a greenfield data engineering role We are looking for someone who is exceptionally good at investigating how complex systems actually work finding where data has gone wrong fixing the underlying issue and putting controls in place so it does not happen again You will inherit a prioritized backlog of known data quality and integration issues across a hybrid environment that includes ERP systems e commerce platforms marketplace data SQL Server databases ETL processes cloud data warehousing and downstream analytics The right person will be comfortable peeling back the layers of an unfamiliar system starting with a number that does not make sense tracing it through databases views stored procedures integration jobs and source systems determining exactly where and why it broke and driving the issue through to resolution We are looking for someone with strong technical depth forensic instincts practical judgment and the confidence to operate independently in an environment where documentation is sometimes incomplete and the answer is not always obvious What Youll DoInvestigate and root cause data discrepancies across source systems databases integrations data warehouses and reporting layersTrace data end to end to understand where transformations mappings filters jobs or business rules are producing incorrect resultsOwn a prioritized backlog of data quality issues from investigation through remediation validation backfill and closureAudit existing SQL jobs stored procedures ETL processes dependencies and transformation logic to identify fragile or undocumented behaviorIdentify and eliminate hardcoded business rules silent failures incomplete loads duplicate data and other recurring sources of data quality problemsCorrect issues at the appropriate architectural layer rather than applying downstream patchesRecover and backfill missing or incorrect historical data and reconcile results back to source systemsImprove customer channel product and other master data mappings where inconsistent logic is affecting reportingReplace fragile manual data processes with governed scheduled and monitored pipelines where appropriateBuild automated reconciliation feed health checks and alerting so data failures are detected quickly rather than discovered through manual reviewImprove dependency management reload processes and change controls so upstream changes do not create unexpected downstream issuesDocument critical data lineage system dependencies transformation logic and ownership as the environment is cleaned upWork closely with internal IT Finance market teams external development partners and vendors to drive issues to resolutionCommunicate technical findings clearly to both technical and non technical stakeholdersWhat Were Looking ForMust Have7 years of hands on data engineering database engineering or closely related experience in production environmentsDeep experience with Microsoft SQL Server and T SQL including complex queries views stored procedures scheduled jobs and production troubleshootingStrong understanding of ETLELT pipelines system integrations database dependencies and data warehouse architectureDemonstrated experience diagnosing and resolving data integrity or data quality incidents not only building new pipelinesAbility to take an ambiguous problem for example these numbers do not reconcile and independently determine where when and why the problem occurredExperience tracing data across multiple systems and determining the appropriate source of truthStrong analytical and forensic problem solving skills You are comfortable digging through unfamiliar systems testing assumptions and following evidence until you understand the root causeStrong practical judgment and common sense You know when something technically works but does not make sense from a business or data perspectiveAbility to make safe changes in shared production environments and understand downstream impacts before implementing themAbility to work independently with limited direction and drive issues across multiple teams through completionClear written and verbal communication skillsNice to HaveExperience with BigQuery or another modern cloud data warehouseExperience with SSIS SQL Agent or similar schedulingorchestration technologiesExperience working with ERP data such as JD Edwards Microsoft Dynamics NAV or Business CentralFamiliarity with commerce platforms such as Shopify or Amazon marketplace dataExperience working with financial or commercial datasets including invoices transactions sales returns tax accruals or general ledger dataExperience reconciling data between operational systems financial systems warehouses and BIreporting toolsExperience with data observability automated reconciliation data quality monitoring or building similar controlsExperience working with legacy systems offshore development teams external vendors or environments where system knowledge is distributed across multiple groupsThe Person Who Will Succeed in This RoleYou are naturally skeptical of data that does not make sense When you find a discrepancy you do not stop when you find a workaround You want to understand what created it what else it may have affected whether it has happened before and how to prevent it from happening again You are comfortable opening an unfamiliar stored procedure examining job history comparing source tables talking to Finance about what a transaction should represent and challenging assumptions made by other technical teams You are methodical without being bureaucratic technically rigorous without losing sight of the business problem and comfortable working in systems that are not perfectly documented Most importantly you know how to peel back the onion until you get to the real answer What Success Looks LikeOver the six month engagement you will Build a clear understanding of the critical data flows jobs dependencies and transformation logic behind global reportingResolve and close the highest priority data quality and integration issuesCorrect historical data where necessary and establish confidence that key datasets reconcile back to their source systemsReduce reliance on fragile manual processes and undocumented logicIntroduce automated reconciliation monitoring and alerting for critical data flowsImprove documentation lineage ownership and change controlsLeave behind a substantially cleaner more reliable and easier to operate data environment with a clear process for managing any remaining issuesThe total expected compensation for this 6 month contract will range from 70K to 80K The exact amount is determined by various factors including experience skills education location and budget Apply now and complete your online application All applications will be reviewed and our HR team will contact you if your skills and experiences align with the position Dermalogica is an equal opportunity employer committed to fostering an inclusive culture where all employees are valued supported and empowered to succeed