Senior HR Data Analyst

CAI is hiring a Senior HR Data Analyst to support complex HR reporting, data analytics, dashboard development, and process optimization. The role focuses on automating and improving reporting processes using Excel, Power BI, AI, and other emerging technologies.

Responsibilities:

• Maintain existing HR reporting and analyze, manipulate, and format complex datasets using advanced Microsoft Excel functionality, including formulas, pivot tables, macros, conditional formatting, filters, and related tools
• Transform and optimize complex Excel-based reporting processes by identifying opportunities to simplify and automate workflows
• Leverage advanced Excel capabilities, AI, automation tools, and other emerging technologies to reduce manual effort, reporting complexity, and report production time
• Develop dashboards, metrics, and data visualizations that provide business leaders with clear visibility into trends and key insights
• Utilize Power BI, Excel, and other reporting and visualization tools to translate complex data into meaningful and easily understood information
• Identify opportunities to improve the efficiency, accuracy, and sustainability of existing reporting and business processes
• Create and maintain clear process documentation outlining existing reporting workflows and step-by-step procedures
• Update documentation as processes are optimized and automated to ensure workflows remain accurate, standardized, and sustainable
• Work independently within a project-based environment while managing multiple priorities and proactively identifying and implementing solutions

Requirements:

• 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 proficiency in Microsoft Excel, including advanced formulas, pivot tables, macros, conditional formatting, data manipulation, and tools used to analyze and automate complex reporting
• Experience developing dashboards, metrics, and data visualizations using Power BI, Excel, or similar reporting and visualization tools
• Experience utilizing AI, automation tools, or other emerging technologies to improve data analysis, reporting, or business processes
• Demonstrated ability to identify opportunities to simplify and automate manual reporting processes, improving efficiency, accuracy, and sustainability
• Strong analytical and problem-solving skills with the ability to translate complex data into clear, meaningful insights for business leaders
• Demonstrated experience working with complex datasets and reporting processes
• Strong attention to detail with a commitment to data accuracy and integrity
• Ability to understand complex workflows and develop clear, detailed process documentation and step-by-step instructions
• Ability to work independently in a project-based environment, manage multiple priorities, and proactively identify and implement solutions