SQL Server Database Architect & Data Engineer

Seneca Resources; New York (NY); Hybrid; USD 145,000 - 156,000; Full time

Benefits offered by this job

Hybrid work schedule

Job summary

Seneca Resources is seeking a Senior SQL Server Database Architect & Data Engineer in New York, NY. The role blends database design, SQL Server administration, and data engineering to build scalable data platforms, ETL pipelines, and analytics capabilities.

The candidate will drive enterprise data solutions, governance, security, and performance tuning while collaborating with business and technical teams in a hybrid work setting.

Qualifications

• 10+ years of experience in database administration, architecture and related disciplines.
• 5+ years supporting enterprise or large-scale environments.
• Deep hands-on experience with Microsoft SQL Server administration and development.
• Advanced SQL/T-SQL knowledge with complex queries, scripting, and procedures.
• Experience with data warehouses and data lakes; ETL development using SSIS.
• Experience with Python and PowerShell for data processing and automation.

Responsibilities

• Design and maintain enterprise database architectures for transactional, analytical, and operational apps.
• Develop data models (conceptual, logical, physical) aligned with business needs.
• Establish governance and standards for data management and architecture.
• Create scalable, highly available and secure database environments.
• Architect solutions for backup/recovery, replication and DR; ensure business continuity.
• Lead architecture reviews and technical design discussions; provide senior guidance.

Skills

SQL Server

T-SQL

SSIS

Power BI

Python

PowerShell

Data Warehouses

Data Lakes

Performance Tuning

Security & DR

Education

Bachelor's degree or equivalent

Tools

SSIS

Power BI

Python

PowerShell

Job description

Job Title: SQL Server Database Architect & Data Engineer

Location: New York, NY - Hybrid; 3 days onsite, 2 days remote

Duration: Thru 2/28/2027 (very likely to be extended)

Pay Range: $70-75/hr (W2), depending on experience

Interview Process: First round virtual via MS Teams, 2nd round likely onsite in New York, NY

Position Overview

Our Fortune 500 client located in New York, NY is seeking an experienced Senior SQL Server Database Architect & Data Engineer to design, administer, optimize, integrate, and govern enterprise data platforms supporting critical business applications, analytics, reporting, and digital transformation initiatives.

This is a senior, hands‑on hybrid role combining database architecture, SQL Server administration, and data engineering. The successful candidate will be responsible for building and maintaining scalable, secure, highly available database solutions while developing enterprise ETL processes, data pipelines, data warehouse/lake solutions, and reporting capabilities.

The ideal candidate brings deep Microsoft SQL Server and advanced SQL/T‑SQL expertise, complemented by experience with SSIS, data warehousing, data lakes, Power BI, Python, PowerShell, performance tuning, backup/recovery, disaster recovery, and database security.

Key Responsibilities

• Design and maintain enterprise database architectures supporting transactional, analytical, and operational applications.
• Develop conceptual, logical, and physical data models aligned with business and technical requirements.
• Establish and maintain database architecture standards, design principles, governance practices, and data‑management standards.
• Design scalable, secure, highly available, and resilient database environments.
• Architect solutions for high availability, replication, disaster recovery, backup/recovery, and business continuity.
• Facilitate database architecture reviews and technical design sessions.

SQL Server Database Administration

• Administer and support enterprise Microsoft SQL Server environments.
• Monitor database health, availability, performance, capacity, and utilization.
• Perform advanced database performance tuning, indexing, query optimization, and performance analysis.
• Develop and optimize SQL/T‑SQL scripts, queries, stored procedures, and other database objects.
• Implement and maintain backup, recovery, replication, security, and access‑control solutions.
• Troubleshoot complex production database issues, perform root‑cause analysis, and implement long‑term corrective solutions.
• Support capacity planning, monitoring, maintenance, upgrades, and ongoing database operations.
• Participate in planned maintenance activities and provide support during critical production incidents when required.
• Design, develop, maintain, and optimize enterprise ETL processes and data pipelines.
• Develop data integration solutions using SSIS, SQL/T‑SQL, Python, PowerShell, and other automation technologies.
• Support enterprise data warehouse, data lake, and lakehouse architectures.
• Develop data cleansing, transformation, validation, reconciliation, and integration processes.
• Automate data movement and recurring operational processes using modern scripting and engineering practices.
• Ensure reliable movement and integration of data across enterprise applications, databases, analytics platforms, and reporting environments.
• Support enterprise analytics, business intelligence, and reporting initiatives.
• Develop and maintain data structures supporting analytical and reporting requirements.
• Partner with business and technical teams to provide reliable, analytics‑ready enterprise data.
• Support Power BI and related enterprise reporting solutions.
• Improve data availability, quality, performance, and usability for downstream reporting and analytics.

Data Governance, Security & Compliance

• Follow enterprise standards for data governance, metadata management, master data management, and data architecture.
• Maintain data quality, integrity, consistency, and lineage across enterprise systems.
• Implement and maintain role‑based access controls, auditing, and database security standards.
• Partner with cybersecurity and compliance teams to protect critical enterprise data assets.
• Support regulatory, audit, SOX, and data‑retention requirements.
• Incorporate security and governance requirements into database architecture and data‑engineering solutions.

Technical Leadership & Collaboration

• Partner with business stakeholders, application‑development teams, infrastructure teams, cybersecurity, analytics teams, and external contractors.
• Lead and participate in database architecture reviews and technical design discussions.
• Provide senior‑level technical guidance across database administration, architecture, and data‑engineering initiatives.
• Develop and maintain technical documentation covering database environments, development environments, standards, procedures, current initiatives, and operational responsibilities.
• Manage multiple technical priorities while supporting both strategic initiatives and ongoing production operations.

Required Qualifications

• 10+ years of experience in database administration, database architecture, database design, or closely related disciplines.
• 5+ years supporting enterprise or large‑scale organizational environments.
• Deep hands‑on expertise administering and supporting Microsoft SQL Server.
• Advanced proficiency with SQL and T‑SQL, including complex queries, scripting, and stored procedures.
• Strong database architecture and relational data‑modeling experience.
• Strong experience with SSIS and enterprise ETL development.
• Experience designing, developing, or supporting data warehouses and data lakes.
• Hands‑on experience with Python and PowerShell for scripting, automation, data processing, or operational support.
• Experience supporting Power BI and enterprise analytics/reporting requirements.
• Strong database performance‑tuning experience, including indexing and query optimization.
• Experience with database backup/recovery, disaster recovery, security, capacity planning, monitoring, and automation.
• Demonstrated enterprise data‑integration and analytics experience.
• Strong troubleshooting, analytical, and root‑cause‑analysis capabilities.
• Understanding of data governance, data quality, security, access control, and cybersecurity principles.
• Strong written and verbal communication skills with the ability to communicate technical concepts effectively to technical stakeholders.
• High school diploma, associate degree, bachelor's degree, or an equivalent combination of education and relevant professional experience.

Preferred Qualifications

• Experience with additional scripting and development technologies such as VBA and shell scripting.
• Experience with metadata management, master data management, and data lineage.
• Experience supporting regulatory, audit, SOX, or enterprise data‑retention requirements.
• Experience developing database standards, governance frameworks, and technical operating procedures.
• Experience leading technical initiatives and coordinating work across application, infrastructure, security, analytics, and business teams.

This is