Data Engineer: HR Systems (Boston, Massachusetts)

Smart4 Energy; Boston (MA); Hybrid; USD 100,000 - 105,000; Full time

Job summary

A leading energy solutions provider is seeking a Data Engineer in Boston, MA to design and implement Snowflake data models, translate business needs into data strategies, and optimize data transformation processes. This contract position requires strong SQL skills and experience with data warehousing solutions, as well as a background in HR data structures. The ideal candidate should possess excellent analytical abilities, a solid understanding of data governance, and proficiency in Python.

Qualifications

• 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.
• Exposure to Data Warehousing supporting advanced reporting.

Responsibilities

• Translate business needs into data modeling strategies.
• Design, build, and maintain Snowflake objects including tables, views, and procedures.
• Develop and execute SQL or Python transformations.
• Establish data governance standards.
• Manage technical metadata for data warehousing.
• Optimize performance of data transformation pipelines.
• Design integrations between Workday and third-party applications.
• Participate in system testing.
• Support data analysis needs throughout implementation.

Skills

Snowflake

SQL

Data transformation tools

ETL processes

Data validation techniques

Python

Data warehousing

Job description

Base pay range: $100.00/yr - $105.00/yr

3-4 days onsite a week

Pay Rate: $105 / Hr

This range is provided by Smart4 Energy. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

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
• Exposure to Data Warehousing solutions leveraging data from Workday or other HRIS such as SuccessFactors, etc. to support advanced reporting and insights for an organization

Seniority level

Mid-Senior level

Employment type

Contract

Job function

Information Technology

Industries

Investment Banking, Insurance, and Accounting

Referrals increase your chances of interviewing at Smart4 Energy by 2x

Get notified about new Data Engineer jobs in Boston, MA.