Oracle HCM Architect - Full Time - Hartford, CT
Connecticut Children's · Hartford, CT · 3 days ago
HybridFull-time
Responsibilities
- Design, configure, and maintain Oracle Fusion HCM modules including Core HR, Benefits, Absence Management, Compensation, Talent, Recruiting (ORC), Learning.
- Create and manage HCM Extracts, BI Publisher (BIP) reports, and OTBI analyses and dashboards to support operational and regulatory reporting needs.
- Develop and maintain Fast Formulas for absence, eligibility, and benefits calculations.
- Build and maintain HDL (HCM Data Loader) and HSDL (HCM Spreadsheet Data Loader) templates for bulk data loading and migrations.
- Develop and support REST and SOAP API integrations between Oracle HCM and third-party systems (benefits carriers, background check vendors, learning platforms, etc.).
- Configure and manage Oracle Integration Cloud (OIC) flows and connections to support enterprise integrations.
- Administer Oracle HCM security, including the creation and management of roles, data roles, and role hierarchies in alignment with least-privilege principles.
- Perform functional configuration including workflows, approval rules (AME), flexfields, lookups, profile options, and notification templates.
- Develop complex OTBI, BIP, and HCM Extract-based reports to support HR operations, regulatory compliance, and executive decision-making.
- Design, build, and maintain People Analytics dashboards using Oracle Fusion HCM native tools and/or supplemental BI platforms.
- Prepare and submit regulatory reports including EEO-1, Affirmative Action Plan (AAP), OSHA, and ACA filings. Produce and maintain HR metrics reporting, including workforce analytics, turnover, headcount, compensation equity, and time-to-fill.
- Explore data to discover patterns, trends, anomalies, and opportunities for HR process improvement and workforce insights.
- Partner closely with the HRIS Team Lead on project prioritization, solution design, and delivery of HRIS roadmap initiatives.
- Engage with HR, Finance, IT, and operational stakeholders to gather requirements, translate them into technical designs, and validate solutions.
- Evaluate new Oracle HCM capabilities and emerging HR technology trends; develop proof-of-concept solutions and present recommendations to leadership.
- Support the HRIS team in training HR staff on system capabilities, self-service tools, and data reporting.
- Represent HRIS in cross-functional meetings, project workstreams, and technology governance forums.
- Aid in HR technology vendor evaluations, RFP processes, and implementation planning as needed.
Qualifications
- Education and/or Experience Required: Bachelor’s Degree in Information Technology, Computer Science, Human Resources Information Systems, or a related field. Minimum 7 years experience in Information Technology, Computer Science, Human Resources Information Systems or a related field.
- Education and/or Experience Preferred: Master of Science (MS) in Computer Science or an MBA in Technology Management. Experience: Oracle HCM (or full platform) implementation in solution architect role; understanding of both technical and HR functional business operations.
- Licenses and Certifications Required: Foundational Oracle Fusion Cloud Applications HCM Process Essentials.
- Licenses and Certifications Preferred: Oracle HCM Module-specific Professional Certification(s); Oracle Cloud Infrastructure (OCI) Solutions Architect Professional badge.
- Knowledge, Skills and Abilities: Technical: Oracle Fusion HCM (multi-module proficiency). Fast Formula, HCM Extracts, OTBI, BIP. HDL / HSDL data loading. REST & SOAP API development. Oracle Integration Cloud (OIC). Oracle HCM Security & role design. SQL and data querying. Quarterly update management. Professional: Strong analytical and problem-solving skills. Effective project management with working knowledge of Project and Agile Delivery (Agile Frameworks, Scrum/Kanban). Ability to manage multiple priorities and deadlines. Excellent written and verbal communication. Ability to translate business needs into technical solutions. Strong attention to detail and data accuracy. Collaborative team player with a service mindset. Proactive learner, stays current with Oracle HCM roadmap.