HR Technology and analytics contractor

Role Overview

HR Technology & Analytics Contractor

Position Summary

We are seeking a technically-minded contractor to support our Total Rewards & Analytics team through a combination of HR reporting, data management, process automation, and analytics projects. This role is primarily project-based and will focus on improving how HR manages, analyzes, and utilizes data while also supporting recurring reporting and audit activities that keep our HR operations running efficiently.

The ideal candidate enjoys solving problems, building more efficient processes, and finding opportunities to automate manual work. While there will be recurring operational responsibilities, this role is best suited for someone who enjoys technical projects and continuously improving existing tools and processes.

Primary Responsibilities

Reporting & Data Management

• Create, maintain, and enhance recurring HR reports using ADP and other data sources.
• Produce reports related to headcount, turnover, absenteeism, compensation, organizational structure, and other workforce metrics.
• Validate report accuracy and troubleshoot data discrepancies.
• Perform recurring audits to ensure data integrity and consistency across HR systems.

Excel Reporting & Automation

• Analyze existing Excel-based reports and identify opportunities to simplify, automate, and improve them.
• Convert manual reporting processes into automated or semi-automated solutions using advanced Excel functionality, Power Query, Power Pivot, VBA, or other appropriate tools.
• Reduce manual effort by improving report efficiency, accuracy, and maintainability.
• Document reporting processes and automation solutions for future support.

Dashboard Development & Analytics

• Design and develop Power BI dashboards using multiple HR and business data sources.
• Connect, transform, and model data from HR systems, Excel files, and other business systems.
• Create dashboards and visualizations that provide meaningful workforce insights.
• Maintain and enhance existing dashboards as business needs evolve.

Process Automation & AI

• Identify opportunities to automate repetitive HR processes and administrative tasks.
• Utilize Microsoft Power Platform tools and AI technologies to improve reporting, streamline workflows, summarize information, and increase team efficiency.
• Explore emerging AI capabilities and recommend practical solutions that can improve HR operations while maintaining appropriate data security and confidentiality.
• Support implementation of new automation initiatives across the HR function.

Systems Administration

• Partner with IT to create, maintain, and audit email distribution lists.
• Perform Active Directory account audits and assist with user access reviews.
• Support HR data governance and periodic system audits.
• Assist with technical HR projects as assigned.

Preferred Qualifications

• Advanced Microsoft Excel skills, including formulas, PivotTables, Power Query, Power Pivot, and data analysis.
• Demonstrated experience improving and automating existing Excel reports.
• Experience creating reports from HRIS platforms (ADP experience preferred).
• Experience developing Power BI dashboards and working with multiple data sources.
• Experience with Microsoft Power Platform (Power BI, Power Automate, Power Apps).
• Experience using AI tools (such as Microsoft Copilot, ChatGPT, or similar technologies) to improve productivity, reporting, documentation, or process automation.
• Familiarity with Active Directory or user account administration.
• Strong analytical and problem-solving skills with excellent attention to detail.
• Ability to manage multiple technical projects independently in a remote work environment.
• Self-starter with a continuous improvement mindset and a passion for finding more efficient ways to work.

Ideal Candidate

We're looking for someone who enjoys taking existing processes and making them better. Whether it's improving an Excel report that takes hours to maintain, building a Power BI dashboard, automating a manual HR process, or using AI to increase productivity, this individual should be energized by solving problems and creating more efficient ways of working.

This role is less focused on customer-facing HR support and more focused on delivering technical solutions that improve the effectiveness of the HR team. Success in this position requires curiosity, initiative, strong technical skills, and the ability to independently manage projects while balancing recurring reporting and audit responsibilities.

Workload & Priorities

The responsibilities below represent the anticipated long-term allocation of work once initial projects have been completed.

During the first few weeks of the assignment, a larger portion of the contractor's time will be dedicated to creating and auditing email distribution lists, performing Active Directory account audits, and establishing related reporting processes. Once these foundational activities are complete, the role will transition to the ongoing balance of responsibilities outlined below.

• Excel Report Improvement & Automation - 35%
• Power BI Dashboard Development & Analytics Projects - 25%
• Process Automation & AI Initiatives - 15%
• Recurring HR Reporting & Data Audits - 15%
• Systems Administration (Active Directory Audits, Email Distribution Lists, Data Governance) - 10%

This role is expected to evolve over time as projects are completed and new opportunities for automation are identified. We are looking for someone who is comfortable balancing recurring operational work with technical improvement projects.