SSIS SQL Engineer

Veriipro; Center Square (PA); On-site; USD 110,000 - 140,000; Full time

Job summary

Veriipro seeks an experienced SSIS SQL Engineer to design, develop, optimize, and maintain data integration solutions in an Agile environment. The role requires hands-on work with SQL Server, SSIS, ETL development, and database optimization, with a focus on scalable data solutions and data quality.

You will collaborate with engineers, analysts, and stakeholders, mentor junior staff, and contribute to best practices and process improvements across data engineering.

Qualifications

• : Experience with SQL Server, SSIS, ETL design and development.
• : Advanced knowledge of T-SQL, stored procedures, and data modeling concepts.
• : Experience in Agile software development and data integration projects.

Responsibilities

• : Design, develop, and maintain SSIS packages and ETL workflows.
• : Develop and optimize complex SQL queries, stored procedures, and views.
• : Perform ETL from multiple source systems and ensure data quality.
• : Tune queries, indexing strategies, and performance across data pipelines.
• : Collaborate with cross-functional teams and mentor engineers.

Skills

SQL development

SSIS

ETL development

Query optimization

Agile

Tools

SQL Server

SSIS

Job description

Job Overview

We are seeking an experienced SSIS SQL Engineer to design, develop, optimize, and maintain data integration solutions within an Agile software development environment. The ideal candidate will have strong expertise in SQL Server, SSIS, ETL development, and database optimization, along with the ability to collaborate with cross-functional teams, mentor engineers, and promote best practices.This role requires a hands-on engineer who can build scalable data solutions, troubleshoot complex data issues, and contribute to continuous improvements in development processes.

Roles and Responsibilities

• Design, develop, and maintain SSIS packages and ETL workflows to support data integration and analytics initiatives.
• Develop and optimize complex SQL queries, stored procedures, views, and database objects.
• Perform data extraction, transformation, and loading (ETL) from multiple source systems.
• Analyze and improve SQL performance through query tuning, indexing strategies, and optimization techniques.
• Troubleshoot data integration issues and ensure data accuracy, quality, and consistency.
• Participate in Agile ceremonies including sprint planning, stand-ups, and code reviews.
• Collaborate with developers, analysts, and business stakeholders to deliver reliable data solutions.
• Mentor team members on SQL development, SSIS best practices, and coding standards.
• Lead and contribute to technical discussions around data engineering practices and process improvements.
• Ensure adherence to development standards, documentation practices, and quality guidelines.

Required Qualifications

• Strong experience with SQL Server development and SSIS (SQL Server Integration Services).
• Hands-on experience designing and implementing ETL solutions.
• Advanced knowledge of:
  • T‑SQL
  • Stored procedures
  • Query optimization
  • Database performance tuning
  • Data modeling concepts
• Experience working in an Agile software development environment.
• Strong debugging, analytical, and problem-solving skills.
• Ability to collaborate effectively with technical teams and mentor junior engineers.

Preferred Qualifications

• Experience working with large-scale data platforms and analytics environments.
• Experience in healthcare analytics or other data-intensive industries.
• Familiarity with data quality, governance, and validation practices.
• Experience with modern software development practices, CI/CD processes, and source control tools.
• Strong communication skills with the ability to lead technical discussions and code reviews.