ROLE OVERVIEW
Streamline Control is seeking a Senior Historian and Business Intelligence Specialist to take a leading role in the design, delivery, and ongoing support of AVEVA PI System environments across our industrial client base. This is a senior-level position suited to an experienced AVEVA PI professional with a minimum of 5 years of hands-on PI System experience across administration, integration, analytics, and visualization.
Working across sectors including Oil & Gas, Utilities, Mining, Life Sciences, and Manufacturing, you will serve as a subject matter expert for clients who depend on operational data to run their facilities, make decisions, and drive efficiency. You will own complex PI engagements end-to-end — from architecture and implementation through to support, optimization, and business intelligence delivery — while mentoring junior team members and contributing to pre-sales and solution design activities.
KEY RESPONSIBILITIES
PI System Administration and Infrastructure
- Administer and manage AVEVA PI Server environments including PI Data Archive, PI Asset Framework, PI Analysis, PI Notifications, and PI Web API across production, QA, and development systems.
- Monitor and optimize PI System health, performance, and availability, including collective management, SDK log reviews, interface reliability, and archive administration.
- Manage PI Server patching, upgrades, and version migrations, coordinating with client IT teams and following AVEVA best practices for system continuity and rollback procedures.
- Oversee PI Server backup and disaster recovery planning, including recovery testing and documentation aligned with client business continuity requirements.
- Administer PI security including identities, users, groups, and trusts; conduct periodic access management reviews in alignment with client cybersecurity policies.
Data Acquisition and Integration
- Configure, maintain, and troubleshoot PI Interfaces, PI Adapters, and PI Connectors for a wide range of industrial protocols including OPC-DA, OPC-UA, OPC-HDA, Modbus, RDBMS, and MQTT / Sparkplug B.
- Lead PI tag creation, validation, metadata configuration, and archive optimization using PI Builder, PI SMT, and PI System Explorer.
- Integrate PI Systems with enterprise platforms including ERP, MES, CMMS, and cloud data environments; develop and maintain PI Web API and PI AF SDK-based integrations for downstream applications.
- Support AVEVA Connect configuration, data services, and cloud connectivity including edge data store deployments and OMF-based data transmission.
PI Asset Framework and Analytics
- Design and develop PI Asset Framework hierarchies, templates, element structures, and attribute configurations aligned with client asset models and naming conventions.
- Develop advanced PI Analysis calculations, PI AF expressions, and PI Notifications to deliver real-time analytics, KPI monitoring, and automated alerting for client operations teams.
- Configure and manage PI Event Frames to capture process events, alarms, and operational contexts; develop event-driven workflows and reporting solutions built on AF event data.
- Lead PI Data Archive management including reprocessing, backfilling, archive rebuilds, and optimization of compression and exception settings for data quality and storage efficiency.
Visualization and Business Intelligence
- Design and build PI Vision displays, PI ProcessBook graphics, and PI DataLink reports that deliver intuitive, actionable operational data to client stakeholders at the site, department, and management levels.
- Develop and maintain Power BI dashboards and SSRS reports that integrate PI System data with broader enterprise data sources for operational and management-level business intelligence.
- Support clients in adopting analytics platforms such as SEEQ, Databricks, or Power BI for historian-driven advanced analytics and process intelligence initiatives where applicable.
Client Engagement and Technical Advisory
- Engage directly with client stakeholders in technical and strategic discussions, acting as a trusted advisor on PI System architecture, optimization, and roadmap planning.
- Contribute to pre-sales activities including scoping, solution design, effort estimation, and proposal preparation; translate client requirements into technically sound and commercially viable deliverables.
- Provide Tier 2 operational support for PI infrastructure under managed service agreements, including incident response, root cause investigations, and escalation management.
- Prepare and maintain technical documentation, knowledge bases, system diagrams, and end-user guides; deliver training to client personnel on PI System tools and best practices.
- Mentor and support junior Historian and BI Specialists within the Streamline team, contributing to internal knowledge sharing, quality standards, and technical capability development.
ESSENTIAL REQUIREMENTS
- Minimum 5 years of hands-on AVEVA PI System experience across administration, configuration, integration, and analytics in an industrial environment.
- Deep proficiency with PI Server architecture including PI Data Archive, PI Asset Framework, PI Analysis, PI Interfaces, and PI Web API.
- Strong understanding of industrial data collection, OT environments, and field instrument data flows from DCS, SCADA, and PLC systems into the PI historian.
- Experience configuring PI Interfaces or PI Adapters for at least two industrial communication protocols (examples: OPC-DA, OPC-UA, Modbus, RDBMS, MQTT).
- Demonstrated experience building PI Vision displays, PI DataLink reports, and PI AF-based analytics solutions for operational stakeholders.
- Background in Instrumentation Engineering, Computer Science, Electrical Engineering, or a related technical discipline.
- Strong written and verbal communication skills with the ability to present technical findings and solutions clearly to both technical teams and non-technical client stakeholders.
PREFERRED QUALIFICATIONS
- AVEVA certification in PI System Infrastructure or PI System Installation.
- Experience with AVEVA Connect, AVEVA Edge Data Store, or OMF-based cloud data transmission.
- Familiarity with business intelligence platforms including Power BI, SEEQ, or Databricks for historian-driven analytics.
- Knowledge of alternative historian platforms such as AspenTech IP.21, Wonderware / AVEVA System Platform, dataPARC, or Canary Historian.
- Scripting or development experience in Python, PowerShell, or SQL for automation, data transformation, and PI System tooling.
- Familiarity with IT infrastructure relevant to PI deployments including VMware, Hyper-V, Active Directory, Azure, and Windows Server administration.
- Experience in a PI System Integrator or managed services environment, supporting multiple clients across different industries and PI architectures.
CORE COMPETENCIES
- Deep PI expertise — brings strong experience of the AVEVA PI ecosystem and applies it confidently across diverse industrial environments and client challenges.
- Analytical problem-solver — approaches complex data and system challenges with structured thinking, curiosity, and a drive to get to root cause.
- Clear communicator — able to explain technical concepts to non-technical stakeholders and produce documentation and reports that inform decisions.
- Client-focused — committed to delivering value, building trust, and maintaining strong working relationships with client technical teams and business stakeholders.
- Collaborative and mentoring — works effectively across Streamline project and support teams, shares knowledge generously, and actively develops junior colleagues.
- Detail-oriented — maintains high standards in configuration, documentation, and data quality across all client deliverables.
WORKING CONDITIONS
- Office-based in Calgary with hybrid flexibility; occasional travel to client industrial facilities across western Canada.
- Work at active industrial facilities may require adherence to client safety management systems, site induction requirements, and PPE procedures.
- On-call availability may be required to support critical PI System incidents or client system recovery activities under managed service agreements.
- Flexibility during project delivery windows, client go-live periods, and system upgrade campaigns.
AT A GLANCE
Required: 5+ Yrs AVEVA PI Experience │ PI Server Administration │ PI Asset Framework │ PI Interfaces / Adapters │ Industrial Protocols (OPC, Modbus) │ PI Vision / PI DataLink │ Instrumentation / CS Background
Preferred: AVEVA Certification │ AVEVA Connect / Edge │ Power BI / SEEQ │ Python / PowerShell / SQL │ IP.21 / Wonderware / dataPARC │ Azure / VMware │ SI / Managed Services Background
Job Type: Full-time
Pay: $100,000.00-$165,000.00 per year
Application question(s):
- Will you now or in the future require sponsorship for employment visa status?
- Do you have a degree or diploma in a relevant engineering or technical discipline (Mechanical, Chemical, Electrical, Instrumentation, Computer Science, or equivalent)?
- Are you currently residing in Calgary, AB?
- How many years of experience do you have with the AVEVA PI System?
Work Location: Hybrid remote in Calgary, AB
