Data Integration Solution Architect

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. Insurance Answers Together® 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.