Senior Data Engineer – AML Data Hub

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

Job Description

• Own the support, maintenance, and continuous improvement of a large portfolio of enterprise data pipeline jobs spanning ingestion, transformation, and downstream data 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.

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

Preferred Qualifications

• Experience with AWS, Redshift, ETL frameworks, scheduling platforms, and enterprise data integration technologies.
• Financial services, risk, compliance, AML, or regulatory reporting experience.
• Prior experience acting as a technical lead in a mission-critical, time-sensitive production environment.

What Makes Someone Successful in This Role

A successful candidate is a self-starter who thinks like an owner, communicates clearly under pressure, leads through influence, and is equally comfortable writing SQL, solving production issues, and directing cross-functional teams during critical incidents.