Systems Analyst - Data (Insurance Claims)

HCC Service Company, Inc.; Troy (MI); Hybrid; USD 70,000 - 110,000; Full time

Benefits offered by this job

Competitive salary and benefits

Hybrid schedule

Tuition assistance

Job summary

Tokio Marine HCC - Public Risk Group is seeking a Systems Analyst – Data (Insurance Claims) to design, build, and maintain data solutions powering underwriting, operations, reporting, and analytics. The role focuses on data pipelines, system integrations, and ensuring high-quality, reliable data for decision-making.

The ideal candidate has 1–3 years of relevant experience and a Bachelor’s degree, with the ability to work in Troy, MI on a hybrid schedule.

Qualifications

• Bachelor’s degree or equivalent experience in software/data fields.
• 1–3 years of progressive professional experience in software development and data support.
• Strong communication and collaboration skills across teams.

Responsibilities

• Assist engineers and stakeholders in understanding data requirements and integrations.
• Develop and maintain data pipelines, ETL processes, and data validation.
• Support Agile ceremonies and contribute to data quality initiatives.

Skills

Data analysis

Communication

Agile teamwork

Data quality

Education

Bachelor’s degree in Computer Science, Business or related field

Tools

MongoDB

Job description

Help us insure it Tokio Marine HCC - Public Risk Group, a member of the Tokio Marine group of companies, is a market leader in providing specialized insurance products for municipal entities. We cover counties, cities, townships, villages, police departments, prisons, fire departments and more. We serve the growing insurance and risk management needs of medium and large governmental entities and provide property and casualty insurance coverages in multiple states.

Role Overview

Systems Analyst – Data (Insurance Claims)

***The ideal candidate is legally authorized to work in the United States and resides within a reasonable commuting distance of Troy, Michigan, to support a hybrid schedule. ***

As a Systems Analyst for Public Risk Group, you will help design, build, and maintain the data solutions that power our underwriting, operations, reporting, and analytics platforms. Working alongside experienced engineers, you will develop data pipelines, integrate systems, and ensure that high-quality, reliable data is available to support business decision-making. You will collaborate closely with software engineers, product teams, and business stakeholders to understand data requirements and implement scalable technical solutions. As Public Risk Group continues its investment in cloud technologies and platform modernization, you will gain hands‑on experience with modern data practices while contributing to the development of enterprise data capabilities. This role offers an excellent opportunity to grow your technical skills through mentoring, challenging projects, and exposure to cloud‑native architectures, APIs, data integrations, and large‑scale insurance data.

Key Responsibilities

• Assist senior engineers and business stakeholders in understanding data requirements and supporting data integrations.
• Develop familiarity with insurance data, business processes, and systems through project work and mentoring.
• Participate in Agile ceremonies including daily standups, backlog refinement and sprint planning.
• Support the development, testing and maintenance of data pipelines, ETL processes and data integrations.
• Assist in troubleshooting data quality issues and identifying root causes of data discrepancies.
• Support data validation, reconciliation, and monitoring activities to ensure high quality data.

What You Bring

Bachelor’s degree in Computer Science, Business or a related field or the equivalent education and/or experience 1-3 years of relevant and progressive professional experience in software development and support.

Preferred Qualifications

• Insurance industry experience desired.
• Exposure to NoSQL databases such as Mongo is plus.
• Basic understanding of data modeling and data quality principles.
• Understanding of ETL concepts, API’s and data integrations.
• Excellent written and verbal communications skills.
• Exceptional organizational and analytical skills; demonstrated ability to manage multiple tasks simultaneously.
• Ability to learn new technologies and adapt to changing technical requirements.
• Intermediate proficiency and experience using Microsoft Office package (Excel, Access, PowerPoint, Word).

What We Offer

• Competitive salary and comprehensive benefit package
• Strong learning culture with ongoing development opportunities
• Opportunities for growth and career advancement
• Comprehensive medical, vision, and dental coverage, with eligibility beginning on your first day of employment
• Basic life and disability insurance
• 401(k) plan with 6% company match
• 20 days of PTO and two floating holidays (prorated)
• Approximately 11 paid holidays and volunteer time off
• Paid parental leave
• Access to our award-winning wellness program, including mental health services, fitness network membership, and a complimentary Headspace subscription
• Student loan matching program
• Employee discount program
• An opportunity to do meaningful work and love what you do

Disclaimer

You do not need to disclose your criminal history or participate in a background check until a conditional job offer is made to you. After making a conditional offer and running a background check, if the Company is concerned about a conviction that is directly related to the job, you will be given the chance to explain the circumstances surrounding the conviction or challenge the accuracy of the background report. The Company will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable federal, state and local laws, such as the Violent Crime Control and Law Enforcement Act of 1994 (18 USC § 1033(e))(the “VCCLEA”), which restricts financial institutions and insurers such as TMHCC from employing individuals with certain types of criminal convictions. Where the hiring and employment of individuals is not restricted by the foregoing, the Company will consider qualified applicants with arrest or conviction history in compliance with applicable law such as the California Fair Chance Act, the Los Angeles Fair Chance Initiative for Hiring Ordinance, the Los Angeles County Fair Chance Ordinance, the San Diego Fair Chance Ordinance, and the San Francisco Fair Chance Ordinance.

About Us

Tokio Marine HCC is a global industry-leading specialty insurance group, backed by the strength and stability of the Tokio Marine Group. Offering over 100 classes of specialty insurance, we empower clients to pursue opportunities confidently through our “Mind Over Risk” philosophy. More than an insurance company, we are an organization built on innovation, unity, and trust. At our core, we are Always Advancing, driven by innovation and an entrepreneurial spirit that keeps us moving forward. Our people are Experts in Tomorrow, using curiosity and smart working to anticipate what’s next. With a culture rooted in Reaching Out, we foster genuine collaboration and support, ensuring every individual has the opportunity to succeed and make a difference. Applying our Mind Over Risk philosophy to writing insurance allows our customers to take on opportunity with confidence. That philosophy defines our way of thinking, unites us as a team, and differentiates us from our competitors. We are much more than just an insurance company; we are a good company.

Equal Opportunity Employer TMHCC is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, ancestry, citizenship, color, family or medical care leave, gender identity, genetic information, marital status, medical condition, national origin, physical or mental disability, protected veteran or military status, race, ethnicity, religion, sex (including pregnancy), sexual orientation, or any other characteristic protected by applicable local laws, regulations and ordinances.

#LI-NL1 #LI-Hybrid

Your success is our priority. In a world that is rapidly changing, TMHCC enables you to take on opportunities with confidence. At Tokio Marine HCC, we pride ourselves on hiring the smartest, most conscientious people, who want to make a difference no matter their background. And then we give them the support and trust they need. We’re always looking for curious, creative transformative thinkers who want to change the status quo and have a passion for doing the right thing. If this is you, then we want you on our team.