IAT Insurance Group has an immediate opening for a Business Data Analyst with an insurance policy business background to join the Data Management Team. The ideal candidate will have at least two years of experience defining business needs/wants & translating those into measurable requirements that can be coded, tested, & successfully adopted, shaping data integration, reporting requirements, and data warehouses.

This role works a hybrid schedule out of an IAT office in Naperville, IL, Rolling Meadows, IL, or Raleigh, NC, to support IAT’s ability to make data-driven decisions. This role will be required to work from the office Monday through Wednesday with the option of working Thursday and Friday remotely. Occasional travel is required. This role is called a Data Analyst within IAT.

• Analyze data-related business and technical needs, elicit and document requirements related to data integration from source systems to target data warehouse, data marts, data analytic tools, and information delivery solutions.
• Develop hands-on experience with our systems to understand policy, claims and billing life cycles and information collected to operate our business.
• Develop a thorough understanding of our insurance business and business processes and how these are represented in our data within the systems and the data warehouse.
• Support release planning (blueprinting) efforts by identifying data pertinent scope and requirements driven by Policy, Claims, Billing workstreams on major and monthly releases.
• Gather data needs from business consumers: B.I./Analytics, Finance, Operations, etc.; and assesses the business “reasonableness” of the requests, as well as getting to the best requirement for the business.
• Identify and document data source for these data needs by digging into XML manuscripts, JSON data structures, relational table structures, talking with upstream B.A.s/architects.
• Perform other duties as assigned.

Qualifications:
Must Have:

• Bachelors’ degree and at least two years of relevant experience.
• Equivalent is defined as six years of relevant experience.
• Relevant experience as a business analyst for technical projects
• Experience and proficiency in creating SQL queries out of complex data models.
• Understanding of business intelligence/data warehousing technologies
• Excellent oral and written communication and presentation skills, capable of presenting complex issues in a clear, concise and persuasive manner to the business and technical professionals, including C-level executives
• Strategic mindset with an ability to plan and execute strategies
• Demonstrated initiative, self-starter, with strong analytical and problem-solving skills
• Strong work ethic and commitment to meeting deadlines
• To qualify, all applicants must be authorized to work in the United States and must not require, now or in the future, VISA sponsorship for employment purposes.

Preferred to Have:

• Advanced knowledge of TSQL, database schema design, reports, SQL performance tuning.
• Strong knowledge of related technologies (Data Analytics, Business Intelligence, Warehousing, Information Governance, etc.).
• Ability to troubleshoot difficult and undocumented issues with creative and well thought-out solutions, after gaining manager’s approval.

• Strong knowledge of insurance industry data models/modeling relevant to the property & casualty industry and ability to apply models to a newly developed data warehouse and related tools and processes

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. It’s about far more than being a workplace.

We’re a work family.

At IAT, our fundamental belief is to a create a culture where all employees are heard and have a sense of belonging. Inclusion and Diversity are not just initiatives, it’s how we live. We’re committed to driving and building an open and supportive culture. By embracing the uniqueness of our employees, investing in their development, listening to, and engaging their ideas, we are stronger as an organization.

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:

• 26 PTO Days (Entry Level) + 12 Company Holidays = 38 Paid Days Off
• Healthcare and Wellness Programs
• Opportunity to earn performance-based bonuses
• 7% 401(k) Company Match and additional Discretionary Retirement Contribution
• College Loan Assistance Support Plan
• Educational Assistance Program
• Mentorship Program
• Dress for Your Day Policy

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.

Come join the IAT family!

IAT Recruiter:
Steve Morley | Senior Recruiter
steve.morley@iatinsurance.com
www.linkedin.com/in/stevemorley916