Analyst HR Reporting Delivery

ViziRecruiter,LLC.; Carlisle (Cumberland County); On-site; USD 70,000 - 90,000; Full time

Job summary

ViziRecruiter, LLC. is seeking an Analyst III to join their Reporting & Analytics team in Carlisle, United States. The role focuses on delivering actionable insights through data analysis and reporting using tools such as Power BI and SQL.

The ideal candidate will have a Bachelor’s degree and over 4 years of relevant HR data analytics experience. A strong understanding of statistical methods and excellent communication skills are essential for success in this role.

Qualifications

• 4+ years of relevant HR data analytics or BI analyst experience.
• Intermediate knowledge of SQL query creation.
• Basic understanding of HR systems and data structures.

Responsibilities

• Transform and deliver recurring and ad-hoc reports to stakeholders.
• Develop reports and visualizations using Power BI.
• Conduct HR analysis to identify process gaps and improve data quality.

Skills

Data analysis

SQL

Power BI

Excel

HR data analytics

Education

Bachelor’s Degree in I/O Psychology or quantitative discipline

Tools

Azure SQL

ServiceNow

Job description

Introduction

Ahold Delhaize USA, a division of global food retailer Ahold Delhaize, is part of the U.S. family of brands, which includes five leading omnichannel grocery brands—Food Lion, Giant Food, The GIANT Company, Hannaford and Stop & Shop. Ahold Delhaize USA associates support the brands with a wide range of services, including Finance, Legal, Sustainability, Commercial, Digital and E‑commerce, Technology and more.

Overview

The Reporting & Analytics team delivers business intelligence solutions by summarizing and presenting HR, financial, and operational data to stakeholders and brands. We use environments such as Azure SQL data warehouse, SuccessFactors, ad‑hoc data sources, and third‑party platforms. As an Analyst†III, you will transform and deliver recurring and ad‑hoc reports from these sources to meet business needs. You will leverage tools such as Power†BI, SQL, Excel, and others, conduct HR analysis, identify process gaps, address tickets, pinpoint data quality errors, and create reports for stakeholders and brands.

Responsibilities

• Work with stakeholders to develop and/or modify reporting or processes to resolve simple business problems by leveraging data pipelines, including analysis of business and user needs, documenting business requirements and translating them into functional solutions.
• Develop reports and visualizations using Power BI.
• Evaluate and improve the capabilities of Business Intelligence tools through new methodologies, technology, and data management. Review reports to improve accuracy, functionality, and consistency.
• Write simple to complex SQL queries to fulfill stakeholders’ requests while following SQL best practices.
• Provide daily support to functional users on HR Reporting Systems through ServiceNow tickets.
• Demonstrate deep understanding of business processes related to all relevant data systems.
• Understand the functionality, maintenance, and support of core HR data systems.
• Serve as subject‑matter expert for HR reporting within relevant HR systems.
• Serve as subject‑matter expert for HR Power BI reporting and data quality within that system.
• Coach and develop stakeholders’ Power BI understanding.
• Develop, test, and implement new solutions to data queries or data quality issues.
• Estimate and evaluate effort for potential projects.
• Support ad‑hoc reporting and HR data requests for all brands.
• Support UAT and other application testing during routine and unscheduled maintenance cycles, system implementations, or other integration projects. Assist with developing appropriate documentation such as business requirements and test scripts.
• Perform regression testing on the SQL data lake and Power BI infrastructure whenever large changes occur in data pipelines.
• Analyze and document current business functions to identify areas for opportunity.
• Assist with workspace and dataset review, including updating documentation and supporting internal/external testing.
• Use HR data and analytics expertise to influence business decisions, creating an HR competitive advantage for our retail brands, supply chain, and shared services customers.
• Partner with IT to continuously improve the HR User Experience for HR systems and applications by evaluating effectiveness of current HR solutions while leveraging industry best practices.
• Develop innovative solutions and analytics frameworks to help the business understand HR patterns and connections across the “Hire to Retire” lifecycle, creating actionable decision‑making frameworks.
• Participate in projects, collaborating with Senior Analysts, business leaders, and HR to solve moderately complex business problems and improve business effectiveness.
• Accurately document information, scripts, issues, and anything else relevant within the designated system of record.

Requirements

• Respond to inquiries and interpret gray areas; suggest process improvements.
• Perform moderately complex analytical tasks related to creating and comparing data files, determining potential errors or omissions, and root‑cause analysis.
• Interpret customer requests and provide appropriate data and support.
• Recommend practical corrective actions based on analysis.
• Partner with Senior Analysts, business and HR leaders to solve moderately complex business problems and improve effectiveness.
• Follow project plans and identify possible conflicts.
• Perform moderately complex configuration testing and tasks for maintaining HR systems and applications.
• Partner with senior counterparts to support creation of reports and pipelines supporting the organization.
• Design, develop, code, test, and debug SQL queries and Power BI dashboards; translate business requests into data pipelines or reports with some guidance.
• Locate and document data quality issues and ensure they are remedied.
• Bachelor’s Degree or equivalent combination of education and relevant work experience; preferred backgrounds include I/O Psychology or strong quantitative disciplines.
• 4+ years of HR data analytics experience or significant transferable BI analyst experience.
• Critical and systematic thinking.
• Advanced MS Office – primarily Excel.
• Intermediate MS Power BI experience (strong DAX/M query experience preferred).
• Basic HR system knowledge (data structures/function).
• Intermediate SQL query creation knowledge.
• Strong verbal and written communication skills to present findings and recommendations to stakeholders.
• Ability to prioritize and work independently with guidance.
• Basic understanding of statistical methods.
• Thoroughness in data analysis and reporting to ensure accuracy.
• Collaboration with cross‑functional teams and stakeholders.
• Aptitude for comprehending and leveraging HR and technical concepts for continuous improvement and process redesign.
• Document and triage data quality issues.
• Maintain high confidentiality.
• Handle competing priorities.
• Power BI (intermediate+), DAX and M query experience; SQL query creation experience (SSMS/T‑SQL); understanding of HR data models.