Senior Data Platform Architect (Hybrid) - ETL Leader

NPAworldwide; Buffalo (NY); Hybrid; USD 120,000 - 160,000; Full time

Benefits offered by this job

Annual Bonus Program

Low cost medical, dental premiums

Very generous Paid Time Off

401K match plus additional CompanyFund

Leadership training program

Management that is dedicated to your事业

Positive/collaborative work culture

Job summary

NPAworldwide is seeking a Senior Data Engineer in the Buffalo, NY area for a hybrid role requiring 3 days onsite. You will design enterprise data architecture, build scalable ETL/ELT pipelines, and develop integrations using OIC while migrating to API-based data flows.

You will collaborate across business domains, govern data quality, and contribute to future data tooling decisions as the data platform evolves. A hands-on, autonomous builder is essential to success.

Qualifications

• 7+ years of professional experience in data engineering, data integration, or analytics engineering roles.
• Strong SQL skills and hands-on experience with relational database platforms (Oracle, SQL Server, or similar).
• Experience pulling from multiple, disparate source systems (ERP, CRM, CIS, asset management, or similar) into a unified data model.
• Scripting proficiency (Python, PowerShell, or similar) for pipeline automation.
• Familiarity with cloud-based enterprise platforms and hybrid on-prem/cloud architectures.
• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field

Responsibilities

• Independently design and build ETL/ELT pipelines and enterprise data architecture for multi-system data intake.
• Design scalable data pipelines and central data warehouse ingestion from SAP, Oracle, SQL Server, GIS, and more.
• Develop and maintain integrations using Oracle Integration Cloud (OIC) as middleware.
• Shift organization from legacy file-based integrations to API-based, event-driven data flows.
• Implement data quality checks, auditability, and governance controls for compliance.

Skills

ETL/ELT pipelines

SQL

Python

Data architecture

Cloud platforms

Hybrid on-prem/cloud

Self-directed

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, or related field

Tools

Oracle Integration Cloud (OIC)

Oracle Fusion Data Intelligence (OFDI)

SQL Server

Job description

NPAworldwide is seeking a Senior Data Engineer in the Buffalo, NY area for a hybrid role requiring 3 days onsite. You will design enterprise data architecture, build scalable ETL/ELT pipelines, and develop integrations using OIC while migrating to API-based data flows.

You will collaborate across business domains, govern data quality, and contribute to future data tooling decisions as the data platform evolves. A hands-on, autonomous builder is essential to success.