HR Reporting Analyst

Role: HR Reporting Analyst Location: Dallas or Fortworth, TX (Hybrid- 3days onsite in a week) 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.