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 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 IAT Insurance Group
...Who We Are Vowd Weddings is a different kind of wedding brand, and that starts with our people. Our rapidly growing team is a diverse... ...Take ownership for your stores performance through strategic planning and thoughtful leadership Champion a service-oriented...
We are seeking an entry level Data Entry Specialist. We are looking for a candidate with strong Excel knowledge and ability to think outside the box. The ideal candidate would have at least one year of data entry experience and can commit to a long-term contract. ...
...Summary of Job Description:The Digital Marketing Coordinator supports national social campaigns, project management, and agency partnerships under the leadership of the Senior Digital Marketing Manager. This role assists with influencer activations, content development...
...Now Hiring No Experience Needed | Remote Customer Service Representative Entry Level Hiring Immediately Full Training Provided Globe Life AO is expanding fast and we're looking... ...service representatives who are ready to start immediately . Whether you're starting your...
...client, a leader in the manufacturing industry, is seeking an Overnight Production Associate to join their team. As an Overnight Production... ...lbs as required. What's Needed? Ability to work overnight shifts from Sunday through Thursday, 8 p.m. to 6 a.m. Strong...