ETL SSIS developer

Matrix Global•Jacksonville, FL

About The Position

Matrix is seeking an experienced ETL / SSIS Developer to design, develop, optimize, and support enterprise data integration solutions and SQL Server databases. The role focuses on hands-on Microsoft SQL Server Integration Services (SSIS), advanced T-SQL development, SQL performance tuning, and practices that support data quality, security, and database reliability. The developer will build and maintain scalable ETL pipelines, apply modern data architecture principles, and follow Git-based development and database CI/CD practices. The position also involves collaborating with business stakeholders and technical teams, supporting production pipelines, and maintaining documentation. Jacksonville, Florida, is listed as the preferred location.

Requirements

Strong hands-on experience with Microsoft SSIS and Microsoft SQL Server.
Proficiency in T-SQL development, including complex queries, stored procedures, functions, and views.
Demonstrated experience with SQL query optimization, execution plan analysis, indexing, and performance tuning.
Experience designing, developing, and supporting enterprise-grade ETL pipelines.
Understanding of data modeling, data transformation, data validation, and data quality management.
Knowledge of database security, access controls, error handling, transaction management, and reliability practices.
Familiarity with Git-based development workflows, code reviews, and structured release processes.
Strong analytical, troubleshooting, problem-solving, and communication skills.
Ability to work collaboratively with technical teams and business stakeholders.

Nice To Haves

Experience with Talend Data Integration or other enterprise ETL platforms.
Familiarity with GitHub Copilot or other AI-assisted development tools.
Experience with automated testing, database version control, and CI/CD pipeline implementation.
Understanding of Medallion Architecture and bronze, silver, and gold data processing layers.
Experience supporting data integration solutions in banking or financial services.
Familiarity with production monitoring, incident management, and root-cause analysis.

Responsibilities

Design, develop, maintain, and optimize enterprise ETL pipelines using Microsoft SSIS.
Develop and maintain production-grade T-SQL solutions, including stored procedures, functions, views, and complex queries.
Analyze execution plans, troubleshoot performance bottlenecks, optimize queries, and implement indexing strategies.
Implement data validation, reconciliation, logging, error handling, and transaction management to ensure data accuracy and consistency.
Follow secure SQL development practices, including parameterized dynamic SQL, least-privilege access, and role-based security controls.
Apply Medallion Architecture principles across bronze, silver, and gold data layers.
Collaborate with business stakeholders, product owners, and data engineering teams to translate business requirements into scalable technical solutions.
Use Git-based version control, code reviews, automated testing, and database CI/CD pipelines.
Use AI coding assistants to support development, testing, documentation, and code optimization, reviewing and validating generated outputs.
Monitor data pipelines and SLAs/SLOs, troubleshoot production incidents, perform root-cause analysis, and implement corrective actions.
Maintain technical documentation, data mappings, deployment procedures, and development standards.