HR Reporting Analyst

Title: HR Reporting Analyst

Location: Fort Worth TX (Hybrid)

Type: Contract

Key Job Responsibilities:

HR Reporting & Analytics Delivery

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

Oracle Cloud / HCM Reporting Support

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

Data Modeling Data Architecture & Data Wrangling

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

SQL

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

BI Development & Dashboarding

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

Data Validation Quality & Controls

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

Testing & Release Support

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

Documentation & Knowledge Transfer

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

HR Domain Knowledge & Stakeholder Partnership

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