People Data Engineering Analyst

Job Description

Join Squarespace’s People Analytics team and help power data-driven insights that shape our workforce strategies. As a Data Engineering Analyst, you’ll play a key role in keeping our HR data ecosystem running efficiently — building, maintaining, and optimizing data pipelines between systems like Workday, Greenhouse, and Looker via Fivetran, dbt, and BigQuery. This role is ideal for someone who enjoys hands-on data work, solving integration challenges, and ensuring data accuracy and reliability for downstream analytics.

You’ll Get To…Build and maintain automated data pipelines across HR systems using Fivetran, dbt, and BigQuery, ensuring data accuracy, scalability, and performance. Support the design, development, and maintenance of the HR data warehouse on GCP, following data modeling best practices and maintaining clear documentation. Collaborate with People Analytics teammates to deliver high-quality, accurate datasets that support Looker dashboards and analytical reporting. Monitor pipeline health, troubleshoot issues, and proactively identify areas for optimization or automation.

Translate business requirements into technical solutions by working closely with People Tech, IT, and HR partners. Maintain and enforce best practices for data governance, security, and confidentiality, ensuring sensitive employee data is handled responsibly and in compliance with internal policies.

Perform quality control checks, validation, and testing of key HR datasets and metrics to ensure reliability and consistency. Share technical knowledge and best practices with team members, helping improve overall team productivity. Who We’re Looking For4-6+ years of experience in data engineering, analytics engineering, or similar roles, ideally within a modern data stack (e.

g. , Fivetran, dbt, BigQuery, Looker). Strong SQL skills and experience developing data models within cloud data warehouses (GCP / BigQuery preferred).

Experience building and maintaining ETL/ELT processes and automation workflows. Familiarity with Looker LookML development and dashboard optimization.

Working knowledge of Python or R for data transformations and automation is a plus. Understanding of data warehousing principles, schema design, and performance tuning. Strong problem-solving and analytical skills, with an ability to balance detail orientation and efficiency.

Excellent communication skills, with the ability to translate technical issues into clear, actionable updates for non-technical partners. Experience with HR data or systems (e. g.

, Workday, Greenhouse) preferred but not required. Benefits & PerksA choice between medical plans with an option for 100% covered premiums Fertility and adoption benefitsAccess to supplemental insurance plans for additional coverageHeadspace mindfulness app subscriptionGlobal Employee Assistance ProgramRetirement benefits with employer matchFlexible paid time off12 weeks paid parental leave and family care leavePretax commuter benefitEducation reimbursementEmployee donation match to community organizations8 Global Employee Resource Groups (ERGs)Dog-friendly workplaceFree lunch and snacksPrivate rooftopHack week twice per yearCash Compensation Range: $97,000 – $135,500 USD

EWJD3