Senior HR Data Analyst

CAI; United States; Remote; USD 96,000 - 106,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

401k retirement account access

Paid sick leave and/or other paid time

Job summary

CAI seeks a Senior HR Data Analyst (contract, remote) to support complex HR reporting, data analytics, dashboard development, and reporting automation. The role emphasizes replacing manual processes with data-driven solutions to improve efficiency, accuracy, and sustainability.

Key duties include maintaining and transforming HR reports, building dashboards in Power BI, and leveraging AI and automation to reduce time and complexity.

Qualifications

• Bachelor’s degree in Data Analytics, Business Analytics, Data Science, Information Systems/MIS, Statistics, or another quantitative discipline
• 8+ years of related professional experience in data analytics, advanced reporting, reporting automation, and process improvement
• Advanced Microsoft Excel proficiency, including advanced formulas, pivot tables, macros, conditional formatting, data manipulation, and tools for analyzing and automating complex reporting
• Experience developing dashboards, metrics, and data visualizations using Power BI, Excel, or similar tools
• Experience using AI, automation tools, or other emerging technologies to improve data analysis, reporting, or business processes
• Demonstrated ability to simplify and automate manual reporting processes to improve efficiency, accuracy, and sustainability
• Strong analytical and problem-solving skills, with the ability to translate complex data into meaningful insights for business leaders
• Experience working with complex datasets and reporting processes
• Attention to detail and a commitment to data accuracy and integrity
• Ability to understand complex workflows and produce clear, detailed process documentation and step-by-step instructions
• Ability to work independently in a project-based environment, manage multiple priorities, and proactively implement solutions

Responsibilities

• Maintain existing HR reporting and analyze, manipulate, and format complex datasets using advanced Microsoft Excel features, including formulas, pivot tables, macros, conditional formatting, filters, and related tools
• Transform and optimize Excel-based reporting workflows by identifying opportunities to simplify and automate manual processes
• Apply advanced Excel capabilities, AI, automation tools, and emerging technologies to reduce manual effort, reporting complexity, and report production time
• Build dashboards, metrics, and data visualizations to give business leaders visibility into trends and key insights
• Use Power BI, Excel, and other reporting and visualization tools to convert complex information into clear, understandable outputs
• Identify opportunities to improve the efficiency, accuracy, and sustainability of current reporting and business processes
• Create and keep process documentation that explains existing reporting workflows and step-by-step procedures
• Update documentation as workflows are optimized and automated to maintain accurate, standardized, and sustainable operations
• Work independently in a project-based environment, manage multiple priorities, and proactively identify and implement solutions

Skills

Advanced Excel

Power BI

AI

Macros

Pivot tables

Conditional formatting

Data manipulation

Education

Bachelor's degree in Data Analytics/Business Analytics/Data Science or quantitative field

Tools

Microsoft Excel

Power BI

AI tools

Job description

CAI is seeking a Senior HR Data Analyst (contract, remote) to support complex HR reporting, data analytics, dashboard development, and reporting automation. The role focuses on replacing manual processes with data-driven solutions that improve efficiency, accuracy, and reporting sustainability.

Key Responsibilities

• Maintain existing HR reporting and analyze, manipulate, and format complex datasets using advanced Microsoft Excel features, including formulas, pivot tables, macros, conditional formatting, filters, and related tools
• Transform and optimize Excel-based reporting workflows by identifying opportunities to simplify and automate manual processes
• Apply advanced Excel capabilities, AI, automation tools, and emerging technologies to reduce manual effort, reporting complexity, and report production time
• Build dashboards, metrics, and data visualizations to give business leaders visibility into trends and key insights
• Use Power BI, Excel, and other reporting and visualization tools to convert complex information into clear, understandable outputs
• Identify opportunities to improve the efficiency, accuracy, and sustainability of current reporting and business processes
• Create and keep process documentation that explains existing reporting workflows and step-by-step procedures
• Update documentation as workflows are optimized and automated to maintain accurate, standardized, and sustainable operations
• Work independently in a project-based environment, manage multiple priorities, and proactively identify and implement solutions

Required Qualifications

• Bachelor’s degree in Data Analytics, Business Analytics, Data Science, Information Systems/MIS, Statistics, or another quantitative discipline
• 8+ years of related professional experience in data analytics, advanced reporting, reporting automation, and process improvement
• Advanced Microsoft Excel proficiency, including advanced formulas, pivot tables, macros, conditional formatting, data manipulation, and tools for analyzing and automating complex reporting
• Experience developing dashboards, metrics, and data visualizations using Power BI, Excel, or similar tools
• Experience using AI, automation tools, or other emerging technologies to improve data analysis, reporting, or business processes
• Demonstrated ability to simplify and automate manual reporting processes to improve efficiency, accuracy, and sustainability
• Strong analytical and problem-solving skills, with the ability to translate complex data into meaningful insights for business leaders
• Experience working with complex datasets and reporting processes
• Attention to detail and a commitment to data accuracy and integrity
• Ability to understand complex workflows and produce clear, detailed process documentation and step-by-step instructions
• Ability to work independently in a project-based environment, manage multiple priorities, and proactively implement solutions

Technology Stack

• Microsoft Excel
• Power BI
• AI
• Macros
• Pivot tables
• Conditional formatting
• Filters

Compensation and Location

• Location: Remote
• Compensation: USD 70–77 per hour
• Employment Type: Contract

Benefits

• Medical, dental, and vision insurance
• 401k retirement account access
• Paid sick leave and/or other paid time off as provided by applicable law

Physical Demands

• Ability to safely perform essential job functions consistent with the ADA and other federal, state, and local standards
• Sedentary work involving sitting or remaining stationary most of the time, with occasional need to move around to attend meetings
• Ability to conduct repetitive computer tasks using a mouse, keyboard, and monitor

Reasonable Accommodation

If you require a reasonable accommodation to complete the application, participate in interviews, complete pre-employment testing, or otherwise take part in the employment selection process, contact [e-mail] or (888) 824–8111.

EEO Statement

• Policy not to discriminate against employees or applicants because of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability, or protected veteran status
• Policy to take affirmative action to employ and advance in employment all persons regardless of the protected categories listed above
• Employment decisions are based only on valid job requirements
• Applies to all employment actions including recruitment, hiring, upgrading, promotion, transfer, demotion, layoff, recall, termination, rates of pay, and selection for training, including apprenticeship, at all levels
• CAI employees and applicants will not be subject to harassment based on protected categories
• Retaliation, including intimidation, threats, or coercion, is prohibited for objections to discrimination or participation in reviews, investigations, hearings, or efforts to obtain legal rights under applicable EEO laws