Senior HR Data & Systems Analyst
Est. Years of Experience: 7 to 9 years in data or systems analysis, including 4+ years with HR or HRIS data
Role Summary: HR data domain expert on the team. Translates EM's HR metrics (forcecount, Management Trainee retention, PIP cadence, schedule usage) into precise, certified data definitions that engineers can build and Power BI teams can trust. Bridges HR, HRIS, and D&A stakeholders on one side and the engineering team on the other.
Responsibilities:
Interpret EM's Power BI requirements template and convert the 5 metric domains into documented metric definitions and business rules
Define calculation logic for metrics such as Forcecount (averaged over 36 points in time), All-In retention, MT 120-Day retention, Source of Hire, and Reviews Past Due
Map Workday, Dayforce, and PeopleSoft source fields to Silver dimensions and Gold assets
Facilitate source data validation with HRIS and HR stakeholders at the Bronze-to-Silver boundary
Write the data certification criteria for each of the 15 certified data assets and manage sign-off
Resolve conflicts between metric definitions across teams and record decisions
Define test cases and acceptance criteria, and lead reconciliation of results with HR owners
Support the Systems Analyst on documentation, UAT, and defect triage
Flag scope changes and open items (for example, Hiring App Flow) to the technical lead
Technical Skills:HR metrics and workforce analytics (headcount, retention, turnover, hiring, mobility, performance reviews, scheduling and hours)
Workday HCM data model and reporting, and Dayforce time and scheduling data
PeopleSoft HCM data structures
Advanced SQL for data profiling, validation, and reconciliation
Metric and data dictionary design
Dimensional modeling concepts (facts, dimensions, grain, conformed dimensions)
Business requirements and user story documentation
Power BI report and dashboard literacy, and requirements for certified datasets
Sensitive HR data handling and privacy practices
Jira or Azure DevOps Boards for backlog management
Perficient full-time employees receive complete and competitive benefits. We offer a collaborative work environment, competitive compensation, generous work/life opportunities and an outstanding benefits package that includes paid time off plus holidays. In addition, all colleagues are eligible for a number of rewards and recognition programs including billable bonus opportunities. Encouraging a healthy work/life balance and providing our colleagues great benefits are just part of what makes Perficient a great place to work.
WHO WE ARE
Perficient is a leading global digital consultancy. We imagine, create, engineer, and run digital transformation solutions that help our clients exceed customers’ expectations, outpace competition, and grow their business. With unparalleled strategy, creative, and technology capabilities, our colleagues bring big thinking and innovative ideas, along with a practical approach to help our clients – the world’s largest enterprises and biggest brands succeed.
WHAT WE BELIEVE
At Perficient, we promise to challenge, champion, and celebrate our people. You will experience a unique and collaborative culture that values every voice. Join our team, and you’ll become part of something truly special.
We believe in developing a workforce that is as diverse and inclusive as the clients we work with. We’re committed to actively listening, learning, and acting to further advance our organization, our communities, and our future leaders… and we’re not done yet.
Perficient, Inc. proudly provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a protected veteran in accordance with applicable federal, state and local laws. Perficient, Inc. complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. Perficient, Inc. expressly prohibits any form of unlawful employee harassment based on race, color, religion, gender, sexual orientation, national origin, age, genetic information, disability, or covered veterans. Improper interference with the ability of Perficient, Inc. employees to perform their expected job duties is absolutely not tolerated.
Disability Accommodations:
Perficient is committed to providing a barrier-free employment process with reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or accommodation due to a disability, please contact us.
Disclaimer: The above statements are not intended to be a complete statement of job content, rather to act as a guide to the essential functions performed by the employee assigned to this classification. Management retains the discretion to add or change the duties of the position at any time.