1

Ssis Architect Jobs (NOW HIRING)

Knowledge of SSIS Architecture, Data integration design and DB concepts, working experience in other tools preferred. * Creating packages to perform data integration including CDC, snapshots.

Knowledge of SSIS Architecture, Data integration design and DB concepts, working experience in other tools preferred * Creating packages to perform data integration including CDC, snapshots

... SSIS Development SQL Server 2014 Developing ETL process between back office and downstream systems Integrating multiple applications point to a single applicATION FLOW Financial industry exp and ...

The SSIS Developer will provide support on projects including designing, building, and maintaining ... the Data Architecture team and provides technical design recommendations on the data mart ...

... and Architecture review, understanding of Data Modeling concepts At least 3+ years of hands on experience in Design, Development & Build activities in SSIS Suite Projects Knowledge of SSIS ...

The SSIS Developer will provide support on projects including designing, building, and maintaining ... the Data Architecture team and provides technical design recommendations on the data mart ...

Very strong experience in SSIS. * Very strong experience in SQL server * Must have worked on 2-3 large implementations for data lake and should have strong experience on data warehouse and DataMart ...

The SSIS Developer will provide support on projects including designing, building, and maintaining ... the Data Architecture team and provides technical design recommendations on the data mart ...

next page

Showing results 1-20

Ssis Architect information

See salary details

$47

$67

$99

How much do ssis architect jobs pay per hour?

As of Jun 15, 2026, the average hourly pay for ssis architect in the United States is $67.87, according to ZipRecruiter salary data. Most workers in this role earn between $51.68 and $99.04 per hour, depending on experience, location, and employer.

What is the salary of SSIS engineer?

The salary of an SSIS (SQL Server Integration Services) engineer typically ranges from $70,000 to $120,000 annually, depending on experience, location, and certifications. Senior roles or those in high-demand areas may offer higher compensation, and proficiency with related tools like SQL Server and data integration is often valued.

What does the SSIS stand for?

SSIS stands for SQL Server Integration Services, which is a component of Microsoft SQL Server used for data integration, transformation, and workflow applications. SSIS is commonly utilized by SSIS Architects and data professionals to develop data migration and ETL (Extract, Transform, Load) processes.

Is SSIS still in demand?

SSIS (SQL Server Integration Services) remains in demand for data integration and ETL processes, especially in organizations using Microsoft SQL Server environments. Professionals with skills in SSIS, along with knowledge of SQL and data warehousing, are valued for maintaining and developing data workflows in many industries.

What does an SSIS Architect do?

An SSIS Architect is responsible for designing, developing, and implementing data integration solutions using Microsoft SQL Server Integration Services (SSIS). They analyze business requirements, create data workflows, and ensure that data is efficiently extracted, transformed, and loaded (ETL) between systems. Additionally, they oversee the optimization, troubleshooting, and maintenance of ETL processes, collaborate with stakeholders, and help set best practices for data integration and management within an organization.

What are the key skills and qualifications needed to thrive as an SSIS Architect, and why are they important?

To thrive as an SSIS Architect, you need deep expertise in SQL Server Integration Services (SSIS), data warehousing concepts, ETL processes, and a strong background in database design and development. Familiarity with tools such as Microsoft SQL Server, Visual Studio, and proficiency in scripting languages like T-SQL or C# is typically required, along with certifications like Microsoft Certified: Data Engineer Associate being advantageous. Strong problem-solving abilities, attention to detail, and effective communication skills set outstanding SSIS Architects apart. These skills are crucial for designing robust, scalable data integration solutions that align with business requirements and ensure reliable data flows.

What is the difference between Ssis Architect vs Data Warehouse Developer?

AspectSsis Architect
Required CredentialsSQL certifications, SSIS expertise, possibly related certifications like Microsoft Certified: Data Analyst Associate
Work EnvironmentDesigning and overseeing ETL processes, collaborating with data teams, working in data integration projects
Employer & Industry UsageUsed in data integration, BI projects, and enterprise data solutions across industries
Common Search & ComparisonOften compared with roles involving data integration, ETL design, and architecture

The Ssis Architect focuses on designing and overseeing SQL Server Integration Services (SSIS) solutions, ensuring efficient data workflows. In contrast, a Data Warehouse Developer primarily builds and maintains data warehouses, often utilizing SSIS as a tool. While both roles require SQL and ETL knowledge, the architect emphasizes design and strategy, whereas the developer concentrates on implementation and development tasks.

What are some common challenges faced by SSIS Architects when designing large-scale data integration solutions?

SSIS Architects often encounter challenges such as optimizing ETL performance, managing complex data transformations, and ensuring data quality across diverse sources. They must also design scalable and maintainable SSIS packages while adhering to organizational security and compliance standards. Collaborating closely with database administrators, developers, and business analysts is crucial to address evolving requirements and troubleshoot issues that arise during development or deployment.

Does SSIS need coding?

SSIS (SQL Server Integration Services) architects typically use a combination of graphical tools and scripting to develop data integration workflows. Basic package development often requires minimal coding, but advanced tasks may involve scripting in languages like C# or VB.NET. Strong knowledge of SQL and scripting enhances the ability to customize and troubleshoot SSIS packages effectively.
More about Ssis Architect jobs

Full-time

Posted 3 days ago


Job description

Role: Senior SSIS Developer
Location: Tulsa, Oklahoma (3 Days onsite/week)
Long Term contract
Role Description:
  • We are seeking a highly skilled Senior SSIS Developer who is a hands-on expert. The ideal candidate will have deep experience designing, developing, optimizing, and troubleshooting complex SSIS packages and data integration solutions.
  • This role requires expertise in working with advanced ETL patterns, third-party SSIS components (ZappySys), APIs (REST/SOAP), XML processing, and data integrity techniques such as checksums.

Key Responsibilities
Technical Development:
  • Design, develop, and maintain complex SSIS packages for enterprise-scale data integration.
  • Build robust ETL pipelines handling high-volume and diverse data sources.

Implement and manage:
  • Data transformations:
  • Incremental loads (CDC, SCDs, delta logic)
  • Error handling and logging frameworks

Integrate external systems via:
  • REST/SOAP APIs
  • ZappySys connectors
  • XML / JSON data ingestion and parsing
  • Advanced Data Integration

Develop solutions using:
  • XML parsing (XPath, XQuery)
  • JSON transformations
  • Checksum/hash-based data validation and deduplication
  • Work with heterogeneous data sources including:
  • SQL Server, Oracle, flat files, APIs, cloud data sources
  • Optimize package performance for large datasets and complex transformations
  • Debugging & Optimization
  • Troubleshoot and resolve:
  • Package failures
  • Performance bottlenecks
  • Data quality issues
  • Conduct deep debugging of SSIS workflows, scripts, and data flows
  • Implement performance tuning techniques (parallelism, buffering, indexing, query optimization)