Data Engineer – SQL Server ETL & Cloud Migration

United Way of Greenville County; Westerville (OH); On-site; USD 90,000 - 130,000; Full time

Job summary

VPL is seeking a hands-on Data Engineer to own and optimize SQL Server-based data pipelines, moving toward PostgreSQL and Snowflake. You’ll troubleshoot ETL, tune T-SQL, and collaborate with analytics, product, and finance teams to deliver reliable, scalable data solutions.

Bring 3–5 years of data engineering, strong SQL and SSIS skills, and a comfort with ELT concepts. Knowledge of Git/Jira and cloud DevOps is a plus as you help modernize our data platform.

Qualifications

• 3–5 years of experience in data engineering or related roles.
• Strong MS SQL Server and T-SQL skills with complex queries and data transformations.
• Hands-on experience developing, maintaining, or troubleshooting SSIS packages and ETL workflows.
• Experience with relational databases, data warehouses, and dimensional modeling.
• Ability to translate business questions into data requirements and technical solutions.
• Understanding of ETL and ELT concepts and production support practices.
• Experience with Git or another source-control platform and familiarity with code review and controlled deployment practices.
• Bachelor’s degree in CS/IS/Math/Finance or related field, or equivalent practical experience.

Responsibilities

• Operate, monitor, troubleshoot, and improve SSIS packages and scheduled ETL jobs that support the enterprise data warehouse and production systems.
• Diagnose pipeline failures, performance bottlenecks, data discrepancies, dependency issues, and incomplete loads; restore processing safely and document recurring solutions.
• Develop and optimize complex T-SQL queries, stored procedures, views, functions, database jobs, and data transformations in SQL Server.
• Design, build, test, and maintain data pipelines that integrate operational, logistics, customer, carrier, supplier, billing, and financial data.
• Develop and maintain dimensional models, relational models, reporting datasets, and other analytical data structures.
• Work with analysts, product managers, engineers, finance, operations, and other business partners to define metrics, business rules, source-to-target mappings, and data-quality expectations.
• Reconcile data across source systems, production applications, financial processes, and analytical platforms; investigate anomalies and explain findings clearly.
• Implement controls and alerts to identify missing, duplicate, late, incomplete, or inconsistent data before it affects customers, reporting, or billing.
• Improve pipeline reliability through logging, monitoring, restartability, error handling, testing, source control, documentation, and deployment practices.
• Help evaluate which existing SSIS workloads should be migrated toward PostgreSQL and Snowflake.

Skills

SQL Server

T-SQL

SSIS

Data pipelines

Python

ETL/ELT

Data reconciliation

Education

Bachelor's degree in CS/IS/Math/Finance or equivalent

Tools

Git

Jira

Azure DevOps

SQL Server Agent

Snowflake

PostgreSQL

Job description

VPL is seeking a hands-on Data Engineer to own and optimize SQL Server-based data pipelines, moving toward PostgreSQL and Snowflake. You’ll troubleshoot ETL, tune T-SQL, and collaborate with analytics, product, and finance teams to deliver reliable, scalable data solutions.

Bring 3–5 years of data engineering, strong SQL and SSIS skills, and a comfort with ELT concepts. Knowledge of Git/Jira and cloud DevOps is a plus as you help modernize our data platform.