Senior Data Engineer

Ness • Boston, MA

41d • Hybrid

About The Position

Role: Sr. Data Engineer - HR Data & Analytics Location: Boston - Hybrid (4 days from office)

Requirements

• 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

Nice To Haves

• 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

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Professional, Scientific, and Technical Services
• Education Level: No Education Listed
• Number of Employees: 1,001-5,000 employees