Senior SQL & Data Engineer — ETL/ELT Expert, Hybrid NY

Seneca Resources; New York (NY); Híbrido; USD 76 000 - 90 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Hybrid schedule (3 onsite / 2 remote)

Competitive pay: $55–$65/hr W2

Long‑term contract potential

Resumo da oferta

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.

Qualificações

• 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.

Responsabilidades

• 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.

Descrição da oferta de emprego

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.