About the job Data Engineer
Data EngineerLondon, ON
ABOUT THE ROLEWe are looking for a mid-to-senior Data Engineer to join LYNKED at a pivotal moment in our data evolution. This is a hands-on role with real architecture ownership - you will build systems, not just data pipelines. You will take ownership of legacy data migration, ongoing data quality, and have real input on the platform architecture that underpins our smart metering and IoT systems working across workloads with constant flow of high-volume telemetry from connected devices across the country. Work on a Data Lakehouse foundation that supports both operational telemetry and analytical workloads If you thrive in environments where you can build, clean, and improve systems end-to-end, - and you are passionate about schema design and how to achieve pipeline reliability - this role was designed for you.
WHAT YOU'LL DO- Design and evolve the Lakehouse storage architecture (Delta Lake) across raw, curated, and serving layers ()
- Lead legacy data migration efforts: assess source systems, profile data quality, design source-to-target mappings, build cleansing and reconciliation logic, and load historical data into the modern Lakehouse with lineage and audit trails.
- Establish data quality standards: Define and enforce data validation rules, schema contracts, validation checks, anomaly detection, and remediation workflows
- Design, build, and optimize ETL/ELT data ingestion pipelines across multiple systems
- Ensure pipelines run reliably in production through observability (logging, metrics, lineage), failure handling, and performance tuning
- Work with modern file formats (Parquet, Delta, Iceberg), applying them appropriately for performance, cost, and schema evolution
- Implement data security and governance: role-based access, PII handling, encryption at rest and in transit, audit logging, and adherence to applicable privacy frameworks.
- Collaborate with engineering and product teams to build scalable, maintainable data solutions
- Contribute to improving data architecture and overall system reliability
WHAT WE'RE LOOKING FOR- 3+ years of experience in a Data Engineering or equivalent hands-on data role
- Strong experience designing and developing data systems and infrastructure. Comfortable navigating evolving systems, building from scratch, and filling gaps where needed
- Proven experience contributing significantly to data migration efforts: assessing source systems, mapping, cleansing, reconciliation, and cutover
- Strong knowledge of data modeling: solid grasp of OLTP vs OLAP design, normalization vs denormalization, dimensional modeling (Kimball), and slowly changing dimensions
- Expert proficient in SQL, with hands-on experience with relational system like PostgreSQL, Oracle, or equivalents
- Hands-on with data quality practices: validation, monitoring, anomaly detection, and remediation
- Storage formats & Lakehouse: working knowledge of columnar formats (e.g. Parquet) and Lakehouse table formats (e.g. Delta Lake), including time travel, schema evolution, and ACID guarantees.
- Hands-on experience with cloud platforms such as AWS (S3, Glue, EMR, Athena, Redshift, Lambda, IAM) - or equivalent depth in Azure or GCP.
- DevOps fundamentals: Git-based workflows, CI/CD for data, Docker, and infrastructure-as-code (Terraform preferred).
- Deep understanding of ETL/ELT, OLTP/OLAP, and performance optimization techniques
- Strong sense of ownership and pragmatism - knows when to ship a clean MVP and when to invest in the right abstraction.
- Team player - willing to collaborate, pitch in, and support broader goals
Nice to Have- Exposure to IoT, sensor data, or building automation systems
- Familiarity with real-time streaming tools like Kafka or Spark Streaming
- Working knowledge of data governance, metadata management, and compliance frameworks (SOC 2, PIPEDA, GDPR).
- Familiarity with containerized deployments (Docker, Kubernetes/EKS) for data workloads.
PERKS & BENEFITS- Annual merit-based increases
- Company-paid Health, Dental, Critical Illness, and Life Insurance
- Retirement Savings Support: RRSP matching through a company-funded Deferred Profit Sharing Plan (DPSP)
- Professional development support including tuition reimbursement
- High-impact role with career growth opportunities in a scaling organization
- Collaborative, energized team working on meaningful, tech-forward solutions
