Senior Data Engineer

Ledcor Highways

Vancouver

Hybrid

CAD 94.000 - 130.000

Vollzeit

14 Tage+

Eine vollständige Bewerbung in einer Minute

Maßgeschneiderter Lebenslauf und Anschreiben – versandbereit.

Schaffe es an den ATS-Filtern vorbei

Zusammenfassung

Ledcor is hiring a Senior Data Engineer to join our Data & Analytics Platform team. You will design, build, and maintain enterprise-scale data solutions that support reporting, analytics, and operational intelligence across Ledcor's construction and infrastructure businesses.

Reporting to the Senior Manager, Data & Analytics Platform, you will work across the full data lifecycle—from source system ingestion and enterprise data modeling through to analytics delivery and governance.

Qualifikationen

  • Bachelors degree in CS/Stats/Info Management or related field.
  • 6+ years of data engineering and data modeling experience.
  • Experience with Inmon, Kimball, and Data Vault methodologies.

Aufgaben

  • Design, build, and maintain enterprise-grade data pipelines using PySpark and Databricks.
  • Contribute to metadata-driven ingestion and YAML-based configurations.
  • Support IaC deployments and data quality monitoring across pipelines.
  • Model conceptual, logical, and physical schemas using 3NF and dimensional modeling.
  • Implement security with Unity Catalog and RBAC/ABAC controls.
  • Develop automated validation and reconciliation tests between sources and targets.

Kenntnisse

Python
PySpark
SQL
Data modeling
3NF normalization

Ausbildung

Bachelor's degree in Computer Science / Statistics / Information Management or related field

Tools

Databricks
Snowflake
BigQuery
Synapse
Unity Catalog
Data Vault 2.0

Jobbeschreibung

Ledcor is hiring a Senior Data Engineer to join our Data & Analytics Platform team. In this role, you will design, build, and maintain enterprise-scale data solutions that support reporting, analytics, and operational intelligence across Ledcor's construction and infrastructure businesses. Reporting to the Senior Manager, Data & Analytics Platform, you will work across the full data lifecycle-from source system ingestion and enterprise data modeling through to analytics delivery and governance.

Essential Responsibilities
  • Design, build, and maintain production-grade data pipelines using PySpark and Databricks Spark Declarative Pipelines (SDP), including Python and SQL transformations across medallion architecture layers
  • Configure and contribute to metadata-driven ingestion processes using YAML-based configurations and code generation frameworks that automate pipeline creation
  • Support infrastructure-as-code deployments using Databricks Asset Bundles (DAB) and implement data quality expectations and monitoring throughout pipeline stages
  • Design conceptual, logical, and physical data models using Information Engineering (crows-foot) notation, applying Inmon, Kimball, and Data Vault methodologies as appropriate
  • Build and maintain normalized enterprise data structures and dimensional analytics models, including business key and surrogate key strategies, SCD patterns, and referential integrity standards
  • Contribute to enterprise modeling standards, naming conventions, and data governance practices
  • Implement row-level and column-level security policies using Unity Catalog; configure role-based and attribute-based access controls, data classification, and governance metadata
  • Define and enforce automated data quality checks across pipelines; develop validation, regression, and reconciliation testing processes between source and target systems
  • Contribute to team testing standards and deployment validation practices
Qualifications
  • Bachelor's degree in Computer Science, Statistics, Information Management, or related field
  • 6+ years of professional experience in data engineering, data modeling, or related disciplines
  • 5+ years designing conceptual, logical, and physical data models with strong expertise in 3NF normalization and dimensional modeling
  • Experience applying Inmon and Kimball methodologies; ability to design business keys, surrogate keys, and Slowly Changing Dimensions (SCD)
  • Hands‑on experience building production data pipelines on modern cloud platforms such as Databricks, Snowflake, BigQuery, or Synapse
  • Strong proficiency in Python, PySpark, and SQL for large-scale data transformation
  • Experience with medallion or multi-layered data architectures, streaming ingestion, change data capture (CDC), and incremental load strategies
  • Familiarity with CI/CD practices, automated deployment pipelines, and infrastructure-as-code concepts
  • Strong written and verbal communication skills; ability to convey technical concepts to non-technical stakeholders
  • Databricks Data Engineer or Microsoft Azure Data Engineer certification is an asset
  • Experience with Unity Catalog, Data Vault 2.0, metadata-driven pipeline frameworks, or AI-assisted development tools is an asset
Work Environment

Hybrid work model - home and office based Travel required on occasion (

Compensation

$94,400.00 - $129,800.00. This is the expected base pay range for this role. Individual base pay will be determined based on a variety of factors including experience, knowledge, skills, education and location.

Additional Information

The Ledcor Group of Companies is one of North America's most diversified construction companies. Ledcor is a company built on a rich history of long-standing project successes. Our workplace culture has been recognized as one of Canada's Best Diversity Employers, Canada's Most Admired Corporate Cultures, and a Top 100 Inspiring Workplace in North America.

Employment Equity

At Ledcor we believe diversity, equity, and inclusion should be part of everything we do. We are proud to be an equal-opportunity employer. All qualified individuals, regardless of race, color, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, Veteran status or any other identifying characteristic are encouraged to app

Hol dir deinen kostenlosen, vertraulichen Lebenslauf-Check.

oder ziehe deine Datei hierhin.

Similar jobs

Ähnliche Jobs, die dir auch gefallen könnten

Senior Data Engineer
Senior Data Engineer

Ledcor • Vancouver

Hybrid
CAD 94.000 - 130.000
Hybrid work model
Occasional travel (<25%)
Senior Data Engineer
Senior Data Engineer

Ledcor Group • Vancouver

Hybrid
CAD 94.000 - 130.000
Hybrid work model
Business Process Analyst
Business Process Analyst

Ledcor Highways • Vancouver

Vor Ort
CAD 76.000 - 105.000
Quality and Process Coordinator
Quality and Process Coordinator

10 Ledcor Industries Inc. • Vancouver

Hybrid
CAD 52.000 - 72.000
BES Continuous Improvement Jr. Analyst
BES Continuous Improvement Jr. Analyst

10 Ledcor Industries Inc. • Vancouver

Hybrid
CAD 51.000 - 70.000
Hybrid work model
Continuous Improvement Jr. Analyst
Continuous Improvement Jr. Analyst

Ledcor Highways • Edmonton

Hybrid
CAD 65.000 - 90.000
Senior Cloud Engineer
Senior Cloud Engineer

Ledcor Highways • Vancouver

Hybrid
CAD 94.000 - 130.000
Compensation Analyst
Compensation Analyst

10 Ledcor Industries Inc. • Vancouver

Hybrid
CAD 76.000 - 105.000
Quality and Process Coordinator
Quality and Process Coordinator

10 Ledcor Industries Inc. • Edmonton

Hybrid
CAD 70.000 - 90.000
BES Continuous Improvement Jr. Analyst
BES Continuous Improvement Jr. Analyst

Ledcor Highways • Vancouver

Hybrid
CAD 51.000 - 70.000
Flexible work options
Competitive total rewards