SQL Server - SSIS Architect - FULLY REMOTE - Must Have Any State Experience with Dept. of Transportation
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for an SQL Server - SSIS Architect with a contract length of "unknown", offering a pay rate of "unknown". It requires 12+ years of SQL Server and SSIS experience, expertise in ETL, cloud integrations, and any state experience with the Dept. of Transportation.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
-
🗓️ - Date discovered
September 3, 2025
🕒 - Project duration
Unknown
-
🏝️ - Location type
Unknown
-
📄 - Contract type
Unknown
-
🔒 - Security clearance
Unknown
-
📍 - Location detailed
Columbia, SC
-
🧠 - Skills detailed
#Indexing #Data Migration #API (Application Programming Interface) #AWS (Amazon Web Services) #Java #JSON (JavaScript Object Notation) #Version Control #"ETL (Extract #Transform #Load)" #Agile #SSIS (SQL Server Integration Services) #REST (Representational State Transfer) #.Net #Schema Design #Project Management #Databases #Azure #GIT #XML (eXtensible Markup Language) #Data Ingestion #Deployment #Compliance #Logging #SQL (Structured Query Language) #Data Pipeline #Synapse #Data Mapping #SQL Server #ADF (Azure Data Factory) #DevOps #AWS Glue #Data Quality #Databricks #Azure Data Factory #Migration #Cloud #Data Governance
Role description
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
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
