Senior Data Engineer

Our client is building their enterprise data engineering capability from the ground up - and this is the role that starts it. As the company executes a full transformation to Oracle Cloud Fusion, this Senior Data Engineer will be the founding architect of a centralized data platform designed to unify data across financial, operational, customer, HR, asset, and supply chain domains.

This is not a maintenance role. It requires someone who can design and build a modern, cloud-integrated data ecosystem with significant autonomy - and who has the vision and leadership to grow a data engineering team around them. The right candidate is a hands-on builder who is equally comfortable making architectural decisions and writing the pipeline code to execute them.

Our client will consider strong data engineering generalists willing to develop hands-on expertise in Oracle Fusion Data Intelligence (OFDI).

What You’ll Do

Data Platform & Pipeline Engineering

• Serve as the primary technical owner of Oracle Fusion Data Intelligence (OFDI) - standing up, configuring, and evolving the platform as the enterprise analytics hub
• Design and build scalable ETL/ELT pipelines that ingest data from multiple source systems (SAP, on-prem Oracle, SQL Server, GIS, and others) into a centralized data warehouse
• Develop and maintain integrations using Oracle Integration Cloud (OIC) as the enterprise middleware platform
• Transition the organization 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

Enterprise Reporting & Analytics

• Curate trusted, analytics-ready datasets for consumption by downstream BI 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

Data Governance & Architecture

• Establish data governance frameworks, data lineage documentation, and data quality standards from the ground up
• Document data flows, technical designs, and integration specifications to ensure long-term maintainability
• Partner with enterprise architecture and application teams to align data solutions with enterprise standards
• Evaluate and recommend supplemental data tools - including platforms such as Microsoft Fabric - as platform needs evolve, with significant input into tooling decisions

Team Leadership

• Operate with a high degree of autonomy in a self-directed capacity - minimal technical oversight exists above this role
• Identify gaps in the team’s future capability needs and contribute to hiring decisions as the data engineering function grows

• 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)
• Demonstrated experience designing and building ETL/ELT pipelines and data architecture for enterprise environments - both relational and cloud-based
• Experience pulling from multiple, disparate source systems (ERP, CRM, CIS, asset management, or similar) into a unified data model
• Familiarity with cloud-based enterprise platforms and hybrid on-prem/cloud architectures
• Self-directed 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 (official transcripts required), * Do you have experience building and optimizing ETL pipelines?
• How many years of Data Engineering experience do you have?
• Do you have experience with ERP Systems?

Education:

• Bachelor’s (Required)

4.84.8 out of 5 stars Williamsville, NY 14221 $100,000 - $125,000 a year - Full-time, Pulled from the full job description

• Health insurance
• Retirement plan
• 401(k) matching
• Paid time off
• Vision insurance
• Health savings account
• Dental insurance, * 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

Pay: $100,000.00 - $125,000.00 per year, * 401(k) matching

• Dental insurance
• Flexible schedule
• Health insurance
• Health savings account
• Paid time off
• Retirement plan
• Vision insurance