Data Integration Engineering Lead
Pinnacle · Pasadena, Texas, US
We are building a team of trailblazers, who embody growth, impact, and excellence. Job Description The Enterprise Data Architect, Lead plays a crucial role i...
Job description
We are building a team of trailblazers, who embody growth, impact, and excellence. Job Description: The Enterprise Data Architect, Lead plays a crucial role in designing, implementing, and maintaining data integration solutions within our organization. This role collaborates with customers and cross-functional teams to ensure seamless data pipelines from customers’ systems. The expertise for this role will contribute to the organization’s overall strategy and architecture for data acquisition. 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 c...