Senior HR Data Analyst

CAI; City of Albany (NY); Remote; USD 96,000 - 106,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401k retirement plan

Paid time off

Job summary

CAI is seeking a Senior HR Data Analyst to drive complex HR reporting, analytics, dashboard development, and automation. The role focuses on transforming manual reporting into efficient, scalable processes using Excel, Power BI, and AI-enabled tools.

The position is contract-based and remote, ideal for a data-driven professional with 8+ years of experience and a proven ability to automate workflows and deliver actionable insights to business leaders.

Qualifications

• Bachelor’s degree in Data Analytics, Business Analytics, Data Science, Information Systems/MIS, Statistics, or similar quantitative field.
• 8+ years of related professional experience in data analytics, advanced reporting, reporting automation and process improvement.
• Advanced proficiency in Microsoft Excel, including formulas, pivot tables, macros, conditional formatting, data manipulation, and automation tools.
• Experience developing dashboards and visualizations using Power BI, Excel, or similar tools.
• Experience using AI or automation technologies to improve data analysis or business processes.
• Ability to identify opportunities to simplify and automate reporting processes for efficiency and accuracy.
• Strong analytical and problem-solving skills with the ability to translate data into actionable insights.
• Experience handling complex datasets and reporting processes.

Responsibilities

• Maintain and improve HR reporting using advanced Excel features (formulas, pivot tables, macros, conditional formatting).
• Transform and automate complex Excel-based reporting processes to reduce manual effort.
• Develop dashboards and visualizations to provide leaders with clear insights into trends.
• Translate data into meaningful information using Power BI and Excel.
• Document reporting workflows with step-by-step procedures and update as processes evolve.
• Work independently in a project-based setting while managing priorities and delivering solutions.

Skills

Advanced Excel

Power BI

Data visualization

Reporting automation

AI tooling

Problem solving

Education

Bachelor’s degree in Data Analytics or related field

Tools

Power BI

Excel

Job description

Senior HR Data Analyst

Req number:

R8711

Employment type:

Full time

Worksite flexibility:

Remote

Who we are

CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right - whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.

Job Summary

We are looking for a motivated Senior HR Data Analyst ready to take us to the next level! If you have advanced Excel, Power BI/data visualization, and reporting automation skills, and are looking for your next career move,

Job Description

We are looking for a Senior HR Data Analyst to support complex HR reporting, data analytics, dashboard development, reporting automation, and process optimization initiatives. This project-based role will focus on transforming manual and complex reporting processes, leveraging advanced Excel capabilities, Power BI, AI, automation tools, and other emerging technologies to improve reporting efficiency, accuracy, and sustainability. This position will be a contract and remote.

What You'll Do

• 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

What You'll Need

Required:

• 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

Physical Demands

• Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state, and local standards

• Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.

• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor

Reasonable accommodation statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to [e-mail] or (888) 824 - 8111.

EEO Statement

It is the policy of Computer Aid, Inc.(CAI) not to discriminate against any employee or applicant for employment because of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or because he or she is a protected veteran. It is also the policy of CAI to take affirmative action to employ and to advance in employment, all persons regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or protected veteran status, and to base all employment decisions only on valid job requirements. This policy shall apply to all employment actions, including but not limited to recruitment, hiring, upgrading, promotion, transfer, demotion, layoff, recall, termination, rates of pay or other forms of compensation and selection for training, including apprenticeship, at all levels of employment.

Employees and applicants of CAI will not be subject to harassment on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or because he or she is a protected veteran. Additionally, retaliation, including intimidation, threats, or coercion, because an employee or applicant has objected to discrimination, engaged or may engage in filing a complaint, assisted in a review, investigation, or hearing or have otherwise sought to obtain their legal rights under any Federal, State, or local EEO law is prohibited.

$70-$77 per hour

The pay range for this position is listed above. Exact compensation may vary based on several factors, including location, experience, and education. Benefit packages include medical, dental, and vision insurance, as well as 401k retirement account access. Employees in this role may also be entitled to paid sick leave and/or other paid time off as provided by applicable law.