1

Ssis Architect Jobs (NOW HIRING)

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

T-SQL with SSIS * Strong hands-on experience in T-SQL and SSIS, with the ability to develop, maintain, and support ETL and data integration processes. * Analyze, troubleshoot, and resolve data ...

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

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

RIT Solutions, Inc. is a forward-thinking healthcare analytics firm seeking an SSIS SQL Engineer to join their dynamic remote team. The role involves designing and developing high-quality software ...

NET, SQL Server, and SSIS, with the ability to work independently in a collaborative enterprise environment. This role is best suited for someone who can contribute quickly, partner with technical ...

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

Javen Technologies, Inc. is seeking a Lead ETL Developer with extensive experience in SSIS. The role involves leading teams, managing projects, and modernizing SSIS platforms while ensuring automated ...

Showing results 21-40

Ssis Architect information

See salary details

$47

$67

$99

How much do ssis architect jobs pay per hour?

As of Aug 22, 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 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?

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

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.

More about Ssis Architect jobs
Infographic showing various Ssis Architect job openings in the United States as of August 2026, with employment types broken down into 92% Full Time, 1% Part Time, and 7% Contract. Highlights an 77% Physical, 8% Hybrid, and 15% Remote job distribution, with an average salary of $141,166 per year, or $67.9 per hour.

SSIS Developer/Architect Sr(36598)

IDEALFORCE LLC

Phoenix, AZ • On-site

Contractor

Re-posted 10 days ago


Job description

Company Description

IDEALFORCE has a Contract position available immediately for a SSIS Developer/Architect Sr to join our customer in Phoenix Arizona. This is an ONSITE position. Please find below additional details about this job. Kindly respond with your most up to date resume if you would like to pursue this opportunity. Only AZ candidates are considered for this role.

Job Description

Develops advanced BI applications using the MS BI stack including SSAS, SSIS, T-SQL/stored procedures

Analyzes and improves existing dashboards, reports and reporting systems

Analyzes and perform integrity checks data coming in from 3rd parties in flat file and other formats

Responsible for importing data from various sources and providing summary reports regarding data integrity, completeness, etc.

Works closely with the Enterprise and Solutions Architects team and provides technical design recommendations on the data mart structures which support analytical applications

Provides and owns the technical details for implementation and maturing of BI solutions

Works with business users and other stakeholders to understand business processes, and translates them into functional and non-functional specifications for BI solutions

Identifies problem trends and corrective actions and documenting these through modification of existing best practices guidelines

Provides expertise and guidance to other developers in the use of the toolset

Qualifications

Develops advanced BI applications using the MS BI stack including SSAS, SSIS, T-SQL/stored procedures

Analyzes and improves existing dashboards, reports and reporting systems

Analyzes and perform integrity checks data coming in from 3rd parties in flat file and other formats

Responsible for importing data from various sources and providing summary reports regarding data integrity, completeness, etc.

Works closely with the Enterprise and Solutions Architects team and provides technical design recommendations on the data mart structures which support analytical applications

Provides and owns the technical details for implementation and maturing of BI solutions

Works with business users and other stakeholders to understand business processes, and translates them into functional and non-functional specifications for BI solutions

Identifies problem trends and corrective actions and documenting these through modification of existing best practices guidelines

Provides expertise and guidance to other developers in the use of the toolset



Requirements

BS Degree CS or MIS or equivalent experience in related roles

8+ years of experience delivering solutions utilizing the entire Microsoft BI stack (SSIS, SSRS, etc.)

8+ years of experience with SQL Server/T-SQL programming in creation and optimization of stored procedures, triggers and user defined functions

8+ years of Microsoft SQL Server database development (TSQL) experience

Must be able to build Business Intelligence solutions in a collaborative, agile development environment

Knowledge of current Microsoft .NET technologies including C#, VB.NET, ASP.Net, and SharePoint desired

Working knowledge of Team Foundation Services 2012

Working knowledge of Share Point 2010 and Performance Point

Demonstrated ability to use discretion and make sound decisions

Ability to excel in a collaborative and distributed team environment

Ability to work with a minimal amount of direction while being pro-active in keeping their management informed of project related issues

Ability to work under pressure

Ability to respectfully question ideas and share a point of view with others in support of the business requirements and needs

Ability to effectively communicate with various levels of employees ranging from entry level to senior leadership

Ability to manage multiple projects at the same time and shift priorities quickly

Experience working on an Agile/Scrum team preferred

Proven strong problem-solving skills, troubleshooting, and root cause analysis

Excellent written and verbal communication skills

Additional Information

- "All your information will be kept confidential according to EEO guidelines". - All candidates who are authorized to work in US are encouraged to apply. - Candidates must clear the Background check prior to commencing the assignment. 


THIRD PARTY CANDIDATES:

Email your candidate/s resume to pete dot tylor at idealforce.com along with the following details: Rate, Current location and Availability.


Disclaimer :

 The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.



Idealforce logo

About Idealforce

Sourced by ZipRecruiter

Idealforce is a reputable company headquartered in Austin, TX, United States, that operates within the dynamic technology industry. As indicated by the information derived from its official website, idealforce.com, the company's specialization lies in providing innovative technology solutions and digital services for various business operations. Founded on the principles of excellence, efficiency, and progressive technology, Idealforce has significantly contributed toward shifting the business landscape to a more digital realm.

Industry

It services

Company size

11 - 50 Employees

Headquarters location

Austin, TX, US

Year founded

2008

Social media