Remote HR Data & Analytics Lead (Power BI)

CAI; Annapolis (MD); Remote; USD 96,000 - 106,000; Full time

Job summary

CAI is seeking a Senior HR Data Analyst to support complex HR reporting, data analytics, and dashboard development. This contract, remote role focuses on transforming manual reporting processes using advanced Excel, Power BI, and automation technologies to deliver accurate, scalable insights.

The position requires 8+ years of data analytics experience, strong Excel skills, and the ability to translate complex data into actionable business insights.

Qualifications

• Bachelor’s degree in Data Analytics, Business Analytics, Statistics, or a quantitative field.
• “8+ years of professional experience in data analytics, advanced reporting, automation, and process improvement.”
• “Advanced proficiency in Microsoft Excel with formulas, pivot tables, macros, and data manipulation.”
• “Experience developing dashboards and data visualizations using Power BI or similar tools.”
• “Experience using AI or automation tools to improve data analysis or reporting.”
• “Ability to identify opportunities to automate manual reporting processes.”
• “Strong analytical and problem-solving skills with the ability to translate data into insights.”

Responsibilities

• Maintain HR reporting and analyze, manipulate, and format complex datasets in Excel.
• Transform and optimize reporting processes by automating workflows.
• Develop dashboards and metrics to provide leaders with insights.
• Create visuals using Power BI and Excel to translate data into meaningful information.
• Document workflows and update procedures as processes are improved.

Skills

Advanced Excel

Power BI

Data visualization

Reporting automation

AI tools

Process optimization

Education

Bachelor’s degree in Data Analytics or related field

Tools

Power BI

Excel

Job description

CAI is seeking a Senior HR Data Analyst to support complex HR reporting, data analytics, and dashboard development. This contract, remote role focuses on transforming manual reporting processes using advanced Excel, Power BI, and automation technologies to deliver accurate, scalable insights.

The position requires 8+ years of data analytics experience, strong Excel skills, and the ability to translate complex data into actionable business insights.