Data Integration Engineering Lead

Job Summary
This is the person who figures out how to get data out of a customers environment whether thats an OSIsoft PI historian behind a corporate firewall an SAP PM system with no API enabled a legacy CMMS with only SQL access or a lab system nobodys documented.
You wont wait for someone to hand you clean data. Youll work directly with customer IT teams to negotiate access understand their source schemas and build the extraction layer that feeds our reliability platform.
If youve never had to get on a call with a clients IT security team and talk your way through a firewall rule request this probably isnt the right fit.

Job Duties
Source System Extraction (This Is the Core of the Role)
Independently extract data from industrial source systems including OSIsoft PI historians SAP PM/EAM Maximo eMaint lab/LIMS systems and other CMMS/ERP platforms.
Navigate customer IT environments to establish connectivity VPNs service accounts firewall rules read-only database access often with limited or no documentation.
Reverse-engineer undocumented or poorly documented source schemas to identify the right data for integration.
Build and own the extraction layer: connectors API calls direct database queries file-based ingestion from heterogeneous client environments.
Handle the reality that every customers data is messy in a different way inconsistent tag naming mismatched equipment IDs unmaintained asset hierarchies.
Data Transformation and Pipeline Development
Design build and maintain data pipelines that clean transform and load extracted data into our reliability platform.
Develop integration architecture and blueprints tailored to each customers source system landscape.
Implement data quality checks reconciliation processes and monitoring to ensure ongoing accuracy.
Build and maintain master data mapping strategies including change management processes as clients execute MOCs add equipment or decommission assets.
Own pipeline monitoring alerting and uptime SLAs for all production data extraction and integration systems. These are live production pipelines serving customers when extraction fails you are responsible for detecting the failure diagnosing the root cause and restoring the data flow within SLA.
Client Communication and Technical Leadership
Serve as the primary technical point of contact with customer IT teams for all data access and connectivity matters.
Respond to detailed technical inquiries from client IT leadership (architecture questions data mapping strategies security concerns) with clarity and confidence.
Lead discovery sessions with customers to understand their source systems data flows and integration requirements.
Create and maintain architecture documentation integration runbooks and data dictionaries for each client engagement.
Provide technical guidance and mentorship to team members and drive knowledge sharing across the data engineering team.
Manage integration project plans timelines and deliverables across multiple concurrent client engagements. Drive accountability on milestones coordinate dependencies with client IT teams and ensure integrations are completed on schedule.
Strategy and Team Building
Lead the enterprise data integration strategy and platform architecture across the organization.
Provide new ideas and approaches to the CTO and enterprise architecture team on data acquisition and integration best practices.
Drive recruitment to build and grow a high-performing data engineering team.
Continuously evaluate and adopt emerging data technologies and practices.

Accountabilities/Results/Success for this role
Projects delivered on time
Team utilization
New data solutions delivered pre year
Production pipeline uptime (extraction/integration)

Required Qualifications/Skills/Competencies
Hands-on experience extracting data from at least two of: OSIsoft PI SAP PM/EAM Maximo eMaint or similar industrial/operational systems. This is non-negotiable.
Experience working with or for heavy process/industrial industries; refining chemical/petrochemical manufacturing mining water/wastewater etc. This is non-negotiable. Must understand maintenance data.
Direct experience working with customer or client IT teams to negotiate and establish data access (firewall rules VPN connectivity service accounts API credentials).
SQL proficiency specifically the ability to explore unfamiliar database schemas and write extraction queries with little or no documentation.
Python for data extraction transformation and pipeline automation.
Experience with cloud-based data integration (Azure Data Factory Azure Functions or comparable).
Strong knowledge of data integration patterns ETL/ELT APIs and messaging protocols (REST SOAP OPC).
Demonstrated experience with enterprise database technologies and data modeling.
Excellent communication skills youll be the person answering detailed technical emails from client IT directors and leading discovery calls.