Senior Data Engineer

Ness Digital Engineering is seeking a Senior Data Engineer for HR Data & Analytics in Boston. This hybrid role involves translating business needs into data modeling strategies, implementing Snowflake data models for HR analytics, and designing, building, and maintaining Snowflake objects. Key responsibilities include developing SQL or Python transformations, enforcing data governance, managing metadata, optimizing data pipelines, and configuring Workday integrations. The role requires strong Snowflake, SQL, Python, and ETL experience, with a focus on HR data structures.

Must Have

• Translate business needs into data modeling strategies
• 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
• 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

Good to Have

• 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

Description

Position at Ness Digital Engineering

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