Senior Data Engineer: Enterprise Pipelines & T-SQL Expert

TechDigital Group; Johnston (RI); On-site; USD 125,000 - 180,000; Full time

Job summary

TechDigital Group in Johnston, RI, seeks a senior data engineer to own support, maintenance, and continuous improvement of a large portfolio of enterprise data pipelines across ingestion, transformation, and delivery.

The role requires deep T-SQL expertise, incident leadership, and coordination with ETL, DBA, and infrastructure teams to prevent outages while driving performance and quality.

Qualifications

• 8+ years of data engineering, ETL, or enterprise data warehouse experience.
• Advanced expertise in T-SQL, query optimization, stored procedures, and relational database design.
• Demonstrated experience supporting and maintaining a large portfolio of production data pipelines within a complex enterprise environment.
• Strong troubleshooting and root cause analysis skills with the ability to rapidly resolve production incidents.
• Proven ability to work independently with minimal supervision while taking full ownership of outcomes.
• Excellent written and verbal communication skills with the ability to communicate effectively with business, operations, and technical stakeholders.
• Entrepreneurial mindset with a strong sense of accountability, urgency, and continuous improvement.
• Experience leading technical initiatives and influencing teams without relying solely on formal authority.

Responsibilities

• Own the support, maintenance, and continuous improvement of a large portfolio of enterprise data pipeline jobs spanning ingestion, transformation, and downstream delivery processes.
• Troubleshoot complex production issues, lead recovery efforts, and coordinate activities across ETL, DBA, infrastructure, scheduling, and source-system teams.
• Develop and optimize complex T-SQL solutions, including stored procedures, performance tuning, data validation routines, reconciliation processes, and operational controls.
• Design and implement proactive monitoring, data quality controls, and automated recovery mechanisms to improve platform reliability.
• Analyze source-system changes, assess downstream impacts, and lead implementation of data integration enhancements across hundreds of interconnected data assets.
• Serve as a technical SME for data lineage, data models, audit frameworks, batch processing, and operational workflows.

Skills

T-SQL

Relational DB Design

Production Data Pipelines

Troubleshooting

Communication

Independent Work

Leadership Influence

Tools

AWS

Redshift

ETL Frameworks

Scheduling Platforms

Enterprise Data Integration

Job description

TechDigital Group in Johnston, RI, seeks a senior data engineer to own support, maintenance, and continuous improvement of a large portfolio of enterprise data pipelines across ingestion, transformation, and delivery.

The role requires deep T-SQL expertise, incident leadership, and coordination with ETL, DBA, and infrastructure teams to prevent outages while driving performance and quality.