Oracle Cloud HCM Senior Analyst - HYBRID

NTT DATA Services•Fort Worth, TX

22h•$102,675 - $171,125•Hybrid

About The Position

NTT DATA is seeking an Oracle Cloud HCM Senior Analyst to join their team. This hybrid role involves designing, building, and maintaining HR reports and dashboards, supporting Oracle Cloud/HCM reporting environments, and managing data models and structures. The analyst will also be responsible for writing advanced SQL queries, developing BI reports and dashboards using various tools, ensuring data quality and integrity, supporting testing activities, and documenting reporting solutions. A strong understanding of HR data, processes, and stakeholder partnership is essential.

Requirements

5+ years of experience in HR reporting, HR analytics, HRIS reporting, or related Oracle Cloud HCM reporting roles.
5+ years of Strong hands-on experience with Oracle Cloud / Oracle HCM reporting (Power BI is a plus)
5+ years of experience in Advanced SQL skills
5+ years of Experience sourcing, joining, cleaning, and transforming HR data
BI/report development experience using tools such as: Oracle reporting tools – BIP, HCM extract, OTBI

Nice To Haves

Strong understanding of relational database theory
Strong understanding of data warehouse concepts
Experience with data modeling and data architecture
BI/report development experience using tools such as: Oracle SQL Developer, Tableau/ Power BI, Excel, SAS or similar reporting/analytics tools
Experience building dashboards, operational reports, scheduled reports, and data extracts
Data validation and reconciliation experience
Experience documenting reporting logic, data flows, and data model
Ability to support testing for reporting changes, system releases, and data integrations
Strong understanding of HR data and HR business processes
Familiarity with employee lifecycle reporting, including hire-to-retire concepts
Knowledge of HRIS procedures and reporting practices
Ability to work with confidential employee data
Understanding of HR compliance, retention, and data governance expectations
Ability to gather and translate HR business requirements into reporting deliverables
Ability to partner with HR, IT, and business stakeholders
Strong communication skills with both technical and non-technical audiences

Responsibilities

Design, build, maintain, and enhance HR reports, dashboards, crosstabs, metrics, and recurring reporting deliverables.
Support both ad hoc and scheduled reporting needs across HR functional areas.
Create reporting solutions that monitor HR operations and support strategic decision-making.
Work heavily within Oracle Cloud / Oracle HCM reporting environments including HCM extracts.
Query, extract, analyze, and report on employee records and HR data from Oracle and related HR systems.
Support Oracle reporting tools and related technologies used for operational and analytical reporting.
Understand Oracle data structures, subject areas, joins, and reporting logic to support accurate reporting outputs.
Partner with HRIS and IT teams to ensure source system data is available, reliable, and structured appropriately for reporting projects.
Manage and support access profiles, security profiles, and Security Console configurations to help ensure HR data is accessible only to intended users and aligned with role-based security requirements.
Design and develop data models that support scalable HR dashboards, operational reports, and analytics solutions.
Source, clean, join, transform, and structure HR data from multiple systems and data sources.
Apply relational database theory, data warehouse concepts, and data modeling principles to reporting solutions.
Build datasets that support interactive dashboards and recurring report automation.
Identify data structure issues and recommend improvements to strengthen reporting infrastructure, reliability, and data accuracy.
Write, optimize, and troubleshoot advanced SQL queries.
Use joins, case statements, subqueries, cursors, and other SQ or PL/SQL techniques to extract and transform HR data.
Support development and maintenance of operational reporting using query tools.
Perform data validation, reconciliation, and issue investigation.
Work independently with complex datasets and reporting logic.
Design and develop interactive dashboards, list reports, charts, crosstabs, and analytical reporting outputs.
Use BI/reporting tools such as Oracle reporting tools – FDI/OTBI/ BIP, Tableau, Power BI, SQL Developer, or similar platforms.
Build reporting assets that are user-friendly, reliable, and suitable for HR and leadership audiences.
Create metrics, visualizations, variance views, trend reports, and other analytical outputs that help tell the story behind the data.
Support centralized reporting management, automation, and dashboard maintenance.
Develop automated validation reports and processes to ensure HR data integrity.
Reconcile data across systems, identify discrepancies, and partner with HRIS/IT teams to resolve issues.
Test reporting outputs for accuracy, completeness, logic consistency, and alignment with business requirements.
Highlight potential areas of concern with existing reporting and recommend improvements.
Support quality control for recurring reports, dashboards, and data extracts.
Support testing activities related to Oracle Cloud releases, HR system enhancements, reporting changes, and new data integrations.
Partner with IT teams during release cycles, enhancement testing, issue resolution, and defect triage.
Document report logic, data definitions, data sources, data flow diagrams, and data model.
Support knowledge transfer to internal team members.
Ensure reporting solutions are maintainable and understandable after contractor engagement ends.
Apply practical knowledge of HR processes, HR data, HRIS procedures, Employee lifecycle events, and HR reporting needs.
Understand sensitive HR data handling expectations, confidentiality requirements, and retention considerations.