Lead Data Engineer
- ETL
- SQL
- Python
- PySpark
- Data Modeling
Title: Lead Data Engineer
Location: Canada (Remote)
Terms: Full Time
Job Description :
Experienced Data Engineer to lead the reverse engineering and modernization of legacy ETL pipelines into an enterprise-ready Data Lake.
Responsible for deconstructing the current Microsoft stack integrations, mapping authoritative System of Record(SOR), and rebuilding automated ingestion layers.
Define the blueprint that ensures data accuracy, traceability, and streamlined downstream consumption.
Proficiency in SQL, Python, Pyspark.
Good understanding of data modeling, schema mapping, Slowly Changing Dimensions (SCD), and Medallion architecture (Bronze, Silver, Gold).
Proven track record in reverse engineering legacy systems, source-to-target mapping, and metadata management
Lead Data Engineer ยท Epsilon Solutions LTD