Specialist.HR People Analytics

ADT; Irving (TX); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Hybrid work model

On-site in Irving, TX

Equal Employment Opportunity (EEO)

Job summary

ADT seeks a Specialist.HR People Analytics to translate workforce data into actionable insights across the employee lifecycle. You’ll support enterprise reporting, maintain interactive dashboards, and test hypotheses for HR and senior leaders using Oracle HCM Fusion, OTBI, BIP, FDI, and Tableau.

Generative AI will boost Excel modeling and SQL tasks, accelerating analytical deliverables. You’ll partner across HR and business units, drive data-driven decisions, and uphold strict data governance in

Qualifications

• Bachelor's degree in a quantitative field.
• 4+ years in analytics, HR analytics, workforce reporting, finance, or consulting.
• Hands-on experience with Oracle reporting tools (FDI, OAC, OTBI) or Tableau.
• Basic SQL skills and advanced Excel usage.
• Experience applying Generative AI to analytics tasks.

Responsibilities

• Transform raw workforce data into actionable insights across the employee lifecycle.
• Support enterprise reporting, maintain dashboards, and run hypothesis tests for leaders.
• Develop and publish executive dashboards using Oracle Analytics Cloud and Tableau.
• Leverage Generative AI to accelerate modeling, SQL debugging, and reporting.
• Perform headcount, wage, and ROI analyses to support CoE priorities.
• Collaborate with HRBPs, Compensation, Talent Management, and BU leaders.
• Translate data outputs into clear, executive-ready presentations.
• Uphold data governance, privacy, and confidentiality standards.

Skills

Advanced Excel

Oracle HCM Fusion

OTBI

BIP

FDI

Oracle Analytics Cloud

Tableau

SQL

Generative AI Fluency

Analytical Thinking

Communication

Data Governance

Collaboration

Education

Bachelor's Degree in Business Analytics or related field

Tools

Oracle HCM Fusion

OTBI

BIP

FDI

Oracle Analytics Cloud

Tableau

Excel

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.

3022676

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.

In the event a position is commission based, compensation is solely based on the individual’s sales volume. This applies only to commission roles.

Los Angeles Applicants: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.

Philadelphia Applicants: Background checks will be conducted during the employment process. Any information will be reviewed through an individualized assessment in accordance with the Philadelphia Fair Criminal Record Screening Standards Ordinance.

ADT is an Equal Employment Opportunity (EEO) Employer. We celebrate diversity and are committed to building an inclusive team that represents a variety of backgrounds, perspectives and skills. ADT strives to ensure every employee and applicant feels valued. Visit us at jobs.adt.com/diversity to learn more.