Job Title : Sr. Data Engineer - HR Data & Analytics
Location : Boston Hybrid (4 days from office)
Duration : 12 Months
RM notes : Snowflake HRIS SQL Python.
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 platformsStrong SQL skills and experience with data transformation toolsExperience with ETL processes and data validation techniquesUnderstanding of HR data structures and relationshipsExcellent analytical and problem-solving abilitiesExperience with developing with PythonArchitecting a data warehousing solution leveraging data from Workday or other HRIS such as Workday to support advanced reporting and insights for an organizationPreferred Experience & Skills
Experience in developing and supporting a data warehouse serving the HR domainExperience with data platforms where SCD Type 2 was requiredExperience with data visualization tools such as TableauExperience with architecting or working with ELT technologies (such as DBT) and data architecturesUnderstanding of HR processes compliance requirements and industry best practicesKey Skills
Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala
Employment Type : Full Time
Experience : years
Vacancy : 1