Senior Data Engineer - Pipelines, Reliability & SQL Expert

New York Technology Partners; Johnston (RI); On-site; USD 120,000 - 180,000; Full time

Job summary

New York Technology Partners is seeking a senior data engineer to own and optimize a broad portfolio of enterprise data pipelines. You will troubleshoot complex production issues, coordinate across ETL, DBA, infrastructure, scheduling, and source-system teams, and lead automated recovery and data quality initiatives.

The role requires deep T-SQL expertise, experience with large-scale production environments, and strong communication with business and technical stakeholders.

Qualifications

• 8+ years of data engineering or enterprise data warehouse experience.
• Advanced expertise in T-SQL, query optimization, stored procedures, and relational database design.
• Experience supporting and maintaining a large portfolio of production data pipelines in a complex enterprise environment.
• Strong troubleshooting and root cause analysis skills for rapid production issue resolution.
• Ability to work independently with minimal supervision and take ownership of outcomes.
• Excellent written and verbal communication with business, operations, and technical stakeholders.

Responsibilities

• Own support, maintenance, and continuous improvement of a large portfolio of enterprise data pipeline jobs.
• Troubleshoot complex production issues, lead recovery efforts, coordinate across ETL, DBA, infrastructure, scheduling, and source-system teams.
• Develop and optimize complex T-SQL solutions, including stored procedures and data validation routines.
• Design and implement proactive monitoring, data quality controls, and automated recovery mechanisms.
• Analyze source-system changes, assess downstream impacts, and lead data integration enhancements.
• Serve as a technical SME for data lineage, data models, audit frameworks, and batch processing.

Skills

T-SQL

Query optimization

Stored procedures

Relational database design

ETL

Production data pipelines

Troubleshooting

Stakeholder communication

Job description

New York Technology Partners is seeking a senior data engineer to own and optimize a broad portfolio of enterprise data pipelines. You will troubleshoot complex production issues, coordinate across ETL, DBA, infrastructure, scheduling, and source-system teams, and lead automated recovery and data quality initiatives.

The role requires deep T-SQL expertise, experience with large-scale production environments, and strong communication with business and technical stakeholders.