Senior Data Engineer

• 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

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

• Hybrid work model home and office based
• Travel required on occasion (<25% of the time)

Compensation

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.

Our competitive total rewards package provides compensation and benefits that support your physical mental and financial wellbeing. We offer exciting challenging work with opportunities to develop your skills and knowledge.

Additional Information

Our workplace culture has been recognized as one of Canadas Best Diversity Employers Canadas 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 apply.

Our True Blue team consists of individuals from all backgrounds who contribute diverse perspectives and experiences to Ledcor. We are committed to continuing to build on our culture of empowerment inclusion and belonging.

Adjustments will be provided in all parts of our hiring process. Applicants need to make their needs known in advance by submitting a request via email. For more information about Ledcors Inclusion and Diversity initiatives please visit our I&D page.