Remote Excel Data Analyst Jobs in Illinois (NOW HIRING)

IAT Insurance Group has an immediate opening for a Business Analyst from our Milwaukee, Wisconsin or Naperville, Illinois locations. This position works closely with Business Solutions Leads, Architects, and other key IT resources to drive the planning and definition of new technology solutions and enhancements to existing solutions.

This role works a hybrid schedule that requires working from the office Monday through Wednesday, with the option of working Thursday and Friday remotely.

While we prefer candidates to work from one of our IAT office locations, we are open to considering fully remote arrangements for the ideal candidate.

Responsibilities:

• Elicit, analyze, and document business and data requirements from stakeholders across the insurance organization.
• Translate business needs into clear functional specifications, source-to-target mappings, and user stories for data and reporting solutions.
• Profile, validate, and analyze data by writing SQL queries against source systems and the Insights warehouse.
• Interpret Duck Creek policy XML data structures and map these to Insights staging tables and columns.
• Partner with developers and data engineers to ensure delivered solutions meet documented requirements.
• Facilitate stakeholder meetings, present findings, and produce documentation tailored to technical and non-technical audiences.
• Support data quality, governance, and reporting initiatives within the Data Management organization.
• Assist support team in analysis of data issues.
• Perform other duties as needed.

Qualifications:

Must Have:

• Bachelor's degree in Computer Science, Information Systems, or similar technology-related field with 2+ years of related experience
• In lieu of a bachelor's degree and 2 years of experience, we will consider a candidate with 7+ years of related experience
• Demonstrated experience as a Business Analyst, with proven requirements-gathering and process-analysis skills.
• Hands-on knowledge of the Duck Creek Policy platform.
• Knowledgeable in Extract Mapper tool from Duck Creek.
• Working knowledge of the Duck Creek Insights data warehouse.
• Significant experience in the P&C insurance industry.
• Proficiency in writing SQL queries for data analysis and validation.
• Excellent oral and written communication skills.
• 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:

• P & C Insurance experience
• Familiarity with bureau / statistical reporting and insurance regulatory data.
• Exposure to Agile delivery and tools such as Azure DevOps or Jira.
• Bachelor's degree in business, Information Systems, or a related field, or equivalent experience.

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, that the annual gross salary range associated with this posting is $55,200 - $120,330. Actual salaries 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

IAT Insurance Group 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:

• 26 PTO Days (Entry Level) + 12 Company Holidays = 38 Paid Days Off
• 7% 401(k) Company Match and additional Profit Sharing
• Hybrid work environment
• Numerous training and development opportunities to assist you in furthering your career
• Healthcare and Wellness Programs
• Opportunity to earn performance-based bonuses
• 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.