Data Integration Solution Architect
Data Integration Solution Architect
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 106400 - 168100
1 Vacancy
Job Description
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
- 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.
- Bachelors 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
- 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.
At IAT were committed to driving and building an open and supportive culture for all. Our employees propel IAT forward driving innovation stable partnerships and growth. Thats 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.
To view details of our full benefits please visit
Employment Type
Full-Time
