Senior HR Data Analyst — Remote with AI & Automation Dashboards

CAI; Augusta (ME); Remote; USD 200,579,000 - 220,636,000; Full time

Job summary

CAI is seeking a Senior HR Data Analyst for a remote, project-based contract role. You will lead complex HR reporting, data analytics, dashboards, and automation to transform manual processes into efficient, scalable solutions.

The role requires advanced Excel expertise, Power BI skills, and experience applying AI/automation tech to data analysis and reporting, delivering sustainable improvements for business leaders.

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 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.

Responsibilities

• Maintain HR reporting, analyze, manipulate, and format complex datasets using advanced Microsoft Excel functionality (formulas, pivot tables, macros, conditional formatting, filters).
• 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 and report production time.
• Develop dashboards, metrics, and data visualizations that provide leaders with visibility into trends and insights.
• Utilize Power BI, Excel, and other tools to translate data into meaningful information.
• Identify opportunities to improve efficiency and sustainability of reporting and processes.
• Create and maintain clear process documentation outlining existing workflows and procedures.
• Update documentation as processes are optimized and automated to ensure standardized workflows.
• Work independently in a project-based environment, managing priorities and implementing solutions.

Skills

Advanced Excel

Power BI

Reporting automation

Process improvement

Data analytics

AI tools

Dashboards

Education

Bachelor's degree in Data Analytics

Tools

Power BI

Excel

Automation tools

Job description

CAI is seeking a Senior HR Data Analyst for a remote, project-based contract role. You will lead complex HR reporting, data analytics, dashboards, and automation to transform manual processes into efficient, scalable solutions.

The role requires advanced Excel expertise, Power BI skills, and experience applying AI/automation tech to data analysis and reporting, delivering sustainable improvements for business leaders.