Data warehouse engineer [h1.location_city]

Job Description

We are looking for a hands-on engineering expert with deep experience in cloud data ecosystems (OCI, AWS, Azure) and the ability to deliver secure, high-quality, and scalable data solutions. As a Principal Data Engineer within Oracle's Consumer Global Industries Unit, you will architect and build foundational components of a next-generation data platform supporting Oracle Industry Applications. You will be responsible for designing and implementing scalable, high-performance data pipelines, and contribute significantly to data integration, transformation, and delivery processes. You will collaborate with data architects on best practices for data modeling and architecture (including medallion architecture), champion modern engineering methods, and ensure compliance with security, data quality, and governance requirements. Your expertise in cloud-based data services, ETL / ELT, and real-time / batch data processing will directly enable high-value, AI-enriched solutions across multiple industries.

Required Experience :

Bachelor's or Master's degree in Computer Science, Information Systems, Engineering, or a related discipline.

7+ years of experience in data engineering with demonstrated expertise designing, building, and maintaining large-scale enterprise data platforms.

Proven hands-on experience with cloud ecosystem data services (OCI, AWS, Azure), their data engineering tools, and AI / ML service integration.

Advanced skills in building reliable ETL / ELT pipelines, data integration, transformation, validation, and orchestration frameworks.

Strong programming skills (e.g., Python, Kafka, Java, Scala) with experience in distributed data processing technologies (e.g. Spark, Databricks, Apache Beam).

In-depth knowledge of data governance, quality, security, and compliance best practices within cloud-first or hybrid environments.

Proficiency with industry-standard tools for workflow orchestration (e.g., Airflow), data cataloging, and monitoring.

Experience in regulated industries and familiarity with relevant compliance standards is a plus.

Excellent problem-solving, communication, and collaboration skills within global and cross-functional teams.

Responsibilities

Key Responsibilities :

Design and develop robust, scalable, and secure data pipelines (batch and real-time) to ingest, process, and deliver data from multiple sources to Oracle Industry Applications.

Implement and optimize data architectures in cloud environments (OCI, AWS, Azure) including data lakes, data warehouses, ETL / ELT, and orchestration frameworks.

Collaborate with data architects to implement best practices for data modeling (conceptual, logical, and physical) and support platform-wide standards such as medallion architecture (Bronze / Silver / Gold).

Design and establish monitoring, alerting, and data quality frameworks to ensure reliability and accuracy of data pipelines.

Develop and enforce best practices for data security, lineage, metadata management, and compliance requirements.

Work closely with analysts, ML engineers, business stakeholders, and cross-functional teams to enable industry-specific data use cases and analytics for Oracle Industry Applications.

Evaluate, recommend, and onboard new data technologies to continuously improve platform performance and capabilities.

Lead troubleshooting and root cause analysis for data issues, ensuring continuous platform availability and reliability.

Mentor and guide junior data engineers and drive technical excellence and innovation across engineering efforts.

#LI-JF1

Disclaimer :

Certain US customer or client-facing roles may be required to comply with applicable requirements, such as immunization and occupational health mandates.

Range and benefit information provided in this posting are specific to the stated locations only

US : Hiring Range in USD from : $96,800 to $223,400 per annum. May be eligible for bonus and equity.

Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle's differing products, industries and lines of business.

Candidates are typically placed into the range based on the preceding factors as well as internal peer equity.

Oracle US offers a comprehensive benefits package which includes the following :

Medical, dental, and vision insurance, including expert medical opinion

Short term disability and long term disability

Life insurance and AD&D

Supplemental life insurance (Employee / Spouse / Child)

Health care and dependent care Flexible Spending Accounts

Pre-tax commuter and parking benefits

401(k) Savings and Investment Plan with company match

Paid time off : Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the first three years of employment and 18 days annually for subsequent years of employment. Vacation accrual is prorated for employees working between 20 and 34 hours per week. Employees working fewer than 20 hours per week are not eligible for vacation.

11 paid holidays

Paid sick leave : 72 hours of paid sick leave upon date of hire. Refreshes each calendar year. Unused balance will carry over each year up to a maximum cap of 112 hours.

Paid parental leave

Adoption assistance

Employee Stock Purchase Plan

Financial planning and group legal

Voluntary benefits including auto, homeowner and pet insurance

The role will generally accept applications for at least three calendar days from the posting date or as long as the job remains posted.

Career Level - IC4

About Us

As a world leader in cloud solutions, Oracle uses tomorrow's technology to tackle today's challenges. We've partnered with industry-leaders in almost every sector-and continue to thrive after 40+ years of change by operating with integrity.

We know that true innovation starts when everyone is empowered to contribute. That's why we're committed to growing an inclusive workforce that promotes opportunities for all.

Oracle careers open the door to global opportunities where work-life balance flourishes. We offer competitive benefits based on parity and consistency and support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs.

We're committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by emailing accommodation-request_mb@oracle.com or by calling +1 888 404 2494 in the United States.

Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans' status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.