FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates advanced expertise in SQL and Python for data validation and migration processes, with a strong focus on data quality, profiling, and reconciliation across large datasets. Proficient in collaborating with cross-functional teams to ensure successful implementation and documentation of data quality outcomes.
Highest-signal resume keywords
Advanced SQL ExpertisePython Proficiency (Pandas, PySpark)Source-to-Target ReconciliationData Quality TestingAzure Data Lake Storage (ADLS)
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
SQLPythonData ProfilingAnomaly AnalysisData Migration ValidationTransformation Rule VerificationLarge-Volume Data AnalysisReconciliation Evidence GenerationQuery OptimizationExcel
Soft Skills
Analytical SkillsProblem-Solving SkillsDocumentation Skills
Tools & Technologies
SQL ServerAzure SQLDatabricks SQLAzure DevOpsAzure Data Lake Storage (ADLS)Delta Lake
Certifications & Qualifications
Government of Canada Security Clearance
Industry Keywords
Data QualityReconciliationData MigrationData TransformationReferential Integrity
Tech Stack
Tools & technologiesAzurePandasPySparkPythonSQL
About the role
Key responsibilities & impact- Perform detailed source-to-target reconciliation across legacy systems, ingestion layers, and reporting stores
- Develop SQL- and Python-based validation processes for data migration, conversion, and transformation initiatives
- Develop and execute validation routines for record counts, financial and business totals, duplicates, null values, referential integrity, and transformation accuracy
- Conduct data profiling and anomaly analysis to identify, investigate, and resolve data quality issues
- Perform aggregate and record-level comparisons to validate migration and conversion results
- Validate transformation rules and data movement processes
- Optimize queries and analyze large-volume datasets
- Generate reconciliation evidence, document results, and report exceptions
- Partner with data, testing, and business teams to support implementation and data quality outcomes
Requirements
What you’ll need- Current secret level Government of Canada Security Clearance required at the time of application
- Advanced SQL expertise
- Experience with source-to-target reconciliation, migration validation, and data quality testing
- Strong understanding of data profiling, anomaly analysis, duplicate testing, referential integrity testing, and transformation-rule verification
- Experience performing large-volume data analysis and reconciliation
- Proficiency with SQL Server or Azure SQL and Databricks SQL
- Proficiency with Python, including Pandas and/or PySpark
- Experience working with Azure Data Lake Storage (ADLS) and Delta Lake
- Experience using Azure DevOps
- Advanced Excel skills for controlled reconciliation analysis and reporting
- Strong analytical, problem-solving, and documentation skills
Benefits
Comp & perks- Permanent or contract basis available
- Hybrid work for permanent employees located near a PLATO office location
- Collaborative work environment
- Mentorship and knowledge-sharing opportunities
- Inclusive hiring practices
- Recruitment-process accommodation support