Oracle HCM Architect - Full Time - Hartford, CT

Connecticut Children's; Hartford (CT); On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

Restaurant d'entreprise

Job summary

Connecticut Children’s seeks an Oracle HCM Architect to lead hands‑on configuration, development, and integration of Oracle Fusion HCM within the HRIS team. You will implement modules, build HDL/HSDL templates, and develop REST/SOAP integrations with external systems to support HR operations and regulatory reporting.

You will design OTBI/BIP dashboards, manage security and quarterly updates, and partner with stakeholders to drive data accuracy and workforce insights.

Qualifications

• Bachelor's degree in IT, CS, HRIS or related field.
• Minimum 7 years in IT/HRIS or related field; equivalent experience may substitute for degree.
• Foundational Oracle Fusion Cloud Applications HCM Process Essentials certification.
• MS in CS or MBA in Technology Management is a plus.

Responsibilities

• Design, configure, and maintain Oracle Fusion HCM modules (Core HR, Benefits, Absence, etc.).
• Develop and maintain formula-based calculations for benefits and absences.
• Create and manage HCM Extracts, BI Publisher reports, OTBI analyses and dashboards.
• Build HDL/HSDL templates for bulk data load and migrations.
• Develop and support REST and SOAP API integrations with third‑party systems.
• Configure Oracle Integration Cloud (OIC) flows and connections for integrations.
• Administer Oracle HCM security, roles, and data access controls.
• Perform functional config including workflows, approvals, flexfields, and notifications.

Skills

Oracle Fusion HCM

Fast Formula

HCM Extracts

OTBI

BIP

HDL/HSDL

REST API development

SOAP API development

Oracle Integration Cloud

HCM Security & Roles

SQL

Quarterly update management

Education

Bachelor’s Degree in Information Technology, Computer Science, HRIS, or related

Master of Science in CS or MBA in Tech Management

Job description

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.

Responsibilities

Oracle Fusion HCM Configuration & Development (25%)

• 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.

Reporting & Analytics (25%)

• 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.

Integrations & Data Management (20%)

• 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.

Collaboration & Continuous Improvement (20%)

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

System Administration & Support (10%)

• 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 complex technical issues and partnering with Oracle Support (Tier 4 – SR management) as needed.
• Maintain comprehensive technical documentation including configuration workbooks, data dictionaries, integration specifications, and user guides.
• Monitor system performance, identify optimization opportunities, and implement tuning measures as appropriate.
• Perform other job‑related duties as assigned.

Qualifications

Education and/or Experience Required

• Education:
• Bachelor’s Degree in Information Technology, Computer Science, Human Resources Information Systems, or a related field.
• Experience:
• Minimum 7 years experience in Information Technology, Computer Science, Human Resources Information Systems or a related field. Equivalent combination of education and relevant experience may substitute for degree requirements and Oracle technology implementation and production maintenance & support.

Education and/or Experience Preferred

• Education:
• 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.

License and/or Certification Required

• Foundational Oracle Fusion Cloud Applications HCM Process Essentials.

License and/or Certification 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.

About Us

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.