MHybridIT Data Engineer IV, Advanced SQL and Data Quality
Context
A financial services organization is setting up a new metadata repository and needs data quality controls for its transaction monitoring and client risk rating projects. The role is hybrid in Toronto, with three days onsite and two remote, for six months with a possible extension.
What you'll do
- Develop, implement and test SQL-based data quality rules within a new metadata repository
- Profile data and identify quality gaps across several source systems
- Write complex SQL queries to validate accuracy, completeness and consistency of data
- Perform source-to-target mapping and record-level reconciliation
- Investigate failed records, troubleshoot discrepancies and carry out root cause analysis
Profile
- 8+ years of experience in data engineering, data management, data analysis or a related field
- Strong hands-on experience with advanced SQL, including joins, CTEs, subqueries, aggregations and window functions
- Practical experience implementing and troubleshooting SQL-based data quality rules
- Experience with data profiling, data validation and reconciliation
- Strong analytical, problem-solving and communication skills