Data & BI Analyst jobs

Specialist.HR People Analytics

ADTIrving, TXHybridPosted 3 days ago

Pay not listed

Key facts

Experience
4+ years
Degree
Bachelor's degree

Looks real. 1 thing to check before you apply.

On ADT’s own careers site (Oracle Recruiting), checked open today.

  • To check: No pay range listedAsk for the pay range before you interview.
  • Checked: On the company's own careers siteOracle Recruiting board
  • Checked: Checked open todayOracle Recruiting board
  • Checked: No reposts foundOracle Recruiting board
  • Trust score 89 / 100 · Looks good
See all 5 checksShow fewer
How we check

What you’ll do

  • Extract, reconcile, validate, and maintain workforce data and scheduled reports using Oracle platforms and SQL.
  • Develop and refresh executive dashboards and scorecards in Oracle Analytics Cloud, FDI, and Tableau.
  • Analyze headcount, wages, program ROI, and employee survey data to identify trends and inform decisions.
  • Partner with HR and business stakeholders to test hypotheses, perform cost and value analyses, and develop business cases.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • 4 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 platforms (FDI, OAC, OTBI) or Tableau
  • Experience writing and modifying basic SQL
  • Practical experience using Generative AI productivity tools for analytical coding, formula generation, and task automation
  • Direct experience with Oracle HCM Fusion Data Intelligence (FDI), OTBI, or BIP reporting environments (preferred)
  • Experience supporting enterprise employee engagement or survey platforms such as Perceptyx or Qualtrics (preferred)
  • Experience in an HR Center of Excellence (CoE) or strategic shared-services advisory model (preferred)

Education

  • Bachelor’s degree in Business Analytics, Human Resources, Finance, Statistics, Information Systems, or a related quantitative field

Skills

  • Advanced Microsoft Excel usage

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Full job description

From ADT’s careers site

Summary:

Show full descriptionShow less

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.

Something wrong with this job? Report it · This flag looks wrong

Similar jobs nearby

Data Management Specialist

Career Team · Denton, TX +1 place

$45k–$52k/yrFull-timeHybrid

StrongChecked open todayPosted 9 days ago

Data Analytics Manager

Public Storage · Frisco, TX

Full-time

StrongPay not listedChecked open todayPosted 1 month ago

Data Manager

Iterative Health · Cambridge, MA +2 places

$125k–$160k/yrHybrid

StrongOpen 2 monthsChecked open todayPosted 2 months ago

Data Analyst

Inspire11 · Dallas, TX +1 place

$10,000/moOn-site

Looks goodOpen 8 monthsChecked open todayPosted 8 months ago

See more like this