Data Engineer

ComputerPeople Staffing is hiring a Senior Data Engineer (Direct Hire) for a hybrid role in Buffalo, NY. This is an opportunity to build a centralized enterprise data platform from scratch during a transformation to Oracle Cloud Fusion, taking ownership of Oracle Fusion Data Intelligence (OFDI) and delivering data foundations that support analytics-ready reporting.

You’ll shape end-to-end data architecture, integration patterns, and ETL/ELT pipelines across multiple enterprise systems, with the platform serving as an analytics hub for teams consuming data through Power BI and Oracle Analytics Cloud.

Responsibilities

• Act as the primary technical owner of Oracle Fusion Data Intelligence (OFDI), standing up, configuring, and evolving it as the enterprise analytics hub.
• Independently design the enterprise data architecture, including data modeling, repository structure, and segmentation strategy across disparate sources such as SAP, on-prem Oracle, SQL Server, and GIS.
• Design and build scalable ETL/ELT pipelines to ingest data from multiple systems into a centralized data warehouse.
• Develop and maintain integrations using Oracle Integration Cloud (OIC) as enterprise middleware.
• Lead the move away from legacy flat file integrations toward API-based, event-driven data flows.
• Implement data quality checks, reconciliation, and monitoring to support auditability and regulatory compliance.
• Curate trusted, analytics-ready datasets for downstream BI tools, including Power BI and Oracle Analytics Cloud.
• Build and maintain semantic data models and data mappings to enable self-service reporting and enterprise analytics initiatives.
• Collaborate with application and business teams to define data requirements across operational, financial, regulatory, and customer domains.
• Establish data governance frameworks, data lineage documentation, and data quality standards from the ground up.
• Document data flows, technical designs, and integration specifications for long-term maintainability.
• Partner with enterprise architecture and application teams to align solutions with enterprise standards.
• Evaluate and recommend supplemental data tools (for example, Microsoft Fabric) with meaningful input into tooling decisions.
• Operate with high autonomy in a self-directed capacity; minimal technical oversight exists above this role, and there is currently no internal mentor for this specific skill set.
• Identify gaps in the team’s future capability needs and contribute to hiring decisions as the function grows.

Requirements

• Demonstrated experience independently designing and building ETL/ELT pipelines and data architecture for enterprise environments, including relational and cloud-based work, not only executing an existing design.
• 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 such as Oracle, SQL Server, or similar.
• Experience pulling from multiple disparate systems (ERP, CRM, CIS, asset management, or similar) into a unified data model.
• Scripting proficiency in Python, PowerShell, or similar to support pipeline automation.
• Familiarity with cloud-based enterprise platforms and hybrid on-prem/cloud architectures.
• Strong instincts for data quality, auditability, and governance.
• Knowledge of enterprise integration and data architecture design patterns.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.

Technology

Oracle Fusion Data Intelligence (OFDI), Oracle Cloud Fusion, Oracle Integration Cloud (OIC), Power BI, Oracle Analytics Cloud, Microsoft Fabric, SAP, SQL Server, Oracle, GIS, ETL, ELT, Python, PowerShell, API-based, event-driven data flows, Informatica, Boomi, SSIS, Talend, MuleSoft

Benefits

• Annual Bonus Program
• Low cost medical and dental premiums
• Very generous Paid Time Off
• 401K match plus an additional Company Funded Retirement Savings Account, even if you do not contribute to 401K
• Leadership training program
• Management dedicated to career success, with flexibility when life happens
• Positive, collaborative work culture
• Health insurance
• Health savings account
• Life insurance
• Vision insurance
• Flexible schedule
• Retirement plan
• Dental insurance
• Paid time off
• 401(k) matching

Salary: USD 100,000 - 135,000 per year.
Experience: 7+ years required.
Location: Buffalo, NY 14221 (Required).
Work model: Hybrid.