Data Engineer

Senior Data Engineer (Direct Hire) role in Buffalo, NY (Hybrid) focused on building an enterprise data platform from the ground up during an Oracle Cloud Fusion transformation.

Responsibilities

• Act as the primary technical owner of Oracle Fusion Data Intelligence (OFDI), including standing up, configuring, and evolving the platform as the enterprise analytics hub
• Independently design the enterprise data architecture, covering data modeling, repository structure, and segmentation strategy across disparate sources such as SAP, on-prem Oracle, SQL Server, GIS, and others
• Design and build scalable ETL/ELT pipelines to ingest data from multiple source systems into a centralized data warehouse
• Develop and maintain integrations using Oracle Integration Cloud (OIC) as enterprise middleware
• Move the organization from legacy flat file integrations to 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 to support self-service reporting and enterprise analytics
• Partner 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 scratch
• Document data flows, technical designs, and integration specifications for long-term maintainability
• Align data solutions with enterprise standards by partnering with enterprise architecture and application teams
• Evaluate and recommend supplemental data tools (including Microsoft Fabric) as platform needs evolve, with significant input into tooling decisions
• Operate with a high degree of autonomy with minimal technical oversight above this role, and currently no internal mentor for this skill set
• Identify future capability gaps and contribute to hiring decisions as the data engineering function grows

Requirements

• Proven ability to independently design and build ETL/ELT pipelines and data architecture for enterprise environments (relational and cloud-based), not only execute existing designs
• 7+ years of professional experience in data engineering, data integration, or analytics engineering
• Strong SQL skills and hands-on experience with relational databases such as Oracle, SQL Server, or similar
• Experience integrating multiple disparate sources (ERP, CRM, CIS, asset management, or similar) into a unified data model
• Scripting experience with Python, PowerShell, or similar to automate pipelines
• Familiarity with cloud enterprise platforms and hybrid on-prem/cloud architectures
• Self-directed focus on 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

Compensation and Location

• Salary: USD 100,000 - 135,000 per year
• Location: Buffalo, NY 14221 (Required)
• Work style: Hybrid

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 do not contribute to 401K)
• Leadership training program
• Management dedicated to 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

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?