Senior HR Data Analyst

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.

• 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

• 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

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

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

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

• 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

If you require a reasonable accommodation to complete the application, participate in interviews, complete pre-employment testing, or otherwise take part in…