IAT Insurance Group Logo

IAT Insurance Group

Business Data Analyst

Posted One Month Ago
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

19 Days Ago
Remote or Hybrid
US
130K-160K Annually
Senior level
130K-160K Annually
Senior level
Information Technology
Serves as an enterprise architecture subject matter expert within a DoD environment. Supports DoD Business Enterprise Architecture initiatives, business process alignment, enterprise strategy, stakeholder analysis, requirements documentation, reporting, and project activities using MEGA HOPEX and Microsoft Office tools.
Top Skills: Dod Business Enterprise Architecture (Bea)Mega HopexMicrosoft AccessExcelMS OfficeMicrosoft PowerpointMicrosoft ProjectMicrosoft Word
25 Days Ago
Easy Apply
Remote or Hybrid
US
Easy Apply
94K-110K Annually
Junior
94K-110K Annually
Junior
AdTech • Enterprise Web • Information Technology • Machine Learning • Marketing Tech • Sales
Develop business intelligence and revenue reporting tools, automate Finance reporting processes, perform ad hoc and quantitative analyses, and translate complex data into actionable insights. The analyst will support company initiatives, present findings to technical and non-technical stakeholders, and provide decision-making guidance across the organization.
Top Skills: Google BigqueryGoogle WorkspaceMS OfficePythonRelational Database SystemsSQL
11 Days Ago
In-Office
Internship
Internship
Manufacturing
Analyze consumer sales and order data to identify purchasing trends, product preferences, pricing impacts, and trade-up behavior across products, stores, markets, and time periods. Translate findings into actionable recommendations for product and business decisions while developing skills in data analysis, visualization, problem solving, and stakeholder communication.
Top Skills: MS Office

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