IAT Insurance Group Logo

IAT Insurance Group

Business Data Analyst

Posted Yesterday
In-Office
Naperville, IL, USA
55K-120K Annually
Junior
In-Office
Naperville, IL, USA
55K-120K Annually
Junior
Gather and document business and data requirements, translate needs into functional specs and source-to-target mappings, write SQL to profile and validate data, interpret Duck Creek policy XML and map to Insights tables, collaborate with developers/data engineers, support data quality/governance and reporting, facilitate stakeholder meetings, and assist support teams with data issue analysis.
The summary above was generated by AI

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.

IAT Insurance Group Naperville, Illinois, USA Office

Naperville, United States

IAT Insurance Group Rolling Meadows, Illinois, USA Office

Rolling Meadows, United States

Similar Jobs

8 Days Ago
Remote or Hybrid
United States
90K-140K Annually
Senior level
90K-140K Annually
Senior level
Information Technology • Database • Consulting
Perform end-to-end data analysis and transformation for large-scale P&C insurance datasets. Develop source-to-target mappings, validate and profile data, optimize complex SQL queries, and collaborate with business SMEs and technical teams to ensure data quality, standardization, and accurate technical documentation.
Top Skills: Data MappingData ProfilingData TransformationETLQuery OptimizationSource-To-Target Mapping (Sttm)SQL
19 Days Ago
Easy Apply
Remote or Hybrid
US
Easy Apply
106K-125K Annually
Senior level
106K-125K Annually
Senior level
AdTech • Enterprise Web • Information Technology • Machine Learning • Marketing Tech • Sales
The Senior Data Analyst oversees performance reporting tools, automates data pipelines, conducts quantitative analyses, and communicates findings to various stakeholders.
Top Skills: Google BigqueryGoogle SuiteMS OfficePythonSQL
13 Hours Ago
Remote or Hybrid
United States
Senior level
Senior level
Security • Cybersecurity
The Senior Manager of Enterprise Business Systems oversees the strategy, implementation, and optimization of enterprise applications, leading a team for full lifecycle management, ensuring system delivery, and fostering cross-functional collaboration.
Top Skills: APIsBoomiETLJIRAN8NNetSuiteSalesforceSalesforce CpqWorkato

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account