Build the enterprise data foundation from day one. This Direct Hire Senior Data Engineer role (hybrid in Buffalo, NY) is designed for an experienced architect who can stand up a centralized data platform for an Oracle Cloud Fusion transformation. You will unify data across multiple business domains by designing cloud-integrated pipelines, governance, and trusted datasets that power enterprise analytics.
What you’ll do
- Act as the primary technical owner of Oracle Fusion Data Intelligence (OFDI), standing up, configuring, and evolving the platform as the enterprise analytics hub.
- Independently design the enterprise data architecture, including data modeling, repository structure, and segmentation strategy across disparate source systems such as SAP, on-prem Oracle, SQL Server, GIS, and others.
- Design and build scalable ETL/ELT pipelines to ingest data from multiple sources into a centralized data warehouse.
- Develop and maintain integrations using Oracle Integration Cloud (OIC) as the enterprise middleware platform.
- 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 tools including Power BI and Oracle Analytics Cloud.
- Build and maintain semantic data models and data mappings that support 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 data solutions with enterprise standards.
- Evaluate and recommend supplemental data tools, including 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.
- Identify gaps in future team capability needs and contribute to hiring decisions as the data engineering function grows.
What you bring
- Demonstrated experience independently designing and building ETL/ELT pipelines and data architecture for enterprise environments, including both relational and cloud-based systems (not limited to executing 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 data from multiple, disparate source systems (ERP, CRM, CIS, asset management, or similar) into a unified data model.
- Scripting proficiency in Python, PowerShell, or similar for 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 a related field.
Technologies you may work with
Oracle Fusion Data Intelligence (OFDI), Oracle Cloud Fusion, Oracle Integration Cloud (OIC), API-based and event-driven data flows, ETL/ELT, Oracle, SQL Server, SAP, GIS, Power BI, Oracle Analytics Cloud, PowerShell, Python, Informatica, Boomi, SSIS, Talend, MuleSoft, Microsoft Fabric.
Compensation & schedule
- Pay: USD 100,000 - 125,000 per year
- Location: Buffalo, NY (hybrid)
- Office expectation: Typically 3 days in the office
Benefits
- Annual Bonus Program
- Low cost medical and 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 dedicated to career success and flexible when life happens
- Positive, collaborative work culture
- Flexible schedule
- Health insurance
- Health savings account
- Life insurance
- 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?