SQL Support jobs in London, ON

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 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

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