Senior ETL Developer (SSIS) — SQL Performance & Data Quality

Matrix Usa Inc; Jacksonville (FL); On-site; USD 110,000 - 150,000; Full time

Job summary

Matrix Usa Inc is seeking an experienced ETL/SSIS Developer to design, develop, optimize, and support enterprise data integration solutions and SQL Server databases.

The role emphasizes SSIS, T-SQL, ETL pipelines, data quality, security, DevOps/CI-CD, and Medallion Architecture. You will collaborate with business stakeholders and data engineering teams, implement secure coding practices, and participate in production support and documentation.

Qualifications

• 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.

Responsibilities

• ETL Development: Design, develop, maintain, and optimize enterprise ETL pipelines using Microsoft SSIS to support reliable data extraction, transformation, and loading.
• SQL Development: Develop and maintain production-grade T-SQL solutions, including stored procedures, functions, views, and complex queries.
• Performance Optimization: Analyze execution plans, troubleshoot performance bottlenecks, optimize queries, and implement appropriate indexing strategies.
• Data Quality and Integrity: Implement data validation, reconciliation, logging, error handling, and transaction management to ensure data accuracy and consistency.
• Database Security: Follow secure SQL development practices, including parameterized dynamic SQL, least-privilege access, and role-based security controls.
• Data Architecture: Apply Medallion Architecture principles across bronze, silver, and gold data layers to support structured data processing and quality management.
• Requirements Analysis: Collaborate with business stakeholders, product owners, and data engineering teams to translate business requirements into scalable technical solutions.
• DevOps and CI/CD: Use Git-based version control, code reviews, automated testing, and database CI/CD pipelines to maintain code quality and deployment reliability.
• AI-Assisted Development: Leverage AI coding assistants to improve development efficiency, testing, documentation, and code optimization, ensuring all generated outputs are reviewed and validated.
• Production Support: Monitor data pipelines and service-level agreements (SLAs) and objectives (SLOs), troubleshoot production incidents, perform root-cause analysis, and implement corrective actions.
• Documentation and Best Practices: Maintain technical documentation, data mappings, deployment procedures, and development standards to support long-term maintainability.

Skills

SSIS

T-SQL

Performance tuning

Data modeling

Git workflows

CI/CD

AI-assisted development

Tools

Microsoft SQL Server

Talend Data Integration

GitHub Copilot

Job description

Matrix Usa Inc is seeking an experienced ETL/SSIS Developer to design, develop, optimize, and support enterprise data integration solutions and SQL Server databases.

The role emphasizes SSIS, T-SQL, ETL pipelines, data quality, security, DevOps/CI-CD, and Medallion Architecture. You will collaborate with business stakeholders and data engineering teams, implement secure coding practices, and participate in production support and documentation.