ETL / SSIS Developer

Matrix Usa Inc; Jacksonville (FL); Presencial; USD 110.000 - 150.000; Jornada completa

Descripción de la vacante

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.

Formación

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

Responsabilidades

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

Conocimientos

SSIS

T-SQL

Performance tuning

Data modeling

Git workflows

CI/CD

AI-assisted development

Herramientas

Microsoft SQL Server

Talend Data Integration

GitHub Copilot

Descripción del empleo

We are seeking an experienced ETL / SSIS Developer to design, develop, optimize, and support enterprise data integration solutions and SQL Server databases. The ideal candidate will have strong hands‑on expertise in Microsoft SQL Server Integration Services (SSIS), advanced T‑SQL development, and SQL performance tuning, along with a solid understanding of data quality, security, and database reliability.

The role requires experience building and maintaining scalable ETL pipelines, applying modern data architecture principles, and following Git-based development and database onsibilities

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

Required 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.
• Strong analytical, troubleshooting, problem‑solving, and communication skills.
• Ability to work collaboratively with technical teams and business stakeholders.

Preferred Qualifications

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

Why Join Us?

You’ll work with a talented global team, contribute to meaningful technical initiatives, and help shape a high performing DevOps culture.

Matrix is a global, dynamic, and fast growing technology services and consulting company with over 17,000 employees worldwide. Founded in 2001, Matrix has grown through significant organic expansion and strategic acquisitions, executing some of the largest and most impactful technology projects in the market.

We specialize in the design, development, and implementation of advanced technologies, software solutions, and digital products. Our services include infrastructure and consulting, IT outsourcing and offshore delivery, training and assimilation programs, and acting as a trusted implementation and delivery partner for the world’s leading software vendors.

With deep expertise across both the private and public sectors—spanning Finance, Telecom, Healthcare, Hi Tech, Education, Defense, and Security—Matrix serves a strong customer base in Israel alongside a continuously expanding global client portfolio.

At Matrix, our people are at the heart of our success. We are a community of talented, creative, and dedicated professionals who are passionate about innovation and excellence. We actively attract, develop, and retain top talent, recognizing that every employee’s contribution is critical to our continued growth and future success.

Matrix’s success is built on a challenging and engaging work environment, competitive compensation and benefits, and meaningful career development opportunities. We foster a diverse, inclusive culture that encourages collaboration, continuous learning, and growth—together.

Join the winning team. Be challenged, grow your career, and enjoy the journey in a highly respected global organization.

To learn more, visit: www.matrix-ifs.com