The posting
Job Description
Summary:
The Specialist.HR People Analytics serves as a key analytical contributor within the Total Rewards Center of Excellence (CoE), functioning as a primary resource for transforming raw workforce data into clear, actionable insights across the employee lifecycle. This individual supports enterprise reporting, maintains interactive dashboards, and executes hypothesis testing for HR business partners and senior leadership. Leveraging Oracle platforms (Fusion Data Intelligence, Oracle Analytics Cloud, OTBI/BIP) as the primary tools and Tableau as a secondary analytics platform, this role bridges workforce reporting and business decision-making with a commitment to data-driven outcomes and full ownership of analytical deliverables.
Additionally, this role incorporates Generative AI capabilities (e.g., ChatGPT, Microsoft Copilot) as a productivity engine to optimize complex Excel modeling, write and troubleshoot SQL scripts, and accelerate analytical deliverables. The ideal candidate embraces innovation fearlessly, collaborates inclusively across functions, and elevates the quality and accessibility of workforce data in service of a greater organizational purpose.
Duties and Responsibilities:
- Workforce Reporting & Oracle Administration: Extract, consolidate, reconcile, and maintain workforce data using Oracle HCM Fusion, OTBI, BIP, and Oracle HCM Fusion Data Intelligence (FDI); maintain an established publication schedule for weekly, monthly, and semi-annual reports across integrated and non-integrated systems, taking full accountability for accuracy and timeliness.
- SQL Scripting & Data Extraction: Write basic SQL scripts and modify existing query logic to extract, validate, and clean workforce datasets from enterprise databases, applying data-driven decision-making to fulfill evolving business requirements.
- Dashboard Development & Maintenance: Create, update, and refresh executive-ready dashboards and scorecards utilizing Oracle Analytics Cloud (OAC) and FDI as primary platforms and Tableau as a secondary visualization tool, enabling leadership to make informed, strategic decisions.
- GenAI-Assisted Workflow Optimization: Proactively utilize Generative AI tools (e.g., Copilot, ChatGPT) to draft and troubleshoot complex Excel formulas, refine SQL code syntax, automate repetitive reporting steps, and synthesize unstructured narrative data, boldly embracing innovation as a force multiplier for productivity and quality.
- Advanced Excel Modeling & Analysis: Apply advanced Excel functions (XLOOKUP, Pivot Tables, dynamic array formulas, nested logic) to execute headcount trend analyses, wage studies, and ROI program evaluations that support CoE strategic priorities.
- Employee Listening & Survey Analytics: Support enterprise employee listening strategies (e.g., Perceptyx); aggregate, clean, and analyze survey response data to evaluate drivers of engagement, performance, and retention risk, elevating the employee experience through data-informed insights.
- Cross-Functional Partnership & Hypothesis Testing: Partner with HR Business Partners, Compensation, Talent Management, and Business Unit Leaders to formulate hypotheses, gather requirements, perform cost and value analyses, and translate raw data into strategic business cases, intentionally uniting across functions to drive collective success.
- Data Storytelling & Business Presentations: Translate quantitative analytical outputs into clear tables, visual charts, and executive-ready summary content tailored for non-technical leadership and HR stakeholders, connecting data to organizational purpose and strategy.
- Data Governance & Confidentiality: Audit workforce datasets regularly to maintain strict data integrity, data privacy compliance, and confidential handling of employee information across all systems, building and sustaining trust through rigorous data governance practices.
Skills and Competencies:
- Advanced Excel Proficiency: Expert knowledge of Microsoft Excel required, including complex formula design, pivot tables, and analytical data modeling; demonstrated ability to leverage advanced functions to produce accurate, insightful, and decision-ready workforce analyses.
- Oracle & BI Tool Proficiency: Strong operational familiarity with Oracle HCM Fusion reporting tools (OTBI, BIP, FDI) and Oracle Analytics Cloud (OAC) as primary platforms, alongside working knowledge of Tableau; ability to own dashboard quality and publication cadence end-to-end.
- SQL & Query Modification: Ability to read, write, and modify basic-to-intermediate SQL queries to extract and transform relational database records in support of evolving business reporting requirements.
- Generative AI Fluency: Demonstrated comfort using Generative AI prompting techniques to accelerate code and formula creation, debug query errors, and streamline data workflows; willingness to fearlessly explore and adopt emerging tools to enhance analytical productivity.
- Analytical Thinking & Business Acumen: Strong quantitative logic with experience analyzing human capital data (turnover, compensation, headcount, engagement) to identify trends, solve underlying business challenges, and support data-driven decision-making at all levels of the organization.
- Communication & Customer Focus: Exemplary written and verbal communication skills; ability to translate technical findings into intuitive, compelling insights for non-technical partners while maintaining the highest standards of discretion and customer focus.
- Discretion & Governance: Deep commitment to HR principles of confidentiality, data privacy regulations, and ethical data governance, building trust across the organization through responsible and accurate handling of sensitive workforce information.
- Growth Mindset & Collaboration: Growth mindset with a commitment to continuous learning and inclusive collaboration; embraces new tools, methods, and diverse perspectives to elevate team and organizational capability.
Minimum Qualifications:
- Education: Bachelor's Degree from an accredited college or university in Business Analytics, Human Resources, Finance, Statistics, Information Systems, or a related quantitative field.
- Work Experience: 4 or more years of experience in a business analytics, HR analytics, workforce reporting, finance, or management consulting role.
- Technical & Tool Experience: Demonstrated hands-on experience modifying reports and dashboards in Oracle platforms (FDI, OAC, OTBI) or Tableau, writing and modifying basic SQL, and advanced Microsoft Excel usage.
- Generative AI Usage: Practical experience applying Generative AI productivity tools (e.g., ChatGPT, Microsoft Copilot) to assist with analytical coding, formula generation, and task automation.
Preferred Qualifications:
- Direct experience with Oracle HCM Fusion Data Intelligence (FDI), OTBI, or BIP reporting environments.
- Experience supporting enterprise employee engagement or survey platforms (e.g., Perceptyx, Qualtrics).
- Experience operating within an HR Center of Excellence (CoE) or strategic shared-services advisory model.
Working Conditions:
Communication Skills
- Strong written and verbal communication skills required; ability to communicate complex data findings clearly and effectively to both technical and non-technical audiences at all levels of the organization.
- Ability to develop and deliver clear reports, presentations, and executive-ready data visualizations that connect workforce insights to business strategy.
Environment Requirements
- Hybrid work environment; combination of remote work and on-site presence at ADT offices in Irving, TX as business needs require.
- Standard professional office setting when working on-site.



