HR Data Integration Oracle
Data Integration Oracle HCM to Azure
Multiyear Contract
Hybrid – Winchester, VA – 3 days a week on-site
Hourly Rate: $55/hr. Range W2 System One IT has 3 openings for experienced HR Data Integration Analysts to support advanced data development and modernization efforts within our client’s 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, 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.
- 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.
- 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
System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic, veteran, marital status, or any other characteristic protected by applicable federal, state, or local law.
#M-MM1
#LI-MM1 Ref: #851-Rockville-S1
Recommended Jobs
Sr Information Security Advisor /AWS (Secret Cleared)
Public Trust: None Requisition Type: Regular Your Impact Own your opportunity to work alongside federal civilian agencies. Make an impact by providing services that help the government ens…
Systems Architect
: Why choose between doing meaningful work and having a fulfilling life? At MITRE, you can have both. That's because MITRE people are committed to tackling our nation's toughest challenges—and we're…
Tax Manger (HNW/ Estates & Trusts) - Richmond, VA (Work from Home Possible)
Our client is a 150 staff CPA firm in the city of Richmond, VA. They have a heavy focus on working with high net worth individuals and their privately held companies and pride themselves on offering …
Commercial Aquatic Systems Sales & Service Technical Manager
Job Description Job Description Overview Now Hiring: Commercial Aquatic Systems Sales & Service Technical Manager Territory: Northern Virginia, Washington DC & Surrounding Areas Com…
CDL A Truck Driver
Job Description Job Description We're recruiting experienced CDL A drivers for a carrier partner offering regional routes with consistent weekly home time. This position provides the stability an…
Housekeeping and Apparel Manager - Human Performance and Wellness Department
Virginia Military Institute is excited to announce our open position in Department Human Performance and Wellness. This is a key position to help coordinate the needs of the Department and Cormack Hal…
Wal-Mart Overnight Stocker
Wal-Mart Overnight Stocker - $19.50/Hr. *Weekly Pay*Full-Time* Project Based* Flexible*Paid Training* Entry Level - No Experience Necessary This is a project based, direct hire position with o…
Electrical Field Technician - UPS / ATS / Generators / Switchgear / Transformers / PLC
Job Details: Electrical Field Technician - UPS / ATS / Generators / Switchgear / Transformers / PLC URGENT NEED! The Field Service Technician supports customers' field operations. In this h…
C2 Data and AI Capability SME
Job Description Job Description The Challenge: The modernization of enterprise command and control (C2) depends on trusted data, disciplined governance, and AI-enabled decision support that ca…
Quarry Utility Worker
$1,500 Sign-on Bonus! Rockydale Quarries Corporation, an established aggregate producer, is looking for a Utility worker for its Glade Hill, Virginia location. Must possess the ability to operate…