Senior SQL Server Data Architect & Engineer — Hybrid NY

Seneca Resources, LLC; New York (NY); Hybrid; USD 96,000 - 103,000; Full time

Job summary

Seneca Resources, LLC is seeking a Senior SQL Server Database Architect & Data Engineer in New York, NY. This hybrid role combines database architecture, SQL Server administration, and data engineering to design scalable, secure data platforms supporting analytics and reporting.

The ideal candidate has deep SQL Server and T‑SQL expertise, plus experience with SSIS, data warehouses/lakes, Power BI, Python, and PowerShell, ensuring reliable data movement and governance.

Qualifications

• 10 years of experience in database administration/architecture.
• 5+ years in enterprise or large-scale environments.
• Deep hands-on expertise with Microsoft SQL Server and T‑SQL.
• Strong experience with SSIS and ETL development.
• Experience with data warehouses and data lakes.
• Experience with Power BI analytics.
• Scripting with Python and PowerShell for automation.
• Database backup/recovery, DR, security, and governance.

Responsibilities

• Design and maintain enterprise database architectures for transactional, analytical, and operational apps.
• Administer and support Microsoft SQL Server environments.
• Develop and optimize ETL processes, data pipelines, and data warehouse/lake solutions.
• Support Power BI reporting and analytics initiatives.
• Ensure data governance, security, and disaster recovery policies are followed.

Skills

SQL Server

SSIS

Python

PowerShell

Power BI

T-SQL

Data governance

Performance tuning

Backup/DR

Security

Education

Bachelor’s degree or equivalent

Tools

SSIS

Power BI

Python

PowerShell

Job description

Seneca Resources, LLC is seeking a Senior SQL Server Database Architect & Data Engineer in New York, NY. This hybrid role combines database architecture, SQL Server administration, and data engineering to design scalable, secure data platforms supporting analytics and reporting.

The ideal candidate has deep SQL Server and T‑SQL expertise, plus experience with SSIS, data warehouses/lakes, Power BI, Python, and PowerShell, ensuring reliable data movement and governance.