People Business Intelligence Analyst
Core
Own data mapping across HR systems and a cloud data warehouse to ensure accurate, consistent, and governed workforce data for leadership decisions.
Role type
Senior People Business Intelligence Analyst
Builds
Dashboards and reporting solutions for workforce trends and key people metrics
Domain
People Analytics / Business Intelligence / Cloud Data Engineering
Deliverable
dashboards & analysis
Required skills
SQL, data mapping, ETL concepts, data governance, data quality management, cloud data warehouse management
Preferred skills
People analytics frameworks, HRIS platforms, ATS platforms, AWS data technologies, Python or R, generative AI
Technologies
Amazon Redshift, QuickSight, Power BI, Tableau, Workday, SAP SuccessFactors, ADP, BambooHR, Greenhouse, Lever, AWS (S3, Glue, Athena)
Responsibilities
Map and document data flows from HR source systems into a Redshift data warehouse; Define and maintain field definitions, data lineage, business logic, data dictionaries, and metric glossaries; Build and maintain dashboards covering metrics such as headcount, turnover, hiring funnel performance, DEI representation, engagement, compensation equity, and span of control; Write, troubleshoot, and optimize SQL queries in Redshift; Partner with HR Business Partners, Talent Acquisition, Compensation & Benefits, and People leadership to translate business questions into data models and visualizations; Ensure sensitive HR information is handled according to privacy and access-control requirements; Identify and resolve data quality issues at the source or within the data mapping layer; Support recurring reporting cycles including monthly headcount reviews, quarterly board reporting, and annual compensation reviews
Seniority
Senior, hands-on IC
