Role Summary
The Data Engineer I develops, via using AI and SQL, and maintains robust data pipelines, manages data migrations and ETL processes, and delivers custom reporting solutions for Greenshades clients. This role combines deep technical expertise in data integration and file construction with hands-on compliance support for custom report deliverables. The Data Engineer I collaborates cross-functionally, manages work through an Azure DevOps Kanban board, and ensures data flows reliably across systems to meet both client and regulatory requirements.
Responsibilities
- EDI 834 & Ancillary File Development: Build, test, and maintain EDI 834 benefit enrollment files and associated ancillary file formats, ensuring accuracy and compliance with carrier and trading partner specifications.
- Custom Reporting: Create custom reports and dashboards to provide actionable insights to internal and client stakeholders. Includes but not limited to retirement reports, HSA and Benefit file feed creation, as well as WOTC, and related reports.
- Azure DevOps Kanban Management: Manage and track project work items using an Azure DevOps Kanban board, maintaining accurate status updates and prioritization throughout the project lifecycle.
- Collaboration: Work closely with clients and internal teams to understand data requirements and deliver solutions that meet their needs.
- Security and Compliance: Ensure data security and adherence to relevant regulations and industry best practices.
- Other duties as assigned.
Requirements
- 1 – 2 years experience with ETL and data migration processes in a SQL-focused role
- Proficiency in T-SQL and SQL Server Management Studio (SQL Server 2012+, SSRS, SSIS)
- Hands-on experience building or working with EDI 834 files and ancillary benefit enrollment formats
- Experience managing work items and project tasks using Azure DevOps Kanban boards
- Strong proficiency in Excel and experience with object-oriented programming
- Experience with common scripting languages
- Familiarity with Oracle SQL*Plus is a plus
- Ability to communicate effectively between technical and non-technical stakeholders
- Experience with Jira, GitHub, and Confluence
- BS/BA in Computer Science or related field preferred
- Excellent problem-solving skills, attention to detail, and ability to work independently and as part of a team
This is a remote position.
Skills Required
- 1–2 years of experience with ETL and data migration processes in a SQL-focused role
- Proficiency in T-SQL and SQL Server Management Studio
- Experience with SQL Server 2012 or later, SSRS, and SSIS
- Hands-on experience building or working with EDI 834 files and ancillary benefit enrollment formats
- Experience managing work items and project tasks using Azure DevOps Kanban boards
- Strong proficiency in Microsoft Excel
- Experience with object-oriented programming
- Experience with common scripting languages
- Familiarity with Oracle SQL*Plus
- Ability to communicate effectively with technical and non-technical stakeholders
- Experience with Jira, GitHub, and Confluence
- Bachelor’s degree in Computer Science or a related field
- Excellent problem-solving skills and attention to detail
- Ability to work independently and as part of a team
What We Do
Greenshades delivers in-house payroll, HR, and tax solutions that integrate directly with your ERP—no outsourcing required. Our platform supports complex payroll and compliance scenarios, including shift differentials, multi-jurisdictional taxes, and garnishments, with automated checks and expert-backed accuracy. By blending in-house control with cloud-based flexibility, Greenshades tailors the payroll experience to your business processes—adapting effortlessly to your unique needs and existing technology infrastructure. Explore how Greenshades can streamline your payroll journey.
