Data Engineer (Ontario)

Data Engineer (Ontario)

08 Aug
|
Socket.dev
|
Ontario

08 Aug

Socket.dev

Ontario

Data Engineer
London, ON
ABOUT LYNKED
LYNKED Inc. is your partner in transformation for the next generation of smart infrastructure. An industry leader in advanced metering infrastructure (AMI) and device-agnostic IoT cloud platforms serving the utility, submetering, and property management sectors. We specialize in advanced meters and metering systems, embedded systems, wireless communications, and software systems. Our energy management solutions encompass electricity, water, BTU, and gas metering, enabling real-time energy monitoring, smart metering, and seamless data integration for commercial and residential clients. We are committed to innovation, sustainability, and delivering high-quality technology solutions that redefine efficiency in energy management and intelligent building operations.
ABOUT THE ROLE
We 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.
WHY JOIN US
Real impact: Shape the foundations of a modern Data Lakehouse architecture (Delta Lake on object storage) you will help shape how ingestion, storage, and serving layers scale in our data environments.
Build as you go: There are no simplistic checklists here. You will define the right standards and structure where it is needed and continuously improve what is not working.
High visibility: Your work will not be buried — it will directly influence key systems, decisions, and future growth.
Own your work: From legacy migration to ingestion to transformation to serving — you will see systems end-to-end and take pride in what you build.
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 shoot 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
Team-oriented, energized team working on meaningful, tech-forward solutions
*At LYNKED, we are proud to be an equal opportunity employer. If you require accommodations to participate in the job application or interview process, please contact Human Resources. This posting is for an existing vacancy.*
Pay: From $70,790.55 per year
Benefits:
Casual dress
Company events
Company pension
Dental care
Life insurance
On-site parking
Paid time off
RRSP match
Tuition reimbursement
Vision care
Application question(s):
Salary Expectations:
This role is primarily infrastructure and platform engineering — not BI or dashboard development. It also involves hands-on legacy data migration. Does that align with what you're looking for?
Experience:
Data Engineering: 3 years (required)
Location:
London, ON (preferred)
Work Location: In person

#J-18808-Ljbffr

📌 Data Engineer (Ontario)
🏢 Socket.dev
📍 Ontario

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: data engineer (ontario) / ontario

Subscribe to this job alert:

Get the latest job offers by email for: data engineer (ontario) / ontario