Solution Architect designing enterprise data platforms and AI capabilities for PCL Construction. Building scalable pipelines, trusted datasets and reusable architecture patterns.
Responsibilities
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 from enterprise applications, APIs, files and other sources
Develop automated data processing and orchestration for batch and near-real-time workloads, with monitoring, logging and error handling
Profile data, establish data-quality rules and implement automated validation, reconciliation and exception handling
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 for consistent, discoverable enterprise data
Identify and resolve data lineage, integrity, performance and reliability issues
Develop shared platform capabilities and reusable patterns for analytics, Copilot and agent experiences
Apply DevOps and CI/CD practices to data pipelines, schemas, platform configuration and deployment processes
Create technical documentation, architecture diagrams, data mappings, test cases and operational support procedures
Support 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
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 for PCL’s enterprise data and AI platform capabilities
Requirements
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
Proven experience with SQL development, query optimization and relational database concepts
Proven experience building ETL or ELT pipelines using cloud-based data and analytics platforms
Proven experience with data integration using APIs, files, databases and enterprise application sources
Proven experience with data transformation, orchestration, scheduling, monitoring and production support
Proven experience with 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: Experience with enterprise data governance, metadata, lineage, data quality and stewardship
Bonus: Experience with Microsoft Fabric, Databricks or Snowflake
Bonus: Experience with lakehouse, medallion and dimensional modeling
Bonus: Experience with Python, notebooks or modern automation frameworks
Bonus: Experience with Microsoft Foundry, Copilot Studio or similar AI development platforms
Bonus: Experience preparing structured and unstructured data for retrieval, grounding, analytics and AI-agent use cases
Bonus: Experience with Power BI semantic models and enterprise analytics solutions
Bonus: Experience developing reusable architecture patterns, standards and frameworks
Bonus: Passion for mentoring others and helping grow organizational capabilities
Benefits
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
Consultant en architecture et sécurité guidant les évaluations technologiques et les ventes de Tecsys. Traduction des enjeux infonuagiques, cybersécurité et IA en valeur d’affaires.
Data architecture advisor leading reusable data capabilities and governance for iA Financial Group’s insurance transformation. Aligning Snowflake, Databricks, Salesforce, and enterprise platforms.
Solutions Consultant supporting D2L’s education customers with Brightspace demos, needs analysis, proposals, and adoption. Partnering with sales and technical teams to deliver learning technology solutions.
Solutions Architect designing ERP, EAM, and API integrations for MaintainX’s industrial work execution platform. Scoping customer solutions across pre - sales and post - sales delivery.
Solutions Architect designing ERP and enterprise integrations for MaintainX’s industrial maintenance platform. Bridging presales discovery with post - sales implementation.
Solutions Architect guiding NVIDIA partners in deploying large - scale Agentic AI and HPC solutions. Designing hybrid cloud and datacenter architectures across Canada.
Director leading Solutions Engineering for Solink’s cloud video security platform. Building technical sales execution across software, hardware, and enterprise customer deployments.
Principal Workday Financials architect leading enterprise implementations and finance transformation. Advising executives and growing Kainos’s global Workday consulting practice.