Senior Data Engineer

Description
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.You will require deep expertise in data engineering and data modeling, and you will apply that knowledge across a modern Azure Databricks and Delta Lake platform using a medallion architecture approach. You will partner closely with report developers, business analysts, project stakeholders, and platform administrators to ensure trusted, secure, and scalable data solutions are delivered across the organization.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 layersConfigure and contribute to metadata-driven ingestion processes using YAML-based configurations and code generation frameworks that automate pipeline creationSupport infrastructure-as-code deployments using Databricks Asset Bundles (DAB) and implement data quality expectations and monitoring throughout pipeline stagesDesign conceptual, logical, and physical data models using Information Engineering (crows-foot) notation, applying Inmon, Kimball, and Data Vault methodologies as appropriateBuild and maintain normalized enterprise data structures and dimensional analytics models, including business key and surrogate key strategies, SCD patterns, and referential integrity standardsContribute to enterprise modeling standards, naming conventions, and data governance practicesImplement row-level and column-level security policies using Unity Catalog;
configure role-based and attribute-based access controls, data classification, and governance metadataDefine and enforce automated data quality checks across pipelines;
develop validation, regression, and reconciliation testing processes between source and target systemsContribute to team testing standards and deployment validation practicesQualifications
Bachelor's degree in Computer Science, Statistics, Information Management, or related field6+ years of professional experience in data engineering, data modeling, or related disciplines5+ years designing conceptual, logical, and physical data models with strong expertise in 3NF normalization and dimensional modelingExperience 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 SynapseStrong proficiency in Python, PySpark, and SQL for large-scale data transformationExperience with medallion or multi-layered data architectures, streaming ingestion, change data capture (CDC), and incremental load strategiesFamiliarity with CI/CD practices, automated deployment pipelines, and infrastructure-as-code conceptsStrong written and verbal communication skills;
ability to convey technical concepts to non-technical stakeholdersDatabricks Data Engineer or Microsoft Azure Data Engineer certification is an assetExperience with Unity Catalog, Data Vault 2.0, metadata-driven pipeline frameworks, or AI-assisted development tools is an assetWork Environment
Hybrid work model - home and office basedTravel required on occasion (
Compensation
$94,400.00 - $129,800.00This 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
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 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 Ledcor's Inclusion and Diversity initiatives, please visit our I&D page.
#J-18808-Ljbffr