Ensuring Cross-Source Data Quality | Dataford Interview Questions

How do you ensure data quality and consistency when dealing with disparate data sources like ERP systems and construction project logs at Crusoe?

Using the provided tables, write a query that reconciles ERP labor hours against construction project log hours and identifies data quality issues.

Output

One row per project ID appearing in the project, ERP, or log data.
Return project_id, project_name, erp_hours, logged_hours, hours_variance, and quality_status.
Include missing-source, null-value, and hours-discrepancy conditions. Sort by project_id ascending.

projects

Column	Type	Description
project_idPK	INT	Unique project identifier
project_name	VARCHAR(100)	Project name from the project master data

erp_labor_entries

Column	Type	Description
erp_entry_idPK	INT	Unique ERP labor entry identifier
project_id	INT	Project associated with the ERP entry
labor_hours	NUMERIC(8,2)	Labor hours recorded in the ERP system

construction_labor_logs

Column	Type	Description
log_idPK	INT	Unique construction log identifier
project_id	INT	Project associated with the construction log
labor_hours	NUMERIC(8,2)	Labor hours recorded in the construction log

Your question is Ensuring Cross-Source Data Quality. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.