Oracle HCM Cloud Developer -- 16811

Seneca Resources Company, LLC; Winchester (VA); Hybrid; USD 62,508 - 89,027; Full time

Job summary

A technology services provider is seeking an Oracle HCM Cloud Developer in Winchester, VA, with strong skills in Oracle HCM Cloud and SQL development. This role, which supports HR data modernization and analytics, involves developing SQL queries, transforming legacy HR data, and designing data models for enterprise analytics. The ideal candidate has 5–10 years of relevant experience and excellent analytical skills. The position offers a hybrid working arrangement with a competitive pay rate.

Qualifications

• 5–10 years of experience in Oracle HCM development, HR analytics, or data engineering.
• Advanced proficiency in SQL including performance tuning.
• Strong expertise in Oracle HCM Cloud data structures.

Responsibilities

• Develop and maintain SQL queries, stored procedures across Oracle and SQL Server.
• Modernize legacy HR data into Oracle HCM Cloud structures.
• Design data models and ETL processes for reporting and analytics.

Skills

Oracle HCM development

SQL development

HR analytics

Data engineering

Oracle SQL

SQL Server

Oracle BI Publisher

Data governance

Job description

Position Title: Oracle HCM Cloud Developer (HR Analytics / Data Engineering) Location: Winchester, VA (Remote / Hybrid) Clearance Requirements: None Position Status: Contract Pay Rate: $55/hour on w2

Position Description: We are seeking a skilled Oracle HCM Cloud Developer to support HR data modernization and analytics initiatives within a complex enterprise environment. This role is ideal for professionals with strong expertise in Oracle HCM Cloud, SQL development, and HR data engineering, who enjoy working on data transformation, reporting, and enterprise analytics solutions.

You will play a critical role in building and optimizing data pipelines, reporting structures, and analytics datasets, ensuring accurate and scalable HR data for business intelligence and decision-making.

Key Responsibilities

• Develop and maintain complex SQL queries, stored procedures, and database objects across Oracle and SQL Server environments
• Translate and modernize legacy HR data (SQL Server/PeopleSoft) into Oracle HCM Cloud-based structures
• Design and implement data models, ETL processes, and transformations for enterprise reporting and analytics
• Utilize Oracle BI Publisher (BIP) and BICC for data extraction, reporting, and validation
• Analyze Oracle HCM frontend configurations and backend data models to ensure data accuracy and alignment
• Collaborate with cross-functional teams to define data requirements, KPIs, and reporting logic
• Create and maintain data documentation (data lineage, mappings, business rules, governance artifacts)
• Perform data quality validation, reconciliation, and issue resolution across systems
• Support data governance and HR analytics initiatives

Required Skills/Education

Technical Qualifications:

• 5–10 years of experience in Oracle HCM development, HR analytics, or data engineering
• Advanced proficiency in SQL (joins, window functions, performance tuning)
• Hands-on experience with Oracle SQL and SQL Server
• Strong expertise in Oracle HCM Cloud (data structures, reporting, and functional concepts)
• Experience with Oracle BI Publisher (BIP) and BICC
• Experience working with or modernizing PeopleSoft or other legacy HR systems
• Solid understanding of data warehousing concepts (fact/dimension models, historical data design)
• Experience with data governance, metadata management, and documentation best practices

Soft Skills:

• Ability to work independently in a contract-based, fast-paced environment
• Strong analytical and troubleshooting skills for complex data issues
• Excellent communication and stakeholder collaboration skills
• High attention to detail with a focus on data accuracy and integrity
• Adaptability in dynamic environments with evolving requirements

Seneca Resources is proud to be an Equal Opportunity Employer, committed to fostering a diverse and inclusive workplace where all qualified individuals are encouraged to apply.