Demo

HR Data Integration Engineer (Oracle HCM to Azure)

Smksoft
Vienna, VA Full Time
POSTED ON 6/23/2026 CLOSED ON 6/28/2026

What are the responsibilities and job description for the HR Data Integration Engineer (Oracle HCM to Azure) position at Smksoft?

Description:

We are seeking an experienced contractor to support advanced data development and modernization efforts within our HR analytics environment. This role will focus on developing complex queries and database objects across SQL Server and Oracle platforms, with a strong emphasis on sourcing, transforming, and validating Oracle HCM data to support enterprise reporting, analytics, and historical data needs.

Responsibilities

  • Develop and maintain complex SQL and database objects across SQL Server and Oracle environments.

  • Support HR data replication and modernization, translating legacy SQL Server logic to Oracle HCM sourced data.

  • Design and implement data structures, transformations, and database objects for analytics, reporting, and downstream consumption.

  • Leverage Oracle Analytics tools (e.g., BI Publisher) to source, validate, and interpret Oracle HCM data and reporting logic.

  • Analyze Oracle HCM frontend functionality and backend data structures to ensure accurate data usage.

  • Partner with technical, analytics, and business stakeholders to define and validate requirements, metrics, and data logic.

  • Create and maintain technical requirements, data documentation, including data definitions, business rules, source-to-target mappings, data lineage, and governance artifacts.

  • Contribute to data quality checks, reconciliations, and cross-system issue resolution.

  • Other duties as assigned.

Qualifications

  • Advanced SQL experience, including complex joins, analytical/window functions, and performance optimization.

  • Hands-on experience working with both:

    • SQL Server

    • Oracle SQL

  • Strong experience with Oracle HCM Cloud, including both frontend configuration concepts and backend data structures.

  • Experience using Oracle Analytics tools such as BI Publisher (BIP) and BICC for reporting, data extraction, or validation.

  • Experience working with or modernizing data from legacy HR systems such as PeopleSoft.

  • Solid understanding of enterprise data warehousing concepts, including fact tables and historical data design.

  • Proven ability to produce clear, well-structured technical documentation supporting data governance initiatives.

Skills

  • Ability to work independently as a contractor and deliver on clearly defined outcomes

  • Strong analytical and problem-solving skills, particularly when troubleshooting data or report logic

  • Clear communication skills to collaborate with technical and non-technical stakeholders

  • Adaptability in environments with evolving requirements and frequent system changes

  • Attention to detail and commitment to data accuracy and quality

Salary : $50 - $60

If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

What is the career path for a HR Data Integration Engineer (Oracle HCM to Azure)?

Sign up to receive alerts about other jobs on the HR Data Integration Engineer (Oracle HCM to Azure) career path by checking the boxes next to the positions that interest you.
Income Estimation: 
$92,929 - $122,443
Income Estimation: 
$122,257 - $154,284
This job has expired.
Employees: Get a Salary Increase
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at Smksoft

  • Smksoft Vienna, VA
  • Role: Portfolio Management Office (PMO) Manager Hybrid Role in Vienna, VA JD: Responsibilities Work in a team focused on planning, managing, and governing ... more
  • 1 Day Ago

  • Smksoft Vienna, VA
  • Description This role focuses on production support , issue triage , and coordination of standard, repeatable support activities to ensure system stability... more
  • 2 Days Ago

  • Smksoft Pensacola, FL
  • Supports the Project Management function by coordinating project tasks, maintaining documentation, and facilitating communication among project teams and s... more
  • 2 Days Ago

  • Smksoft Pensacola, FL
  • Description: To implement and facilitate training programs for assigned areas of company. Collaborate with the Instructional Designers and test the develop... more
  • 2 Days Ago


Not the job you're looking for? Here are some other HR Data Integration Engineer (Oracle HCM to Azure) jobs in the Vienna, VA area that may be a better fit.

  • Volume Integration Chantilly, VA
  • Join a collaborative, mission-driven team where your leadership in Python, ETL, and cloud data engineering will directly shape scalable data solutions supp... more
  • 16 Days Ago

  • NTT DATA, Inc. Bethesda, MD
  • Req ID: 376207 NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive... more
  • 1 Day Ago

AI Assistant is available now!

Feel free to start your new journey!