Sql developer Jobs in Edmonton, AB

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 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 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: Enterprise Intelligence Developer

Requisition ID: 14376