Remote Senior Data Engineer: Data Lineage & Warehouse Audit

HCM Staffing and Consulting

United States

Remote

USD 120,000 - 160,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

HCM Staffing and Consulting is seeking an experienced Data Engineer to profile source data, document mappings, and ensure data quality across systems. You will own transformation logic, contribute to inventories and KPI lineage, and prepare end-to-end documentation for a Phase 2 build.

The role requires 8+ years in data engineering, strong SQL skills, and the ability to work directly with client engineers and business users. Remote US-based engagement with overlapping Eastern Time.

Qualifications

  • 8+ years in data engineering.
  • Expert T-SQL including reading and refactoring stored procedures written by others.
  • SSIS and SQL Server Agent experience.
  • Power BI datasets, DAX and Power Query.
  • Reverse-engineering an undocumented warehouse or reporting system.
  • Clear written documentation of what you find.
  • Comfort working directly with client engineers and business users.

Responsibilities

  • Profile source data from Salesforce, NetSuite, the payments platform and processor files.
  • Document source-to-target mappings and transformation logic.
  • Measure data quality: completeness, duplicates, and conflicting values across systems.
  • Help size the de-duplication work for the new unique customer key.
  • Write the reconciliation queries that test what the business analysts hear in interviews.
  • Contribute to the data inventory, the integration inventory and the KPI lineage.
  • Keep clear, reusable documentation. Phase 2 will be built from it.

Skills

T-SQL
SSIS
SQL Server Agent
Power BI
DAX
Power Query
Data profiling
Dimensional modeling
Documentation
Client communication

Tools

SQL Server
AWS EC2
Snowflake

Job description

HCM Staffing and Consulting is seeking an experienced Data Engineer to profile source data, document mappings, and ensure data quality across systems. You will own transformation logic, contribute to inventories and KPI lineage, and prepare end-to-end documentation for a Phase 2 build.

The role requires 8+ years in data engineering, strong SQL skills, and the ability to work directly with client engineers and business users. Remote US-based engagement with overlapping Eastern Time.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Remote Senior Data Engineer - Lead Data Strategy & ETL
Remote Senior Data Engineer - Lead Data Strategy & ETL

SHI • Lincoln (NE)

Remote
USD 150,000 - 190,000
Diversity & inclusion leadership
Professional growth opportunities
Health & wellness benefits
+1
Remote Senior Data Engineer: Data Warehouse & SQL Expert
Remote Senior Data Engineer: Data Warehouse & SQL Expert

ExactCare • United States

Remote
USD 120,000 - 180,000
Medical insurance
Dental insurance
Vision coverage
+1
Remote Senior Business Analyst: Data Lifecycle & SQL
Remote Senior Business Analyst: Data Lifecycle & SQL

Partner Company • United States

Remote
USD 90,000 - 130,000
Senior Data Engineer - Remote (ETL & Data Warehouse Lead)
Senior Data Engineer - Remote (ETL & Data Warehouse Lead)

SHI • Denver (CO)

Remote
USD 150,000 - 190,000
Diversity commitment
Growth opportunities
Health benefits
+1
Senior Data Engineer - Remote Cloud Data Architect
Senior Data Engineer - Remote Cloud Data Architect

Care Access • United States

Remote
USD 120,000 - 160,000
Paid Time Off
Employer-paid health insurance (med/dm
HSA & FSA
+3
Senior Data Engineer — Data Warehouse Architect (Hybrid)
Senior Data Engineer — Data Warehouse Architect (Hybrid)

HCL Global Systems Inc • New Hampshire

Hybrid
USD 100,000 - 130,000
Remote Senior Data Warehouse Engineer
Remote Senior Data Warehouse Engineer

Road Scholar • Boston (MA)

Remote
USD 110,000 - 130,000
Medical, Dental and Vision Insurance
403(b) Retirement Plan with 5% match
PTO and paid time off during holidays
+1
Senior Data Engineer - Remote Data Pipelines & Governance
Senior Data Engineer - Remote Data Pipelines & Governance

uniteus • United States

Remote
USD 145,000 - 170,000
Remote Senior Data Pipeline & Analytics Engineer
Remote Senior Data Pipeline & Analytics Engineer

ExlService Holdings, Inc. • United States

Remote
USD 120,000 - 160,000
Senior Data Engineer - Lead ETL & Data Architecture (Remote-friendly)
Senior Data Engineer - Lead ETL & Data Architecture (Remote-friendly)

SHI International • United States

Remote
USD 150,000 - 190,000