Entry Level Oracle Data Analyst Jobs in Texas (NOW HIRING)

Job Summary:
NTT DATA North America is a leader in IT and business services, and they are seeking an HR Data & Analytics Engineer to enhance their HR reporting capabilities. The role involves designing and maintaining HR analytics solutions, supporting reporting needs across HR functions, and ensuring data integrity within Oracle HCM.
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.
Qualifications:
Required:
• 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.
Company:
NTT DATA, Inc. is a trusted global innovator of business and technology services. Founded in 1988, the company is headquartered in Plano, USA, with a team of 10001+ employees. The company is currently Late Stage.