About The Position

Seeking a seasoned Senior SQL & SSIS Developer to design, build, and optimize high-performance data pipelines and ETL solutions across enterprise data platforms. The role owns complex SQL development, SSIS orchestration, performance tuning, and production support. The ideal candidate has hands-on experience integrating on-premises SQL Server and SSIS with cloud services, along with some AWS Lambda knowledge for event-driven processing and lightweight transformations.

Requirements

  • Senior-level experience developing with SQL and SSIS.
  • Hands-on experience integrating on-premises SQL Server and SSIS with cloud services.
  • Some knowledge of AWS Lambda for event-driven processing and lightweight transformations.

Responsibilities

  • Design, develop, and maintain SSIS packages for ETL processes, including error handling and logging.
  • Build and optimize SQL objects, including stored procedures, functions, and views, for high-performance data operations.
  • Migrate and consolidate data from files, APIs, and databases into SQL Server.
  • Implement parameterized, reusable ETL frameworks and metadata-driven pipelines.
  • Diagnose and tune query performance using execution plans, indexing, and partitioning strategies.
  • Optimize SSIS data flows for efficiency, including buffers, parallelism, and incremental loads.
  • Implement data quality checks, reconciliation processes, and audit trails.
  • Enforce security controls for sensitive data, including encryption, secrets management, and PII handling.
  • Create and maintain technical documentation, including data lineage and runbooks.
  • Partner with cross-functional teams to gather requirements and deliver solutions.
  • Lead code reviews, mentor junior developers, and promote best practices.
  • Troubleshoot and resolve production issues, perform root cause analysis, and implement fixes.
  • Contribute to modernization initiatives, such as migration from SSIS to cloud-native solutions.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service