What are the responsibilities and job description for the Senior Data Engineer 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