Oracle HCM Architect - Full Time - Hartford, CT

Oracle HCM Architect
- Full Time
- Hartford, CT

Hartford, CT, United States (Hybrid)

Connecticut Children’s is the only health system in Connecticut that is 100% dedicated to children. Established on a legacy that spans more than 100 years, Connecticut Children’s offers personalized medical care in more than 30 pediatric specialties across Connecticut and in two other states. Our transformational growth establishes us as a destination for specialized medicine and enables us to reach more children in locations that are closer to home.

Our breakthrough research, superior education and training, innovative community partnerships, and commitment to diversity, equity and inclusion provide a welcoming and inspiring environment for our patients, families and team members.

At Connecticut Children’s, treating children isn’t just our job – it’s our passion. As a leading children’s health system experiencing steady growth, we’re excited to expand our team with exceptional team members who share our vision of transforming children’s health and well‑being as one team.

The Oracle HCM Architect is a hands‑on technical role within the Human Resources Information Systems (HRIS) team at Connecticut Children’s. This position works as an individual contributor role, works in close collaboration with the HRIS Team Lead and Team members and focuses on the configuration, development, integration, and ongoing optimization of Oracle Fusion HCM and its surrounding technology ecosystem.

This role carries broad technical responsibility across the Oracle Fusion HCM platform – to include but not limited to Core HR, Benefits, Absence Management, Talent Management, Compensation, Recruiting (ORC), Learning. The Cloud Solution Architect is the subject matter expert for Oracle HCM technical capabilities, including Fast Formula, HCM Extracts, Business Intelligence (OTBI and BIP), HDL/HSDL data loading, REST/SOAP APIs, and Oracle Integration Cloud (OIC).

While Oracle Payroll is managed outside of HR/HRIS by Information Systems (IS) and functionally owned by Finance, working knowledge is not required but a plus.

As a complement to the HRIS Team Lead role, this position provides deep technical execution capability – translating business requirements into Oracle HCM configurations, enhancements, integrations, reporting solutions and data analytics. The Oracle Fusion HCM Cloud Solution Architect serves as a technical escalation point, partners with IS, HR, Finance, and external vendors, and is responsible for maintaining system integrity, data quality, and continuous improvement of the HCM technology platform.

• Design, configure, and maintain Oracle Fusion HCM modules including Core HR, Benefits, Absence Management, Compensation, Talent, Recruiting (ORC), Learning.
• Develop and maintain Fast Formulas for absence, eligibility, and benefits calculations.
• Create and manage HCM Extracts, BI Publisher (BIP) reports, and OTBI analyses and dashboards to support operational and regulatory reporting needs.
• 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, AAP, OSHA, ACA filings and…