Senior Data Platform Engineer - SQL, ETL & Analytics

Zohorecruit; Wilmington (DE); Hybrid; USD 110,000 - 160,000; Full time

Job summary

Zohorecruit is seeking a Sr IT Operations / Enterprise Data & Analytics Engineer for a hybrid role in Wilmington, DE. You will own the data platform, build ETL pipelines, design dimensional models, and ensure secure, scalable data flows across the organization.

Responsibilities include ingesting data from databases, APIs, and files, delivering processed data to downstream applications, and maintaining data quality. Strong SQL Server expertise and Visual Studio-based ETL are essential for success.

Qualifications

• 8–10 years of hands-on experience with SQL Server development, administration, and ETL.
• Strong T-SQL skills, Stored Procedure development, query tuning, and schema design.
• Experience with enterprise data warehouses and reporting environments.

Responsibilities

• Build and maintain SQL Server databases, schemas, indexing, and data structures.
• Develop and optimize Stored Procedures, T-SQL logic, and ETL components using Visual Studio.
• Manage data ingestion from databases, APIs, and file-based sources (CSV, Excel, JSON).
• Deliver processed data to downstream systems via direct integrations or flat files outputs.
• Monitor and troubleshoot ETL jobs, scheduled tasks, and automated workflows.
• Investigate discrepancies and integration failures to ensure data reliability.
• Support operational and financial month-end data processes.
• Maintain enterprise dataflows and data validation checks.
• Design and maintain dimensional models, including fact and dimension tables.
• Ensure modeling consistency for reporting and analytical usage.
• Maintain data models and scheduled reporting workflows.

Skills

T-SQL

ETL Development

Visual Studio

Database Design

Security

Data Ingestion

Data Delivery

Dimensional Modelling

Data Validation

Troubleshooting

Cognos

IQMS

Job description

Zohorecruit is seeking a Sr IT Operations / Enterprise Data & Analytics Engineer for a hybrid role in Wilmington, DE. You will own the data platform, build ETL pipelines, design dimensional models, and ensure secure, scalable data flows across the organization.

Responsibilities include ingesting data from databases, APIs, and files, delivering processed data to downstream applications, and maintaining data quality. Strong SQL Server expertise and Visual Studio-based ETL are essential for success.