Data Engineer

Data Engineer

Req number:

R8113

Employment type:

Full time

Worksite flexibility:

Hybrid

Who we are

CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.

Job Summary

As a Data Engineer, you will be responsible for designing, developing, and maintaining scalable data integration and warehousing solutions. You will build and optimize ETL/ELT pipelines, integrate data from ERP and finance systems, and leverage modern Azure data technologies to support business intelligence, reporting, and analytics initiatives.

Job Description

We are looking for a Senior Data Engineer who will provide technical expertise in data warehousing, ETL/ELT development, and Azure-based data engineering solutions. This position will be full-time and hybrid in Mandaluyong City.

The ideal candidate has strong experience in Oracle technologies, Azure data services, and enterprise data integration. You should be comfortable working with large-scale data pipelines, collaborating with cross-functional teams, and delivering reliable, high-quality data solutions for business-critical applications.

What You’ll Do

• Design, develop, and maintain scalable data warehousing and ETL/ELT solutions

• Build and optimize data ingestion and transformation pipelines using Azure Data Factory, Azure Databricks, and ADLS Gen2

• Develop and maintain Oracle Database objects, PL/SQL packages, procedures, and scripts

• Design and implement dimensional data models to support reporting and analytics requirements

• Integrate data from ERP systems and finance/accounting applications into enterprise data platforms

• Develop and maintain data integration workflows using Oracle Data Integrator (ODI) and other ETL tools

• Optimize SQL queries and database performance for large-scale datasets

• Develop REST API integrations to support enterprise data exchange

• Collaborate with business stakeholders, data architects, and development teams to gather requirements and deliver data solutions

• Ensure data quality, integrity, and compliance with organizational standards and best practices

What You’ll Need

Required:

• 5+ years of experience in Data Warehousing, ETL/ELT Development, or Data Engineering

• Expert-level experience with the Microsoft Azure data stack, including:

  • Azure Data Factory (ADF)

  • Azure Databricks

  • Azure Data Lake Storage Gen2 (ADLS Gen2)

• Strong experience with Oracle Database and PL/SQL development

• Hands-on experience with Oracle Data Integrator (ODI)

• Strong SQL and relational database (RDBMS) knowledge

• Experience designing dimensional data models and enterprise data warehouses

• Experience with ERP systems and finance/accounting data integration

• Experience building REST API integrations

• Strong analytical, troubleshooting, and problem-solving skills

• Excellent verbal and written communication skills

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field

Preferred:

• Experience with Azure SQL Database

• Experience using PySpark

• Experience with Delta Lake and ADLS Gen2

• Experience with Amazon S3 or other object storage technologies

• Experience working in enterprise-scale Azure data platforms

Physical Demands

• Ability to safely and successfully perform the essential job functions

• Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings

• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor

Reasonable accommodation statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to [email protected] or (888) 824 – 8111.