Enterprise Intelligence Developer

• 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 Dev Ops and CI/CD practices to data pipelines, schemas, platform configuration and deployment processes using Git Hub, Azure Dev Ops 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…