DeveloperJobs.io
← Back to all jobs

Job Description

Lead enterprise ETL and data pipeline reliability from Rhode Island on an onsite contract basis.

Responsibilities

  • Own support, maintenance, and continuous improvement of a large portfolio of enterprise data pipeline jobs across ingestion, transformation, and downstream delivery.
  • Lead troubleshooting for complex production issues, drive recovery efforts, and coordinate across ETL, DBA, infrastructure, scheduling, and source-system teams.
  • Develop and optimize complex T-SQL, including stored procedures, performance tuning, data validation routines, reconciliation processes, and operational control logic.
  • Design and implement proactive monitoring, data quality controls, and automated recovery mechanisms to improve platform reliability.
  • Analyze source-system changes, assess downstream impacts, 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 resolve production incidents quickly.
  • Ability to work independently with minimal supervision, demonstrating full ownership of outcomes.
  • Excellent written and verbal communication to collaborate effectively with business, operations, and technical stakeholders.
  • Entrepreneurial mindset with accountability, urgency, and continuous improvement.
  • 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, including risk, compliance, AML, or regulatory reporting.
  • Experience acting as a technical lead in a mission-critical, time-sensitive production environment.

Job Details

  • Location: Rhode Island (onsite)
  • Employment type: Contract
  • Compensation: USD 78 - 78 per hourly

Similar Jobs