Database architect Jobs in Edmonton, AB

The future you want is within reach. Let's build it together.

At PCL Constructors Inc., part of the PCL Family of Companies (PCL), we don't just build projects -- we build opportunities, careers and communities. We are 100% employee-owned, every employee has a stake in our success, and that shared commitment drives how we work, grow and lead in the construction industry.

We're a team of builders who care deeply about what we create and who we build with. That includes you. We are not only shaping the future of construction, we are also committed to shaping the future of your career.

As a Solution Architect for PCL Constructors Inc. in Edmonton, Alberta (Corporate), you'll have the opportunity to drive innovation through data and AI. The Enterprise Intelligence (EI) team is seeking a Solution Architect specializing in enterprise data architecture and data engineering. This role owns the architecture, standards and technical direction for trusted data platforms and guides delivery teams in building secure, reusable and AI-ready data products across PCL.

Why Choose PCL?

Choose a career with rewards that matter. PCL's total rewards are designed to support your growth, well-being and future success -- because when you succeed, we all do. Our offerings could include:

• Employee ownership opportunities that build long-term value
• Annual discretionary performance bonuses
• RRSP, TFSA, Pension Contribution Options
• Flexible medical, dental and vision benefits
• Prescription drug coverage and virtual care services
• Life, AD&D and disability insurance
• Paid parental leave and family care support
• Health and lifestyle spending account options
• Mental health and wellness support, including Employee Assistance Programs
• Career growth pathways, leadership development and mentorship programs
• Access to world-class training through PCL's College of Construction and professional development courses
• Ongoing opportunities to learn new skills, explore different roles and grow your career across sectors and regions

Here's how a Solution Architect for PCL Constructors Inc. within Edmonton NAHQ contributes to our team:

Responsibilities

• Own and communicate the target architecture, road map and technical standards for enterprise data engineering in Microsoft Fabric.
• Define reference architectures and reusable patterns for lakehouse and medallion architectures, including landing, bronze, silver and gold layers.
• Guide delivery teams in designing and implementing Fabric Lakehouses, Warehouses, Pipelines, Notebooks, Mirroring, Shortcuts and semantic structures.
• Set technical direction for scalable ETL and ELT pipelines, transformations and orchestration across batch and near-real-time workloads.
• Lead logical, physical, dimensional and semantic data modeling to create durable business entities and reusable enterprise data products.
• Establish standards for data quality, validation, reconciliation, lineage, metadata, observability, logging and operational support.
• Partner with business, application and domain teams to translate requirements, source constraints and business definitions into supportable solutions.
• Ensure architectures address security, privacy, access control, classification, governance, performance, capacity, reliability and cost.
• Direct CI/CD and environment-promotion practices for code, pipelines, schemas and Fabric configuration using GitHub or Azure DevOps.
• Prepare structured and unstructured data for analytics and AI through governed enrichment, grounding, indexing and secure access patterns.
• Review solution designs and implementations, resolve complex technical issues and ensure delivery aligns with approved architecture and standards.
• Provide hands-on technical guidance, mentor engineers and create architecture artifacts, decision records, templates and implementation guides.

Qualifications

• Postsecondary degree or diploma in computer science, data engineering, information systems or a related discipline.
• 5+ years of progressive data engineering, data architecture, integration or analytics engineering experience.
• Proven experience with:
• Production Microsoft Fabric lakehouse implementations and modern cloud data platforms
• Lakehouse, medallion, relational, dimensional and semantic modeling
• SQL, Python and PySpark or Spark for scalable data processing
• ETL/ELT pipelines, orchestration, monitoring and production support
• Data quality, lineage, metadata, observability, security and access control
• Git, automated testing, CI/CD and environment promotion
• Ownership of solution architecture, technical standards and multi-team delivery guidance.
• Ability to translate business requirements and source-system constraints into secure, scalable and supportable data solutions.
• Strong analytical and troubleshooting skills across data, pipelines, integrations and platform services.
• Effective communication and presentation skills for technical and nontechnical audiences.
• Proven technical leadership, project oversight, mentoring and stakeholder relationship skills.

Bonus Qualities:

• Microsoft Fabric Data Engineer Associate (DP-700), Fabric Analytics Engineer Associate (DP-600) or a relevant cloud data certification.
• Experience with Fabric Data Agents, Power BI semantic models and Microsoft Purview.
• Experience preparing structured and unstructured data for Azure AI Search, Copilot, Azure AI Foundry and AI-agent use cases.
• Experience with Fabric capacity management, performance tuning, cost optimization, Mirroring or Real-Time Intelligence.
• Experience defining data governance, stewardship, data contracts and reusable architecture standards, with a passion for mentoring others.

Your Work Has Purpose Here

PCL projects are where life happens, where communities connect, careers begin, and progress is made. Regardless of the type of project, we are building something bigger: a future that's inclusive, resilient and full of opportunity.

At PCL Constructors Inc., we are committed to creating a workplace where everyone belongs. We value the diverse experiences, identities and perspectives our employees bring. Employment decisions are based on merit, potential and the drive to make a difference, regardless of race, gender, age, ability or background.

We know everyone's needs are different, if you require accommodation during the application process, please contact careers@pcl.com and include the position and location of interest.

This recruitment process does not involve the use of artificial intelligence (AI) to screen, assess, or select applicants. All hiring decisions are made by human reviewers.

Company: PCL Constructors Inc.

Primary Location: Edmonton, Alberta (Corporate)

Job Title: Solution Architect

Requisition ID: 14896