HR (Data Integration Oracle HCM to Azure)

Page Mechanical Group, Inc.; Winchester (VA); On-site; USD 68,880 - 96,432; Part time

Job summary

A leading mechanical services provider is seeking a Technical Contractor for HR Data Integration to support advanced data development in Winchester, VA or remotely. The contractor will develop complex SQL queries, work with Oracle HCM data, and ensure the accuracy of enterprise reporting. Candidates should have advanced SQL skills, experience with SQL Server and Oracle, and familiarity with Oracle Analytics tools. This contract role allows for independent work in a dynamic environment focusing on data integrity and quality.

Qualifications

• Advanced SQL experience with complex joins and performance optimization.
• Hands-on experience with SQL Server and Oracle SQL.
• Experience with Oracle HCM Cloud, both frontend and backend.

Responsibilities

• Develop and maintain SQL and database objects across SQL Server and Oracle.
• Support HR data replication and modernization for Oracle HCM.
• Partner with stakeholders to define and validate data requirements.

Skills

Advanced SQL experience

Hands-on experience with SQL Server and Oracle SQL

Experience with Oracle HCM Cloud

Experience using Oracle Analytics tools

Understanding of enterprise data warehousing

Clear documentation skills

Tools

SQL Server

Oracle SQL

Oracle Analytics (e.g., BI Publisher, BICC)

Job description

Technical Contractor – HR Data Integration

Location: Winchester, VA or Remote

Employment Type: Contract

About This Role

Our client is seeking an experienced contractor to support advanced data development and modernization efforts within their 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.

Key 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 and 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

Required Qualifications

• Advanced SQL experience, including complex joins, analytical/window functions, and performance optimization
• Hands‑on experience working with both SQL Server and 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

Required Soft 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

If you meet these qualifications and are interested in this contract opportunity, please submit your resume and a brief overview of your relevant experience.

We are an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, sex, national origin, age, disability, genetic information, or any other protected characteristic under federal, state, or local laws.

We are committed to employing only candidates who are legally authorized to work in the United States. For compliance with the Immigration Reform and Control Act of 1986, all new employees must complete the Employment Eligibility Verification Form I‑9 and provide documentation establishing identity and authorization to work. E‑Verify will be used for employment verification as part of the onboarding process.

We value integrity throughout our hiring process. Candidates will be asked to provide documentation confirming employment history, education, and work authorization.