Senior SQL Developer & Data Engineer – ETL/ELT, SQL Server & BI
Seneca Resources · New York, New York, United States
FULL TIMEpermanent
Job Description
Job Title: Senior SQL Developer & Data Engineer – ETL/ELT, SQL Server & BIJob Location: New York, NY (Hybrid – 3 days onsite, 2 days remote)Contract Length: Through April 30, 2027, with likely extensionPay Range: $55–$65/hr W2, depending on experienceInterview Process: 1st round via Microsoft Teams; 2nd round onsite in New York, NY
Interested in learning more about this job Scroll down and find out what skills, experience and educational qualifications are needed.
Position OverviewOur 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 ResponsibilitiesDesign, 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 QualificationsBachelor'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 QualificationsSQL 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 ResourcesSeneca 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. xzbcwsv We offer engaging work, competitive compensation, ongoing training, and opportunities for advancement.
Interested in learning more about this job Scroll down and find out what skills, experience and educational qualifications are needed.
Position OverviewOur 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 ResponsibilitiesDesign, 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 QualificationsBachelor'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 QualificationsSQL 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 ResourcesSeneca 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. xzbcwsv We offer engaging work, competitive compensation, ongoing training, and opportunities for advancement.