Data Engineer

Senior Data Engineer (Direct Hire) role in Buffalo, NY (Hybrid) focused on standing up a centralized enterprise data platform from scratch during an Oracle Cloud Fusion transformation.

Responsibilities

• Act as the primary technical owner for Oracle Fusion Data Intelligence (OFDI), responsible for standing up, configuring, and evolving it as the enterprise analytics hub
• Independently design enterprise data architecture, including data modeling, repository structure, and segmentation strategy across disparate sources (SAP, on-prem Oracle, SQL Server, GIS, and others)
• Design and build scalable ETL/ELT pipelines to ingest multi-source data into a centralized data warehouse
• Develop and maintain integrations using Oracle Integration Cloud (OIC) as enterprise middleware
• Drive the transition away from legacy flat file integrations toward API-based, event-driven data flows
• Implement data quality checks, reconciliation processes, and monitoring controls 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 that enable self-service reporting and enterprise analytics
• Collaborate with application and business stakeholders 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 data solutions to enterprise standards
• Evaluate and recommend supplemental data tools (example listed: Microsoft Fabric) with meaningful input into tooling decisions
• Operate with a high degree of autonomy in a self-directed capacity, with minimal technical oversight above this role and no internal mentor for this specific skill set
• Identify future capability gaps and contribute to hiring decisions as the data engineering function grows

Requirements

• Demonstrated experience independently designing and building ETL/ELT pipelines and data architecture for enterprise environments (not limited to executing an existing design), covering both relational and cloud-based approaches
• 7+ years of professional experience in data engineering, data integration, or analytics engineering
• Strong SQL skills and hands-on experience with relational platforms such as Oracle and SQL Server
• Experience ingesting from multiple disparate systems (examples listed: ERP, CRM, CIS, asset management) into a unified data model
• Scripting experience (examples listed: Python, PowerShell) for pipeline automation
• Familiarity with cloud-based enterprise platforms and hybrid on-prem/cloud architectures
• Self-directed approach with 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

Technologies

• 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, dental premiums
• Very generous Paid Time Off
• 401K match plus additional Company Funded Retirement Savings Account (even if you don't contribute to 401K)
• Leadership training program
• Management that is dedicated to your career success and flexible when life happens
• Positive/collaborative work culture
• 401(k) matching
• Dental insurance
• Flexible schedule
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Retirement plan
• Vision insurance

Salary

USD 100,000 - 135,000 per year

Application Questions

• Do you have ETL, integration, and/or Data Warehouse experience?
• Have you have experience with Microsoft Fabric or a similar tool?
• Have you ever designed an enterprise data solution across disparate source systems?
• What are your salary requirements?

Location

• Buffalo, NY 14221 (Required)
• Hybrid