AvePoint→
People Data Intern
InternshipOn-site
Location
Jersey City, NJ
Salary
$37k–$42k/yr
Experience
No experience required
Posted
5 days ago
Skills
sqlrelational data conceptsetl/elt pipelinesdata modelinganalytics platformsworkforcehr datamicrosoft fabricpower biazure sqlconversational analytics toolsanalytical skills
Job Description
Summary: AvePoint is 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 focuses on leveraging a mirrored Azure SQL MyHR database and Microsoft Fabric to create reliable data pipelines and curated datasets for HRBPs and leaders to access key people metrics.
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
- Implement data quality checks, refresh schedules, and validation processes to ensure reliable and consistent data outputs
- Contribute to the development of a semantic and metrics layer aligned with existing Power BI and people analytics reporting
- Support development of a conversational data agent by mapping natural language questions to governed metrics and datasets
- Test common workforce analytics queries and validate accuracy of results
- Document data models, metric definitions, agent usage, and handoff materials to support adoption and future expansion
Required Qualifications:
- Currently pursuing a degree in Computer Science, Data Analytics, Information Systems, Engineering, HR Analytics, or a related field (rising sophomore through graduate level)
- Interest in people analytics, data engineering, or AI-enabled analytics solutions
- Familiarity with SQL and relational data concepts
- Exposure to ETL/ELT pipelines, data modeling, or analytics platforms
- Understanding of workforce or HR data is a plus
- Strong analytical and problem-solving skills with attention to data accuracy and governance
- Ability to work with ambiguity and evolving requirements in a project-based environment
- Clear written and verbal communication skills and ability to collaborate cross-functionally
- Curiosity, ownership mindset, and eagerness to learn modern people data and AI-driven analytics practices
Preferred Qualifications:
- Experience or interest in Microsoft Fabric, Power BI, Azure SQL, or conversational analytics tools is preferred but not required
Required Skills: SQL, Relational data concepts, ETL/ELT pipelines, Data modeling, Analytics platforms, Workforce, HR data, Microsoft Fabric, Power BI, Azure SQL, Conversational analytics tools, Analytical skills