Human Capital Analyst - Senior

#WeAreONEOK – Fortune 500 company. 100+ years in business. Leading midstream service provider. Safety first. Sustainable operations. Environmentally responsible. Employee focused.

JOB SUMMARY

ONEOK is seeking a human capital analyst to support HR's strategic vision, as well as the broader organization's objectives, through the deployment of trusted, accurate, and accessible HR data solutions. This role will provide commonly requested HR metrics, such as headcount, turnover, and internal mobility statistics via interactive dashboards, shifting from point-in-time static reports to proactive data storytelling and data literacy support. An emphasis on developing collaborative and data-driven partnerships between HR and business leaders is desired.

Essential Functions and Responsibilities

Responsible for business intelligence functions:

• Design, validate and publish enterprise-wide data solutions focusing on essential HR functions for use by both members of HR and leaders within the business, including but not limited to, core workforce metrics, talent acquisition, total rewards, and employee development

• Establish extract, transform, and load processes for source data to be used in business intelligence dashboards both independently and through partnerships with data and technology teams

• Visualize HR metrics through the use of well-designed and interactive dashboards deployed in a variety of tools, including PowerBI, TIBCO Spotfire, Microsoft Power Query and Power Pivot, and Prism Analytics

• Inform long-term strategy for HR data delivery and automation, while ensuring secure access and data literacy of published metrics

• Partner with specialized teams within HR to define and publish commonly requested data, as well as conduct ad-hoc exploratory analyses to support HR initiatives

• Write and validate advanced reports in Workday for stakeholders across the organization

• Automate routine report creation for the broader HR team through the use of tools such as Microsoft Power Query, Power Pivot and Power Automate

Identify and evaluate business data needs to support workforce management needs including attraction, selection, retention, development, succession planning, organizational design

• Compile data from all existing formats (HCM, Excel, ERP, KBace, etc.)

• Verify and Audit data

• Analyze data to identify trends, issues, business needs, etc.

• Consult for business on data analysis to support workforce/HC management

Data Oversight and Management

• Act as a consultative partner with HRIS and other stakeholders to maintain data quality in a variety of HR technology platforms

Responsible for reporting inclusive of:

• AA Plans (compiling, report building, filing, analyzing, presenting, consulting)

• VETS 4212 (compiling, report building, filing)

• EEOC (compiling, report building, filing)

• Gather data from disparate systems, integrate, compile, format, audit, analyze, submit

• ESG Reporting and Analysis

• Ad Hoc Reporting and Consulting

• Workday Reporting

• Ongoing HR Metrics Reporting (e.g. quarterly for Talent Management around D&I, Recruiting and Hiring)

• Ongoing reporting for Board Meetings (D&I)

• Standard Reports for the business (e.g. Assignment Report, Salary Planning Report) inclusive of data collection and integration, analysis and presentation/consultation for the business

Education

• Bachelor's Degree in related field and/or a combination of related knowledge, skills, and abilities in human resource data analytics

Work Experience

• 3 - 5 years related work experience in data analytics related to human resources compliance, ESG reporting and analysis, and data management

Knowledge, Skills and Abilities

• Knowledge of: HR Compliance reporting (AA, VETS, EEOC, etc.)

• Knowledge of: ESG Reporting and Analysis

• Knowledge of: BI Tools: PowerBI, TIBCO Spotfire, Microsoft Power Query and PowerPivot, and Prism Analytics

• Knowledge of: HRIS Platforms: Workday preferred, but experience with pulling HR data from an HRIS platform required

• Ability to: utilize advanced excel and ability to create calculated fields

• Ability to: interact, advise, guide, train, and communicate effectively

• Ability to: communicate and/or exchange written and verbal information and instructions; and conduct oral presentations

Licenses and Certifications

• HR Certifications: SHRM-CP or PHR preferred but not required

Strength Factor Rating - Physical Demands/Requirements

• Sedentary Work - Exerting up to 10 pounds of force occasionally (Occasionally: activity or condition exists up to 1/3 of the time) and/or a negligible amount of force frequently (Frequently: activity or condition exists from 1/3 to 2/3 of the time) to lift, carry, push, pull, or otherwise move objects, including the human body. Sedentary work involves sitting most of the time, but may involve walking or standing for brief periods of time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.

Strength Factor Description - Physical Demands/Requirements

• Standing: Remaining on one's feet in an upright position at a work station without moving about (Occasionally)

• Walking: Moving about on foot (Frequently)

• Sitting: Remaining in a seated position (Constantly)

• Lifting: Raising or lowering an object from one level to another (includes upward pulling) (Occasionally)

• Carrying: Transporting an object, usually holding it in the hands or arms, or on the shoulder (Occasionally)

• Pushing: Exerting force upon an object so that the object moves away from the force (Occasionally)

• Pulling: Exerting force upon an object so that the object moves toward the force (includes jerking) (Occasionally)

• Climbing: Ladders, Stairs (Occasionally)

• Balancing: Maintaining body equilibrium to prevent falling (Occasionally)

• Stooping: Bending the body downward and forward by bending the spine at the waist (Occasionally)

• Kneeling: Bending the legs at the knees to come to rest on the knee or knees (Occasionally)

• Crouching: Bending the body downward and forward by bending the legs and spine (Occasionally)

• Crawling: Moving about on the hands and arms in any direction (Occasionally)

• Reaching: Extending hands and arms in any direction (Constantly)

• Handling: Seizing, holding, grasping, turning or otherwise working with the hand or hands (Manual Dexterity) (Constantly)

• Fingering: Picking, pinching or otherwise working with the fingers primarily (Finger Dexterity) (Constantly)

• Feeling: Perceiving such attributes of objects/materials as size, shape, temperature, texture, movement or pulsation by receptors in the skin, particularly those of the finger tips (Constantly)

• Talking: Expressing or exchanging ideas/information by means of the spoken word (Frequently)

• Hearing: Perceiving the nature of sound by the ear (Frequently)

• Tasting/Smelling: (Occasionally)

• Near Vision: Clarity of vision at 20 inches or less (Constantly)

• Far Vision: Clarity of vision at 20 feet for more (Frequently)

• Depth Perception: Three-dimensional vision; ability to judge distances and spatial relationships so as to see objects where and as they actually are (Frequently)

• Vision: Color - The ability to identify and distinguish colors (Constantly)

Working Conditions/Environment

• Employee is subject to inside environmental conditions

Working Conditions

• Well lighted, climate controlled areas (Constantly)

• Frequent repetitive motion (Constantly)

• CRT (Computer Monitor(s)) (Constantly)

Travel

• Travel to other locations required.

Driving

• Based on assigned tasks, employee may be assigned a company vehicle requiring the applicable driver's license

ONEOK is an equal opportunity employer committed to diversity and inclusion. All qualified applicants will receive consideration for employment without regard to race, color, sex, pregnancy, sexual orientation, age, religion, creed, national origin, gender identity, disability, military/veteran status, genetic information or any other categories protected by applicable law.

The job description is not intended to be a complete list of all responsibilities, duties or skills required for the job and is subject to review and change at any time, with or without notice, in accordance with the needs of ONEOK.

ONEOK is committed to making our workplace accessible to individuals with disabilities and will provide reasonable accommodations, upon request, for individuals to participate in the application and hiring process. To request an accommodation email [email protected] or call 1-855-663-6547​. #LI-HYBRID

Expected Salary Range

$87,000.00 - $131,000.00