HR Data & Analytics Engineer; Oracle HCM

Job 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 SQL 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.

At NTT DATA, we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees have been key factors in our company's growth and market presence. By hiring the best people and helping them grow both professionally and personally, we ensure a bright future for NTT DATA and for the people who work here.

NTT DATA Services is a recognized leader in IT and business services, including cloud, data and applications, headquartered in Texas. As part of NTT DATA, a $30 billion trusted global innovator with a combined global reach of over 80 countries, we help clients transform through business and technology consulting, industry and digital solutions, applications development and management, managed edge-to-cloud infrastructure services, BPO, systems integration and global data centers.

We are committed to our clients' long-term success. Visit  or Linked In to learn more.

NTT DATA Services is an equal opportunity employer and considers all applicants without regard to race, color, religion, citizenship,…