Senior SQL Data Architect & Engineer

Seneca Resources; New York (NY); Hybrid; USD 200,579,000 - 229,233,000; Full time

Job summary

Seneca Resources in New York, NY, is seeking a Senior SQL Server Database Architect & Data Engineer to design, administer, optimize, and govern enterprise data platforms supporting applications, analytics, reporting, and digital transformation.

This hands-on role combines database architecture, SQL Server administration, data engineering, ETL, data integration, data warehousing, and business intelligence to deliver scalable, secure, highly available data solutions.

Qualifications

• 10+ years in database administration, architecture, or data engineering.
• 5+ years in enterprise or large-scale environments.
• Deep hands-on SQL Server and advanced SQL/T-SQL expertise.
• Strong data modeling and relational design experience.
• SSIS and enterprise ETL development experience.
• Experience with data warehouses, data lakes, and data integration.
• Scripting in Python and PowerShell for automation.
• Power BI and enterprise analytics/reporting experience.
• Performance tuning, indexing, and query optimization.
• Backup/recovery, DR, security, monitoring, and automation.

Responsibilities

• Design enterprise database architectures and data models.
• Establish governance, data-management standards.
• Plan for scalability, security, high availability, DR.
• Lead architecture reviews and design sessions.
• Administer and support MS SQL Server environments.
• Monitor health, performance, capacity, availability.
• Tune performance, indexing, and SQL/T-SQL development.
• Develop ETL pipelines with SSIS, Python, and PowerShell.
• Support data warehouse, data lake, and lakehouse architectures.
• Ensure data cleansing, transformation, and quality.

Skills

Microsoft SQL Server

Advanced SQL/T-SQL

Data modeling

ETL development

Data warehousing

Python scripting

PowerShell scripting

Power BI

Data governance

Security & compliance

Troubleshooting

Performance tuning

Education

High school diploma

Associate degree

Bachelor's degree

Tools

SQL Server

SSIS

Power BI

Python

PowerShell

Job description

Seneca Resources in New York, NY, is seeking a Senior SQL Server Database Architect & Data Engineer to design, administer, optimize, and govern enterprise data platforms supporting applications, analytics, reporting, and digital transformation.

This hands-on role combines database architecture, SQL Server administration, data engineering, ETL, data integration, data warehousing, and business intelligence to deliver scalable, secure, highly available data solutions.