Senior SQL Developer & Data Engineer – SQL Server & BI

Requirements:

• We require a bachelors degree in Computer Science, Information Technology, or a related field, or equivalent professional experience.
• Were seeking 5–8 years of hands-on Microsoft SQL Server development experience and 6+ years of software development and systems integration experience.
• You should have advanced T-SQL expertise, including complex queries, joins, stored procedures, views, functions, and query optimization.
• We require strong experience designing, developing, maintaining, and troubleshooting ETL/ELT pipelines and enterprise data integrations.
• You should have experience with data ingestion, incremental loading, transformations, validation, reconciliation, and data quality processes.
• Were looking for hands-on experience with enterprise data warehousing and dimensional data modeling.
• You should have strong SQL Server performance-tuning skills, including indexing strategies, execution plans, and query optimization.
• We require experience with database design, schema modifications, and troubleshooting database-driven applications.
• You should be able to independently investigate and resolve complex database, application, and data integration issues.
• Were seeking experience supporting enterprise reporting and business intelligence solutions, along with strong technical documentation, testing, and production support experience.
• You should bring excellent analytical, problem-solving, communication, and organizational skills, and be able to work onsite in New York City three days per week.
• Preferred: SQL Server database administration experience, including security, maintenance, backup, and recovery.
• Preferred: PowerShell scripting and automation experience.
• Preferred: Experience with Azure DevOps, GitHub, or similar version control and deployment platforms.
• Preferred: Experience supporting large-scale enterprise reporting and business intelligence environments.
• Preferred: Knowledge of database availability, reliability, and operational support practices.
• Preferred: Experience supporting production deployments, release management, and application integrations.
• Preferred: Previous experience in utilities, energy, infrastructure, or other operationally critical enterprise environments.

Responsibilities:

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

Technologies:

• Azure
• Business Intelligence
• DevOps
• ETL
• GitHub
• Support
• PowerShell
• SQL
• Security
• Cloud

More

Were seeking a Senior SQL Developer & Data Engineer to support a Fortune 500 clients enterprise data platforms, critical business applications, analytics, and digital transformation initiatives. This hands-on role combines SQL Server development, data engineering, database architecture, and operational support in a large enterprise environment. The position is based in New York, NY, with a hybrid schedule of three onsite days and two remote days per week. The contract runs through April 30, 2027, with a likely extension, and compensation is $55–$65 per hour on W2, depending on experience. Interviews include an initial Microsoft Teams round and a second round onsite in New York. We are Seneca Resources, a client-focused provider of IT consulting services and workforce solutions for government and commercial organizations across the United States. Our culture values collaboration, professional growth, and career development, and we offer engaging work, competitive compensation, ongoing training, and advancement opportunities. This opportunity includes work on data modernization, database architecture, business intelligence initiatives, and complex enterprise-scale SQL Server and data engineering environments.

last updated 43 week of 2026