Role: Sr. Data Engineer - HR Data & Analytics
Location: Boston – Hybrid (4 days from office)
Key Responsibilities
-
Translate business needs into data modeling strategies and implement Snowflake data models to support HR analytics, KPIs, and reporting.
-
Design, build, and maintain Snowflake objects including tables, views, and stored procedures.
-
Develop and execute SQL or Python transformations, data mappings, cleansing, validation, and conversion processes.
-
Establish and enforce data governance standards to ensure consistency, quality, and completeness of data assets.
-
Manage technical metadata and documentation for data warehousing and migration efforts.
-
Optimize performance of data transformation pipelines and monitor integration performance.
-
Design, configure, and optimize integrations between Workday and third-party applications.
-
Participate in system testing including unit, integration, and regression phases.
-
Support data analysis needs throughout the implementation lifecycle.
Required Experience & Skills
-
Experience with Snowflake or similar data warehouse platforms
-
Strong SQL skills and experience with data transformation tools
-
Experience with ETL processes and data validation techniques
-
Understanding of HR data structures and relationships
-
Excellent analytical and problem-solving abilities
-
Experience with developing with Python
-
Architecting a data warehousing solution leveraging data from Workday or other HRIS such as Workday to support advanced reporting and insights for an organization
Preferred Experience & Skills
-
Experience in developing and supporting a data warehouse serving the HR domain
-
Experience with data platforms where SCD Type 2 was required
-
Experience with data visualization tools such as Tableau
-
Experience with architecting or working with ELT technologies (such as DBT) and data architectures
-
Understanding of HR processes, compliance requirements, and industry best practices