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

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.