> Markdown version of [/jobs/ext/1181304-data-integration-lead](https://www.wearedevelopers.com/jobs/ext/1181304-data-integration-lead). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Integration Lead - **Company:** Pinnacle Inc. - **Location:** Pasadena, TX, United States - **Experience:** Expert - **Salary:** $130,000.0 - $175,000.0 - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Application Integration Architecture, Computerized Maintenance Management Systems, Cyber Security, Databases, Data Dictionary, Information Engineering, Data Integration, Extract Transform Load (ETL), Data Mapping, Data Transformation, Data Retrieval, Data Security, Data Systems, Database Queries, IT Management, Intrusion Detection Systems, Virtual Private Networks (VPN), Laboratory Information Management Systems, Operational Databases, Reverse Engineering, SAP Plant Maintenance, Simple Object Access Protocol (SOAP), SQL Databases, Data Streaming, Azure Data Factory, Office365, Delivery Pipeline, Operational Systems, Data Management, Firewall Services Module, Data Pipelines, Serverless Computing, Web Api - **Published:** July 4, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=8ea447326706b5c1 ## About the Role * 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. * Heavy industrial process facility experience; chemical, petrochemical, refineries, water/waste water, manufacturing, mining, etc. * 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 - you'll be the person answering detailed technical emails from client IT directors and leading discovery calls., · Ability to walk, stand, sit, kneel, push, stoop, reach above the shoulder, grasp, pull, bend repeatedly, climb stairs, identify colors, hear with aid, see, write, count, read, speak, analyze, lift and carry under 30 lbs., and perceive depth. ## Description This is the person who figures out how to get data out of a customer's environment - whether that's 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 nobody's documented. You won't wait for someone to hand you clean data. You'll work directly with customer IT teams to negotiate access, understand their source schemas, and build the extraction layer that feeds our reliability platform. If you've never had to get on a call with a client's IT security team and talk your way through a firewall rule request, this probably isn't 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 customer's 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 customer's 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), * Opportunity to participate in Customer Service Teams (CST) that help facilitate collaboration and project support, access to company technology stack of Microsoft Office 365 Suite and MS Teams, comprehensive onboarding, on-demand training, regular lunch and learns, supervisor and accountability training, leadership development programs, continuous learning opportunities, and more. The Pinnacle Way (TPW) TPW is our definition and accountability to ensure a consistent and effective experience for our customers. TPW includes 4 key elements of the customer experience and it guides the way we work: : what the true goals and objectives are for the facility, leaders, and personnel that we engage. We will also go to great lengths to define the value of our work so we can measure our progress and return that value accordingly : whatever problems or obstacles are required to help each customer achieve their reliability goals. It is here that we make sure that we bring all our resources to bear to help that site reach new reliability heights : with excellence. This means that our work processes are tight, our quality is high, and our delivery is consistent : when our team and the customer are operating with a cadence and structure that is clear and consistent, ensuring that our solutions and our execution are moving forward, we are documenting progress, and measuring value Working Environment · Conditions may include working inside and/or outside. May work around office machinery with moving parts and moving objects. Working near radiant and electrical energy. Working closely with others or working alone. Working extended or irregular hours and travelling by all possible modes of transportation. ## Related Videos - [Why make use of an integration platform in today's software developments and infrastructure?](https://www.wearedevelopers.com/videos/758-why-make-use-of-an-integration-platform-in-today-s-software-developments-and-infrastructure) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Web APIs you might not know about](https://www.wearedevelopers.com/videos/281-web-apis-you-might-not-know-about) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Project Fugu: Extending the web](https://www.wearedevelopers.com/videos/832-project-fugu-extending-the-web) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Why Upskilling And Reskilling is Important For Developers](https://www.wearedevelopers.com/magazine/428-why-upskilling-and-reskilling-is-important-for-developers) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)