Specialist.HR People Analytics

Reposted Yesterday
Be an Early Applicant
Irving, TX, USA
In-Office
Mid level
Security
The Role
Analyzes workforce data to produce enterprise reports, dashboards, survey insights, headcount and compensation analyses, and executive-ready recommendations. Maintains Oracle reporting platforms, Tableau dashboards, SQL queries, and advanced Excel models while using generative AI to improve productivity. Partners with HR and business leaders on hypothesis testing, business cases, data storytelling, governance, privacy, and confidential employee-data handling.
Summary Generated by Built In

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.

Skills Required

  • Bachelor's degree in Business Analytics, Human Resources, Finance, Statistics, Information Systems, or a related quantitative field
  • Four or more years of experience in business analytics, HR analytics, workforce reporting, finance, or management consulting
  • Hands-on experience modifying reports and dashboards in Oracle FDI, OAC, OTBI, or Tableau
  • Ability to write and modify basic SQL queries
  • Advanced Microsoft Excel proficiency, including complex formulas, pivot tables, and analytical data modeling
  • Practical experience using generative AI tools such as ChatGPT or Microsoft Copilot for analytical coding, formula generation, and task automation
  • Direct experience with Oracle HCM Fusion Data Intelligence, OTBI, or BIP reporting environments
  • Experience supporting employee engagement or survey platforms such as Perceptyx or Qualtrics
  • Experience working within an HR Center of Excellence or strategic shared-services advisory model

ADT Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about ADT and has not been reviewed or approved by ADT.

  • Retirement Support — A 401(k) with a per‑paycheck company match and the possibility of an additional year‑end contribution is positioned as competitive. Feedback suggests this is a reliable anchor of total compensation value.
  • Parental & Family Support — Paid parental leave, adoption/infertility support, and childcare discounts are highlighted as part of the package. Feedback suggests these offerings add meaningful non‑cash value across different employee groups.
  • Wellbeing & Lifestyle Benefits — Core medical/dental/vision coverage is paired with an EAP, wellbeing programs, and employee discounts, with noted emphasis on mental‑health initiatives. Eligibility beginning the first of the month after 31 days in many roles reinforces accessibility and day‑to‑day usefulness.

ADT Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Boca Raton, FL
21,118 Employees
Year Founded: 1874

What We Do

ADT is the most trusted brand in smart home and business security. Through innovative products, partnerships and the largest network of smart home security professionals in the United States, we connect and protect what matters most to our customers at home, work and on the go. For more information, visit www.adt.com.

Similar Jobs

Hilton Logo Hilton

Manager, HR Consulting

Events • Food • Travel • Hospitality • Hotels & Resorts
Hybrid
2 Locations
500000 Employees
40K-110K Annually

Caterpillar Logo Caterpillar

Architect

Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial • Industrial Equipment
Hybrid
Irving, TX, USA
100000 Employees
128K-209K Annually

Cloudflare Logo Cloudflare

Sr. Procurement Operations Lead, Infrastructure

Cloud • Information Technology • Security • Software • Cybersecurity
Hybrid
Austin, TX, USA
4400 Employees

Cloudflare Logo Cloudflare

Consultant

Cloud • Information Technology • Security • Software • Cybersecurity
Hybrid
Austin, TX, USA
4400 Employees
128K-224K Annually

Similar Companies Hiring

Nisos Thumbnail
Artificial Intelligence • Security • Business Intelligence • Consulting • Cybersecurity
Arlington, VA
70 Employees
Nasuni Thumbnail
Artificial Intelligence • Big Data • Cloud • Security • Software • Cybersecurity • Infrastructure as a Service (IaaS)
Boston, MA
550 Employees
Milestone Systems Thumbnail
Artificial Intelligence • Security • Software • Analytics • Big Data Analytics
Lake Oswego, OR
1500 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account