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
...SAP Concur Invoice Consultant Location: Waukegan, IL or Remote position CARE ITS is a certified Woman-owned and operated minority company (certified as WMBE). At CARE ITS, we are the World Class IT Professionals, helping clients achieve their goals. Care ITS was...
...What youll need to succeed as a Local Account Executive at XPO Minimum qualifications: ~ Bachelors degree, 4 years of related work experience or equivalent military experience ~1 year of direct business-to-business selling experience supporting both local and...
...Our store employees are the face of the ALDI shopping experience. Their hard work makes it possible to uphold our company philosophy, providing quality products at the best possible price. Their smiles and pleasant demeanors keep customers coming back time and time again...
...podiatry, primary care, radiology, social work, urgent care, urology, and women's health. The clinic offers pre- and post-operative telemedicine surgical services, including general and vascular surgery, nephrology, and orthopedics. In addition, the clinic provides care to...
...s Pizza - from fresh out of the oven to the customer's door - our drivers make it happen. Money! Our delivery experts are paid cash daily from earned tips and mileage reimbursement. That is money in your pocket every night! In addition, they earn an hourly wage....