Analyst HR Reporting Delivery

Category/Area of Expertise: Data-Science & Analytics
Job Requisition: 541655
Address: USA-IL-Chicago-300 South Riverside Plaza
Store Code: HR Reporting & Analytics (5135622)
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. Our associates support the brands with a wide range of services, including Finance, Legal, Sustainability, Commercial, Digital and E-commerce, Technology and more.
The Reporting & Analytics team is responsible for delivering business intelligence solutions by summarizing and presenting HR, financial, and operational data to stakeholders and brands. Our team utilizes various reporting environments, including Azure SQL data warehouse, Success Factors, ad-hoc data sources, and third-party platforms.
As an Analyst II, you will help support the delivery of both recurring and ad-hoc reports from these sources to meet business needs. You will leverage tools such as Power BI, SQL, Excel, and others. With guidance, you will address ad-hoc tickets, recurring reports, pinpoint data quality errors, and create reports for stakeholders and brands.
Our flexible/ hybrid work schedule includes 3 in-person days at one of our core locations and 2 remote days. Our core office locations include Salisbury, NC , Chicago, IL, Quincy, MA, Carlisle, PA, Scarborough, ME, Hyattsville, MD and Mauldin, SC.
Duties and Responsibilities:

• Works with stakeholders, with guidance, to develop and/or modify reporting or processes to resolve simple business problems by leveraging data pipelines, includes but not limited to analysis of business and user needs, documenting business requirements and translating business requirements into functional solutions.
• Develops basic reports, visualizations using business intelligence tools such as Power BI following documented procedures.
• Reviews reports and queries to improve accuracy, functionality, and consistency.
• Develops a combination of simple to complex SQL queries to fulfill stakeholder's requests while following our SQL best practices documents.
• Provide daily support to functional users on HR Reporting Systems through tickets in ServiceNow.
• Demonstrate an understanding of the business processes related to all relevant data systems.
• Demonstrate an understanding of functionality, maintenance and support of the core HR data systems.
• Assist in the support of all HR reporting and data quality processes.
• Assist in the coaching and development of Power BI understanding in direct stakeholders.
• Estimate and evaluate individual effort and timelines for potential tasks
• 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 our data pipelines.
• Regularly assist with the workspace and dataset review including updating documentation and providing support for internal/external testing
• Use HR data and analytics expertise to influence business decisions, creating an HR competitive advantage for our diverse retail brands, supply chain, and shared services customers
• Partner with IT and senior analysts to continuously improve the HR User Experience for HR systems, applications and technology - evaluating the effectiveness of current HR Solutions while leveraging industry best practices
• In partnership with senior analysts 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 for our customers.
• Participate in projects, collaborating with senior analysts, business leaders, and HR to solve basic business problems and improve business effectiveness.
• Accurately document information, scripts, issues and anything else relevant within the designated system of record.
• Additional job duties may be assigned as needed to meet the needs of the business and support our Values.

Qualifiations:

• Associate's degree or equivalent combination of education and related work experience; bachelor's degree preferred. Preferred backgrounds include I/O Psychology or strong quantitative disciplines
• 1-2 years of HR data analytics experience or proven transferable BI analyst experience.
• Critical and Systematic Thinking
• Intermediate MS Office - Primarily Excel
• Simple to Intermediate MS Power BI Experience (preference towards strong Dax/ M query experience)
• Strong verbal and written communication skills to effectively present findings and recommendations to stakeholders
• Ability to follow given priorities and work independently from documentation
• Basic understanding of statistical methods
• Thoroughness in data analysis and reporting to ensure accuracy.
• Ability to work collaboratively with cross-functional teams and stakeholders.
• Aptitude for comprehending and leveraging both HR and technical concepts for continuous improvement and process re-design.
• Ability to document and triage data quality issues with guidance.
• 5-10% Travel
• Power BI (Entry Level +)
• DAX Coding and M Query (Entry Level +)
• SQL Query Creation Experience (We use SSMS | T-SQL) (Entry Level +)
• Understanding of HR Data Models
• Preferred:
  • Power BI (Entry Level +)
  • DAX Coding and M Query (Entry Level +)
  • SQL Query Creation Experience (We use SSMS | T-SQL) (Entry Level +)
  • Understanding of HR Data Models
  • Experience in any of the following SuccessFactors Modules:
  • SuccessFactors Employee Central
  • SuccessFactors Learning
  • SuccessFactors Recruiting & Onboarding
  • SuccessFactors Talent
  • SuccessFactors Employe Central Payroll (ECP)
  DAX Coding and M Query (Entry Level +)
  • Experience in any of the following programs or languages:
  • MuleSoft Integration Layer
  • Data Bricks
  • Kronos (Workforce Dimensions)
  • PeopleSoft
  • Cyborg
  • Statistical Coding Languages (R or Python)

Core/ Premium
ME/NC/PA/SC Salary Range: $63,440-$95,160
IL/MA/MD/NY Salary Range: $72,880 - $109,320
Actual compensation offered to a candidate may vary based on their unique qualifications and experience, internal equity, and market conditions. Final compensation decisions will be made in accordance with company policies and applicable laws.

• #LI-ES1

At Ahold Delhaize USA, we provide services to one of the largest portfolios of grocery companies in the nation, and we're actively seeking top talent.
Our team shares a common motivation to drive change, take ownership and enable our brands to better care for their customers. We thrive on supporting great local grocery brands and their strategies.
Our associates are the heartbeat of our organization. We are committed to offering a welcoming work environment where all associates can succeed and thrive. Guided by our values of courage, care, teamwork, integrity (and even a little humor), we are dedicated to being a great place to work.
We believe in collaboration, curiosity, and continuous learning in all that we think, create and do. While building a culture where personal and professional growth are just as important as business growth, we invest in our people, empowering them to learn, grow and deliver at all levels of the business.