People Data Intern

Job description

Role Description We are seeking a People Data Intern to design and build a scalable MyHR Data Agent that enables natural language access to governed workforce analytics. This role will focus on leveraging a mirrored Azure SQL MyHR database and Microsoft Fabric to create reliable data pipelines, curated datasets, and a conversational interface that allows HRBPs and leaders to easily access key people metrics such as headcount, attrition, and hiring trends. The intern will work at the intersection of data engineering, people analytics, and AI-driven reporting, partnering closely with the People Analytics and Data Engineering teams. Key Responsibilities: - Review and understand HRIS data structures in a mirrored Azure SQL database, including employee, job, compensation, and organizational hierarchy tables. - Assist in defining and documenting governed workforce metrics such as headcount, attrition, hiring, and tenure. - Build and maintain ETL pipelines in Microsoft Fabric to ingest, transform, and curate H data into Lakehouse or Warehouse environments. - Develop curated, query-ready datasets (e.g., employee snapshots, attrition events) optimized for analytics and performance. - Implem...