SQL Server - SSIS Architect - Fully REMOTE - Must have State experience with Dept of Transportation.
Role: Architect + Lead Developer with responsibility for complex SQL/SSIS builds, system integrations, and light project management. Will guide mid-level developers, enforce standards, and deliver secure, optimized ETL solutions. 12+ years in SQL Server and SSIS development, with extensive experience designing and maintaining large-scale ETL pipelines. • Proven track record of on-prem ↔ cloud integrations and data migration strategies. • Hands-on designing gateway/staging DBs, secure ETL pipelines, and data governance frameworks. • Strong background in data quality, lineage, reconciliation reporting, and audit trails. • Demonstrated ability to lead teams, coordinate with stakeholders, and deliver projects using Agile/PMI methodologies. • Experience mentoring mid-level developers in SSIS best practices, performance tuning, and DevOps pipelines. • SQL Server: Advanced T-SQL, schema design, indexing strategies, stored procedures, views, query optimization. • SSIS (SQL Server Integration Services): • Complex Data Flows, Control Flows, Error Paths, Script Tasks. • Advanced package design, parameters, variables, parent/child packages. • Logging, deployment to SSISDB, and automated job scheduling. • Optimization for high-volume data pipelines. • Integration & File Handling: REST, SOAP, JSON, XML, flat files, SFTP/CSV imports. • Gateway & Staging Databases: design and usage for data ingestion, cleansing, validation, and performance optimization. • RBAC & secure configuration management for compliance and governance. • Source-to-target data mapping, translations, and reconciliation logic across systems. • Version control & DevOps: Git, TFS, CI/CD pipelines for SQL/SSIS deployments. • .NET/Java for custom API connectors and integration extensions. • Exposure to cloud data services (Azure Data Factory, Synapse, Databricks, AWS Glue) for hybrid ETL solutions. • Familiarity with project management concepts (Agile, PMI), reporting, and stakeholder communication. Certification: Any SSIS Certification is Plus Apply tot his job