Sr.Data Engineer/ETL Technical Lead
Job Description
Support, maintain, and continuously improve enterprise ETL data pipelines in a technical leadership role focused on T-SQL reliability and production recovery.
Responsibilities
- Own the support, maintenance, and continuous improvement of a large portfolio of enterprise data pipeline jobs spanning ingestion, transformation, and downstream data delivery.
- Troubleshoot complex production issues, lead recovery efforts, and coordinate work across ETL, DBA, infrastructure, scheduling, and source-system teams.
- Develop and optimize complex T-SQL solutions including stored procedures, query/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 implement 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.
Requirements
- 8+ years of data engineering, ETL, 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 to rapidly resolve production incidents.
- 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 accountability, urgency, and continuous improvement focus.
- Ability to lead technical initiatives and influence teams without relying only on formal authority.
Technology
- T-SQL
- Stored procedures
- Relational database design
- AWS
- Redshift
Preferred Qualifications
- Experience with AWS, Redshift, ETL frameworks, scheduling platforms, and enterprise data integration technologies.
- Experience in financial services, risk, compliance, AML, or regulatory reporting.
- Prior experience acting as a technical lead in a mission-critical, time-sensitive production environment.
Job Details
- Location: Rhode Island (onsite)
- Job type: Contract
- Compensation: USD 78 - 78 per hourly
- Minimum experience: 8 years