Solution Architect

PCL Construction, Inc.; Edmonton; On-site; CAD 110,000 - 150,000; Full time

Benefits offered by this job

Employee ownership opportunities

Annual discretionary bonuses

Flexible medical, dental and vision

Job summary

PCL Constructors Inc. in Edmonton, Alberta (Corporate) is seeking a Solution Architect to design and deliver scalable enterprise data, analytics and AI capabilities.

This hands-on role builds trusted data products, data platforms and reusable patterns enabling AI solutions across PCL. The role involves defining scalable architectures, building ETL/ELT pipelines, data governance and collaboration with application teams to prepare data for analytics and Copilot use cases.

Qualifications

• Postsecondary degree in CS/IT or related discipline.
• 3+ years of progressive experience in a related field.
• Experience in enterprise data architecture and data modeling.
• Experience with SQL development and relational databases.
• Experience building ETL/ELT pipelines on cloud platforms.
• Experience data integration from APIs, files, databases and apps.
• Knowledge of data quality, validation and remediation.
• Ability to translate business requirements into scalable data solutions.
• Understanding of SDLC, source control, CI/CD.
• Strong communication and collaboration skills.
• Ability to mentor others.

Responsibilities

• Design, develop and maintain enterprise data platforms.
• Define scalable data architectures and integration approaches across cloud platforms.
• Build and optimize ETL/ELT pipelines ingesting data from enterprise sources.
• Develop automated data processing and orchestration capabilities.
• Profile data and implement data-quality rules and remediation.
• Collaborate with teams to prepare data for analytics, Copilot and AI use cases.
• Design curated data layers and reusable interfaces for consistency.
• Identify and resolve data lineage and performance issues across sources.

Skills

Data architecture

SQL development

ETL/ELT pipelines

Data integration

CI/CD practices

Analytical problem-solving

Effective communication

Education

Bachelor's degree in CS/IT or related

Tools

GitHub

Azure DevOps

Databricks

Power BI

APIs

Job description

Select how often (in days) to receive an alert: Create Alert

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 an Solution Architect for PCL Constructors Inc. in Edmonton, Alberta (Corporate), you'll have the opportunity to design and deliver scalable enterprise data, analytics and AI capabilities. This hands-on role will build trusted data products, shared platforms and reusable patterns that enable teams to deliver AI solutions 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 an Solution Architect for PCL Constructors Inc. within Edmonton NAHQ contributes to our team:

• Design, develop and maintain enterprise data platforms, reusable data products and trusted, AI-ready datasets.
• Define and implement scalable data architectures, data models, storage patterns and integration approaches across cloud-based platforms and PCL applications.
• Build and optimize ETL and ELT pipelines that ingest, transform, validate and publish data from enterprise applications, APIs, files and other sources.
• Develop automated data processing and orchestration capabilities for batch and near-real-time workloads, with appropriate monitoring, logging and error handling.
• Profile data, establish data-quality rules and implement automated validation, reconciliation and exception-handling processes.
• Partner with application teams and business stakeholders to understand source data, clarify business definitions and prepare data for analytics, Copilot and AI-agent use cases.
• Design curated data layers, semantic structures and reusable interfaces that make enterprise data consistent, discoverable and fit for downstream use.
• Identify and resolve data lineage, integrity, performance and reliability issues across source systems, transformation processes and consuming solutions.
• Develop shared platform capabilities and reusable patterns that support solution teams building analytics, Copilot and agent experiences.
• Apply DevOps and CI/CD practices to data pipelines, schemas, platform configuration and deployment processes using GitHub, Azure DevOps or equivalent tools.
• Create technical documentation, architecture diagrams, data mappings, test cases and operational support procedures.
• Support the deployment, monitoring and operationalization of enterprise data and AI capabilities, including production troubleshooting and continuous improvement.
• Ensure platform and data work aligns with governance, security, privacy, architecture and development standards.
• Contribute to technical standards, templates and repeatable delivery patterns for enterprise data and AI solutions.
• Estimate technical effort, plan assigned work and participate in Agile delivery activities.
• Mentor team members on modern data platforms, architecture patterns, data-quality practices and delivery methods.
• Research, evaluate and recommend tools and practices that strengthen PCL’s enterprise data and AI platform capabilities.

Qualifications

• Postsecondary degree or diploma in computer science, information technology, software development or a related discipline.
• 3+ years of progressive experience in a related field
• Proven experience with:
  • Enterprise data architecture, dimensional and relational data modeling and data platform design
  • SQL development, query optimization and relational database concepts
  • Building ETL or ELT pipelines using cloud-based data and analytics platforms
  • Data integration using APIs, files, databases and enterprise application sources
  • Data transformation, orchestration, scheduling, monitoring and production support
  • Data profiling, validation, reconciliation and remediation of data-quality issues
• Ability to translate business requirements and source-system constraints into scalable, supportable data solutions.
• Understanding of software development lifecycle practices, source control, automated testing and CI/CD.
• Effective communication and collaboration skills, including the ability to explain data structures, dependencies and trade-offs to technical and business audiences.
• Strong analytical, troubleshooting and problem-solving abilities across data, pipelines, integrations and platform services.
• Enthusiastic, self-motivated and able to manage multiple priorities in a fast-paced environment.

Bonus Qualities:

• Experience with enterprise data governance, metadata, lineage, data quality and stewardship
• Experience with Microsoft Fabric or comparable modern data platforms such as Databricks or Snowflake
• Experience with modern data architecture patterns such as lakehouse, medallion and dimensional modeling
• Experience with Python, notebooks or modern automation frameworks for data processing and validation
• Experience with Microsoft Foundry, Copilot Studio or similar AI development platforms
• Experience preparing structured and unstructured data for retrieval, grounding, analytics and AI-agent use cases
• Experience with Power BI semantic models and enterprise analytics solutions
• Experience developing reusable architecture patterns, standards and frameworks
• Passion for mentoring others and helping grow organizational capabilities

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 [e-mail] 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)