Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • 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

Job type

Full Time

Experience level

Mid levelSenior

Salary

Not specified

Degree requirement

Associate's Degree

Tech skills

CloudETLPythonSnowflakeSQL

Location requirements

OnsiteEdmontonCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.