Senior SQL Developer & Data Engineer – ETL/ELT, SQL Server & BI

Seneca Resources; New York (NY); Hybrid; USD 76,000 - 90,000; Full time

Benefits offered by this job

Hybrid schedule (3 onsite / 2 remote)

Competitive pay: $55–$65/hr W2

Long‑term contract potential

Job summary

Seneca Resources in New York City is seeking a Senior SQL Developer and Data Engineer to lead ETL/ELT pipelines, optimize SQL Server performance, and support enterprise data platforms. This hands‑on role requires strong T‑SQL and data integration expertise to deliver reliable data solutions for critical business applications.

You will design and tune complex queries, build data pipelines, and collaborate with DBAs, developers, and analysts in a large enterprise.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent professional experience.
• 5–8 years of hands‑on Microsoft SQL Server development experience.
• 6+ years of software development and systems integration experience.
• Advanced expertise in T‑SQL, including complex queries, joins, stored procedures, views, and query optimization.
• Strong experience designing, developing, maintaining, and troubleshooting ETL/ELT pipelines and enterprise data integrations.
• Experience with data ingestion, incremental loading, transformations, validation, reconciliation, and data quality processes.
• Hands‑on experience with enterprise data warehousing and dimensional data modeling.
• Strong SQL Server performance tuning skills, including indexing strategies, execution plans, and query optimization.
• Experience with database design, schema modifications, and troubleshooting database‑driven applications.
• Ability to independently investigate and resolve complex database, application, and data integration issues.
• Experience supporting enterprise reporting and business intelligence solutions.
• Strong technical documentation, testing, and production support experience.
• Excellent analytical, problem‑solving, communication, and organizational skills.
• Ability to work onsite in New York City 3 days per week.

Responsibilities

• Design, develop, optimize, and maintain complex T‑SQL queries, stored procedures, views, functions, and database objects.
• Perform SQL Server performance tuning, execution plan analysis, indexing optimization, and query troubleshooting.
• Design, build, and support enterprise ETL/ELT pipelines, data ingestion, transformation, and integration workflows.
• Develop incremental loading, data validation, reconciliation, and data quality processes.
• Support enterprise data warehousing, dimensional modeling, and business intelligence solutions.
• Contribute to database architecture, schema design, scalability, security, and operational reliability.
• Troubleshoot database performance issues, data pipeline failures, integration errors, and production incidents.
• Assist with SQL Server monitoring, maintenance, backup verification, and administrative support as needed.
• Develop technical test plans, validate database changes, and support application releases and production deployments.
• Maintain technical documentation, deployment procedures, scripts, and operational support runbooks.
• Collaborate with developers, DBAs, data engineers, business analysts, and stakeholders to deliver scalable data solutions.
• Identify opportunities to improve database performance, automation, data integrity, and overall system efficiency.

Job description

Job Title: Senior SQL Developer & Data Engineer – ETL/ELT, SQL Server & BI

Job Location: New York, NY (Hybrid – 3 days onsite, 2 days remote)

Contract Length: Through April 30, 2027, with likely extension

Pay Range: $55–$65/hr W2, depending on experience

Interview Process: 1st round via Microsoft Teams; 2nd round onsite in New York, NY

Position Overview

Our Fortune 500 client in New York City is seeking an experienced Senior SQL Developer & Data Engineer to support enterprise data platforms, critical business applications, analytics, and digital transformation initiatives.

This hands‑on technical role combines advanced Microsoft SQL Server development, ETL/ELT data engineering, database architecture, and operational support. The ideal candidate will have strong T‑SQL development expertise, experience building and optimizing enterprise data pipelines, and the ability to independently troubleshoot complex database performance and data quality issues.

This is an excellent opportunity for a technically strong SQL professional who enjoys solving complex problems, improving data reliability, and collaborating with cross‑functional teams in a large enterprise environment.

Key Responsibilities

• Design, develop, optimize, and maintain complex T‑SQL queries, stored procedures, views, functions, and database objects.
• Perform SQL Server performance tuning, execution plan analysis, indexing optimization, and query troubleshooting.
• Design, build, and support enterprise ETL/ELT pipelines, data ingestion, transformation, and integration workflows.
• Develop incremental loading, data validation, reconciliation, and data quality processes.
• Support enterprise data warehousing, dimensional modeling, and business intelligence solutions.
• Contribute to database architecture, schema design, scalability, security, and operational reliability.
• Troubleshoot database performance issues, data pipeline failures, integration errors, and production incidents.
• Assist with SQL Server monitoring, maintenance, backup verification, and administrative support as needed.
• Develop technical test plans, validate database changes, and support application releases and production deployments.
• Maintain technical documentation, deployment procedures, scripts, and operational support runbooks.
• Collaborate with developers, DBAs, data engineers, business analysts, and stakeholders to deliver scalable data solutions.
• Identify opportunities to improve database performance, automation, data integrity, and overall system efficiency.

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent professional experience.
• 5–8 years of hands‑on Microsoft SQL Server development experience.
• 6+ years of software development and systems integration experience.
• Advanced expertise in T‑SQL, including complex queries, joins, stored procedures, views, functions, and query optimization.
• Strong experience designing, developing, maintaining, and troubleshooting ETL/ELT pipelines and enterprise data integrations.
• Experience with data ingestion, incremental loading, transformations, validation, reconciliation, and data quality processes.
• Hands‑on experience with enterprise data warehousing and dimensional data modeling.
• Strong SQL Server performance tuning skills, including indexing strategies, execution plans, and query optimization.
• Experience with database design, schema modifications, and troubleshooting database‑driven applications.
• Ability to independently investigate and resolve complex database, application, and data integration issues.
• Experience supporting enterprise reporting and business intelligence solutions.
• Strong technical documentation, testing, and production support experience.
• Excellent analytical, problem‑solving, communication, and organizational skills.
• Ability to work onsite in New York City 3 days per week.

Preferred Qualifications

• SQL Server database administration experience, including security, maintenance, backup, and recovery.
• PowerShell scripting and automation experience.
• Experience with Azure DevOps, GitHub, or similar version control and deployment platforms.
• Experience supporting large‑scale enterprise reporting and business intelligence environments.
• Knowledge of database availability, reliability, and operational support practices.
• Experience supporting production deployments, release management, and application integrations.
• Previous experience in utilities, energy, infrastructure, or other operationally critical enterprise environments.

Why This Opportunity?

• Work with a Fortune 500 organization supporting critical enterprise data platforms and business applications.
• Contribute to data modernization, database architecture, and business intelligence initiatives.
• Gain exposure to complex, enterprise‑scale SQL Server and data engineering environments.
• Hybrid schedule with 2 remote days per week.
• Competitive compensation of $55–$65/hr W2.
• Long‑term contract opportunity with potential extension.

About Seneca Resources

Seneca Resources is a client‑focused provider of Information Technology consulting services and workforce solutions for government and commercial organizations across the United States.

Our success is driven by a strong corporate culture that values collaboration, professional growth, and career development. We offer engaging work, competitive compensation, ongoing training, and opportunities for advancement.