Senior Data Engineer & Business Intelligence Analyst (Oracle EBS Integration)

Position Summary

The Senior Data Engineer & Business Intelligence Analyst will be responsible for designing, developing, and maintaining the data architecture supporting Oracle E-Business Suite (EBS/EPS) systems and internal AI and analytics initiatives .

This role requires a strategic and technical expert with strong knowledge in data engineering, data modeling, business intelligence, and system integration , ensuring seamless data flow between Oracle EBS modules and analytical platforms.

The position focuses on delivering advanced reporting, predictive analytics, and decision-support tools within a secure, offline enterprise environment .

Key Responsibilities

Data Engineering & Architecture

• Design, build, and maintain scalable data pipelines and ETL processes integrating Oracle EBS with internal data systems and analytics platforms.
• Develop and optimize data models, schemas, and architectures to ensure performance, consistency, and scalability.
• Collaborate with IT and Oracle EBS functional teams to ensure accurate and secure data exchange between systems.
• Implement data quality checks, validation frameworks, and monitoring tools to maintain data integrity and reliability.

Business Intelligence & Analytics

• Design, develop, and maintain dashboards, reports, and visualizations using BI tools (e.g., Power BI, Oracle BI, Tableau).
• Translate business requirements into data-driven insights and KPIs , supporting decision-making across departments.
• Work with stakeholders to identify analytical needs and deliver actionable intelligence using structured and unstructured data sources.
• Conduct data mining, predictive modeling, and statistical analysis to support internal AI and forecasting initiatives.

Integration & Security

• Manage and optimize data integrations between Oracle EBS modules (Financials, Procurement, HR, Projects, etc.) and reporting systems.
• Ensure compliance with internal data governance, security, and access control policies within an offline/secure environment.
• Support the development and maintenance of data documentation, standards, and procedures .

Collaboration & Continuous Improvement

• Partner with cross-functional teams including Finance, Operations, HR, and IT to enhance system functionality and data-driven decision support.
• Stay current with emerging technologies in data engineering, AI, and Oracle analytics to recommend and implement system improvements.
• Mentor junior analysts and engineers in data management best practices and BI tool usage.

Qualifications & Experience

• Bachelor’s or Master’s Degree in Computer Science, Information Systems, Data Engineering, or a related field.
• Minimum 8–10 years of experience in data engineering and BI analytics , with at least 5 years working with Oracle E-Business Suite (EBS) or ERP integrations.
• Proven experience designing and managing ETL pipelines , data warehouses , and BI architectures .
• Strong hands-on expertise with SQL, PL/SQL, Oracle Data Integrator (ODI) , and related Oracle data tools.
• Experience with data visualization tools (e.g., Power BI, Oracle Analytics Cloud, Tableau).
• Familiarity with machine learning frameworks , Python/R scripting , and predictive analytics preferred.
• Knowledge of data governance, data security, and offline data management protocols .
• Excellent problem-solving, analytical, and communication skills.

Key Competencies

• Advanced Oracle EBS integration and data modeling skills
• Strong analytical and business acumen
• Expertise in ETL/ELT process design and optimization
• Proficiency in reporting and BI development
• Knowledge of AI, machine learning, and predictive analytics concepts
• High attention to detail with a commitment to data accuracy and confidentiality
• Collaborative mindset with the ability to work across multi-functional teams