Sr.Data Engineer/ETL Technical Lead
Job Description
Robotics Technologies is hiring a contract Sr. Data Engineer/ETL Technical Lead in Rhode Island (onsite).
Responsibilities
- Support, maintain, and continuously improve a large portfolio of enterprise data pipeline jobs across ingestion, transformation, and downstream data delivery.
- Troubleshoot complex production issues and lead recovery efforts; coordinate with 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.
- Implement proactive monitoring, data quality controls, and automated recovery mechanisms to improve data platform reliability.
- Analyze source-system changes, evaluate downstream impact, and deliver data integration enhancements across hundreds of interconnected data assets.
- Act 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.
- Proven experience supporting and maintaining a large portfolio of production data pipelines in a complex enterprise environment.
- Strong troubleshooting and root cause analysis skills with the ability to rapidly resolve production incidents.
- Ability to work independently with minimal supervision while taking full ownership of outcomes.
- Excellent written and verbal communication skills; can communicate effectively with business, operations, and technical stakeholders.
- Entrepreneurial mindset with accountability, urgency, and a continuous improvement focus.
- Experience leading technical initiatives and influencing teams without relying solely on formal authority.
Technologies
- T-SQL
- Stored procedures
- Relational database design
- AWS
- Redshift
Preferred Qualifications
- Experience with AWS, Redshift, ETL frameworks, scheduling platforms, and enterprise data integration technologies.
- Financial services experience related to risk, compliance, AML, or regulatory reporting.
- Prior experience serving as a technical lead in a mission-critical, time-sensitive production environment.
Location: Rhode Island (onsite)
Compensation: USD 78 per hour
Job Type: Contract