HR Reporting Analyst

Location: Dallas or Fortworth, TX (Hybrid- 3days oniste in a week)

Key Job Responsibilities

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

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

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

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

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

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

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

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

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