Oracle HCM Architect Hartford, CT

Oracle HCM Architect

The Oracle HCM Architect is a hands‑on technical role within the Human Resources Information Systems (HRIS) team at Connecticut Children’s. This position is 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.

• Design, configure, and maintain Oracle Fusion HCM modules including Core HR, Benefits, Absence Management, Compensation, Talent, Recruiting (ORC), and 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, 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.
• Serve as a technical resource for data governance, ensuring data accuracy, integrity, and consistency across HCM and downstream systems.

• Architect, develop, and maintain integrations between Oracle Fusion HCM and internal/external systems using OIC, REST APIs, HCM Extracts, and third‑party middleware.
• Design and execute data migration strategies using HDL/HSDL for system upgrades, conversions, and ongoing data management needs.
• Monitor integration health and proactively resolve data issues, interface failures, or discrepancies between systems.
• Maintain and expand Oracle HCM’s connectivity with adjacent enterprise platforms including ERP/Finance, scheduling, learning management, and benefits administration systems.

• 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 work streams, and technology governance forums.
• Assist with HR technology vendor evaluations, RFP processes, and implementation planning as needed.

• Manage Oracle quarterly update cycles: review release notes, assess feature impact, coordinate regression testing, configure opt‑in features, and communicate changes to stakeholders.
• Administer development/sandbox and test environments; design and execute unit, integration, and regression test plans for system changes and upgrades.
• Provide Tier 2/3 production support, troubleshooting…