IAT Insurance Group
Data Integration Solution Architect
IAT Insurance Group, Raleigh, North Carolina, United States, 27601
Join to apply for the
Data Integration Solution Architect
role at
IAT Insurance Group 1 week ago Be among the first 25 applicants Join to apply for the
Data Integration Solution Architect
role at
IAT Insurance Group Get AI-powered advice on this job and more exclusive features. IAT Insurance Group is seeking a Data Integration Solution Architect to join our Data Management team. This role is responsible for designing and delivering robust data integration solutions that support business operations and strategic initiatives. Please note, IAT works on a hybrid schedule, working from the office Monday through Wednesday with the option of working remotely Thursday and Friday.
The ideal candidate will have a deep understanding of data structures, business processes, and integration technologies, and will collaborate closely with business and IT stakeholders to deliver high-quality, scalable solutions. The position will be in one of our following offices:
Naperville, IL Rolling Meadows, IL Raleigh, NC Milwaukee, WI
Responsibilities:
Analyze and understand data solution requirements and source systems. Develop deep knowledge of data structures, business processes, and data semantics. Design end-to-end data integration solutions, including architecture blueprints, data models, mappings, and specifications. Lead the development of ETL solutions using SQL and SSIS on the SQL Server platform. Collaborate with business leaders, IT teams, SMEs, and process owners to ensure alignment and quality. Provide technical guidance and mentorship to ETL developers and data engineers. Contribute to the definition and enforcement of data integration standards, best practices, and methodologies. Evaluate solution options and recommend optimal approaches based on business needs and technical feasibility. Support solution deployment, documentation, and ongoing operations. Participate in change management and version control processes.
Qualifications:
Must Have:
Bachelor’s degree in Computer Science, Information Systems, or a related field Minimum 7 years of experience in data engineering, data modeling, and data integration design; or equivalent Equivalent is defined as 11 years of relative experience Strong proficiency in SQL and SSIS for SQL Server Solid understanding of data integration methodologies and best practices Experience with data modeling tools and techniques Familiarity with version control, deployment automation, and data operations
Preferred To Have
Knowledge of insurance industry data models, especially in the Property & Casualty domain. Experience with cloud-based data platforms and modern data architectures is a plus.
Our Culture:
IAT is the largest private, family-owned property and casualty insurer in the U.S.
I nsurance
A nswers
T ogether
is how we define IAT, in letter and in spirit. We work together to provide solutions for people and businesses. We collaborate internally and with our partners to provide the best possible insurance and surety options for our customers.
At IAT, we’re committed to driving and building an open and supportive culture for all. Our employees propel IAT forward – driving innovation, stable partnerships and growth. That’s why we continue to build an engaging workplace culture to attract and retain the best talent.
We offer comprehensive benefits like:
Flexible start time and lunch options Hybrid work environment (In office Monday-Wednesday with the option to work remotely Thursday and Friday.) Dress for Your Day Policy 26 PTO Days (Entry Level) + 12 Company Paid Holidays = 38 Paid Days off 7% 401(k) Company Match and additional Profit Sharing Paid parental leave Personalized 1:1 training Limited team size enhancing collaboration and leadership support Variety of training programs and development opportunities Healthcare and Wellness Programs Opportunity to earn performance-based bonuses College Loan Assistance Support Plan Educational Assistance Program Mentorship Program
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. We maintain a drug-free workplace and participate in E-Verify.
Compensation:
Please note, if you live in Illinois, the typical salary range for this role will be $106,400 to $168,100. This range represents the anticipated low and high end of the salary for this position in that location. Actual salary will vary based on factors such as a candidate’s qualifications, skills, competencies, and geographical location related to this specific role. The total compensation will include a base salary, performance-based bonus opportunities, 401(K) match, profit-sharing opportunities, and more.
To view details of our full benefits, please visit https://www.iatinsurancegroup.com/careers/benefits. Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Engineering and Information Technology Industries Insurance Referrals increase your chances of interviewing at IAT Insurance Group by 2x Get notified about new Solutions Architect jobs in
Raleigh, NC . Solutions Architect - eDiscovery & Archiving Technology - Vice President
Cary, NC $125,000.00-$185,000.00 1 week ago Director of Enterprise Architecture - Hybrid or Remote Opportunity
Cary, NC $160,000.00-$209,000.00 1 week ago AI Development Manager and Solution Architect
MO-3-12-AWS Cloud Architect and Advisory (759545)
Raleigh, NC $144,200.00-$288,400.00 4 days ago AVP and Chief Architect of Corporate Systems
Cary, NC $170,000.00-$215,000.00 2 weeks ago VP, Engineering and Applications - Hybrid or Remote Opportunity
Raleigh, NC $225,000.00-$278,250.00 5 days ago Senior Manager, Partner Solution Architects
Cary, NC $72,000.00-$147,100.00 2 weeks ago Field Solutions Architect, GenAI, Google Cloud, HCLS
Raleigh, NC $177,000.00-$263,000.00 4 days ago Sr. Principal IT Enterprise Architect - R&D/Engineering
Raleigh, NC $158,249.97-$232,099.95 4 days ago VP, Engineering and Applications - Hybrid or Remote Opportunity
Cary, NC $225,000.00-$278,250.00 1 week ago Technical Architect - Health & Life Sciences
AWS Solutions Architect 3 month long - Remote - USA
Pre-Sales Sr. Solutions Architect - Washington DC, Raleigh Durham
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Data Integration Solution Architect
role at
IAT Insurance Group 1 week ago Be among the first 25 applicants Join to apply for the
Data Integration Solution Architect
role at
IAT Insurance Group Get AI-powered advice on this job and more exclusive features. IAT Insurance Group is seeking a Data Integration Solution Architect to join our Data Management team. This role is responsible for designing and delivering robust data integration solutions that support business operations and strategic initiatives. Please note, IAT works on a hybrid schedule, working from the office Monday through Wednesday with the option of working remotely Thursday and Friday.
The ideal candidate will have a deep understanding of data structures, business processes, and integration technologies, and will collaborate closely with business and IT stakeholders to deliver high-quality, scalable solutions. The position will be in one of our following offices:
Naperville, IL Rolling Meadows, IL Raleigh, NC Milwaukee, WI
Responsibilities:
Analyze and understand data solution requirements and source systems. Develop deep knowledge of data structures, business processes, and data semantics. Design end-to-end data integration solutions, including architecture blueprints, data models, mappings, and specifications. Lead the development of ETL solutions using SQL and SSIS on the SQL Server platform. Collaborate with business leaders, IT teams, SMEs, and process owners to ensure alignment and quality. Provide technical guidance and mentorship to ETL developers and data engineers. Contribute to the definition and enforcement of data integration standards, best practices, and methodologies. Evaluate solution options and recommend optimal approaches based on business needs and technical feasibility. Support solution deployment, documentation, and ongoing operations. Participate in change management and version control processes.
Qualifications:
Must Have:
Bachelor’s degree in Computer Science, Information Systems, or a related field Minimum 7 years of experience in data engineering, data modeling, and data integration design; or equivalent Equivalent is defined as 11 years of relative experience Strong proficiency in SQL and SSIS for SQL Server Solid understanding of data integration methodologies and best practices Experience with data modeling tools and techniques Familiarity with version control, deployment automation, and data operations
Preferred To Have
Knowledge of insurance industry data models, especially in the Property & Casualty domain. Experience with cloud-based data platforms and modern data architectures is a plus.
Our Culture:
IAT is the largest private, family-owned property and casualty insurer in the U.S.
I nsurance
A nswers
T ogether
is how we define IAT, in letter and in spirit. We work together to provide solutions for people and businesses. We collaborate internally and with our partners to provide the best possible insurance and surety options for our customers.
At IAT, we’re committed to driving and building an open and supportive culture for all. Our employees propel IAT forward – driving innovation, stable partnerships and growth. That’s why we continue to build an engaging workplace culture to attract and retain the best talent.
We offer comprehensive benefits like:
Flexible start time and lunch options Hybrid work environment (In office Monday-Wednesday with the option to work remotely Thursday and Friday.) Dress for Your Day Policy 26 PTO Days (Entry Level) + 12 Company Paid Holidays = 38 Paid Days off 7% 401(k) Company Match and additional Profit Sharing Paid parental leave Personalized 1:1 training Limited team size enhancing collaboration and leadership support Variety of training programs and development opportunities Healthcare and Wellness Programs Opportunity to earn performance-based bonuses College Loan Assistance Support Plan Educational Assistance Program Mentorship Program
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. We maintain a drug-free workplace and participate in E-Verify.
Compensation:
Please note, if you live in Illinois, the typical salary range for this role will be $106,400 to $168,100. This range represents the anticipated low and high end of the salary for this position in that location. Actual salary will vary based on factors such as a candidate’s qualifications, skills, competencies, and geographical location related to this specific role. The total compensation will include a base salary, performance-based bonus opportunities, 401(K) match, profit-sharing opportunities, and more.
To view details of our full benefits, please visit https://www.iatinsurancegroup.com/careers/benefits. Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Engineering and Information Technology Industries Insurance Referrals increase your chances of interviewing at IAT Insurance Group by 2x Get notified about new Solutions Architect jobs in
Raleigh, NC . Solutions Architect - eDiscovery & Archiving Technology - Vice President
Cary, NC $125,000.00-$185,000.00 1 week ago Director of Enterprise Architecture - Hybrid or Remote Opportunity
Cary, NC $160,000.00-$209,000.00 1 week ago AI Development Manager and Solution Architect
MO-3-12-AWS Cloud Architect and Advisory (759545)
Raleigh, NC $144,200.00-$288,400.00 4 days ago AVP and Chief Architect of Corporate Systems
Cary, NC $170,000.00-$215,000.00 2 weeks ago VP, Engineering and Applications - Hybrid or Remote Opportunity
Raleigh, NC $225,000.00-$278,250.00 5 days ago Senior Manager, Partner Solution Architects
Cary, NC $72,000.00-$147,100.00 2 weeks ago Field Solutions Architect, GenAI, Google Cloud, HCLS
Raleigh, NC $177,000.00-$263,000.00 4 days ago Sr. Principal IT Enterprise Architect - R&D/Engineering
Raleigh, NC $158,249.97-$232,099.95 4 days ago VP, Engineering and Applications - Hybrid or Remote Opportunity
Cary, NC $225,000.00-$278,250.00 1 week ago Technical Architect - Health & Life Sciences
AWS Solutions Architect 3 month long - Remote - USA
Pre-Sales Sr. Solutions Architect - Washington DC, Raleigh Durham
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr