DC Onsite Risk & Data Analytics Consultant

McLarens; Washington (District of Columbia); On-site; USD 95,000 - 130,000; Full time

Benefits offered by this job

Hybrid work

Global exposure

Career development

Inclusive culture

Job summary

KCIC is seeking an Experienced Consultant to help clients solve complex litigation, claims, and insurance challenges through advanced data analysis. The role involves working with SQL, Excel, and Power BI to deliver reports and forecasts, while ensuring data quality from multiple sources.

The position requires office presence in Washington, DC, with potential for future hybrid arrangements. You will collaborate with analysts, clients, and developers to implement enhancements and support client

Qualifications

• Bachelor's degree in analytical or technical field; Master's preferred.
• 2-3 years of post-graduation career experience.
• Willing to work in the office 5 days per week, with future hybrid options.
• Proficient in relational databases; strong Excel for data analysis, reporting, and automation; familiarity with Power BI and VBA.

Responsibilities

• Partner with clients to solve complex litigation, claims, insurance, and business challenges through data analysis and thoughtful recommendations.
• Analyze and interpret large datasets using SQL, Excel, Power BI to support reporting, forecasting, financial analyses, and client decisions.
• Review, validate, and investigate data from claims, insurance policies, payments, and related sources for accuracy and quality of deliverables.
• Collaborate with clients, analysts, and software developers to document requirements, test new functionality, and support Ligado platform enhancements.
• Support Ligado improvements via user acceptance testing, feedback, troubleshooting, and documentation.

Skills

SQL

Excel

Power BI

VBA

Data analysis

Communication

Team collaboration

Education

Bachelor's degree in analytics/technical field

Master's degree is a plus

Tools

Ligado

Microsoft 365

Job description

KCIC is seeking an Experienced Consultant to help clients solve complex litigation, claims, and insurance challenges through advanced data analysis. The role involves working with SQL, Excel, and Power BI to deliver reports and forecasts, while ensuring data quality from multiple sources.

The position requires office presence in Washington, DC, with potential for future hybrid arrangements. You will collaborate with analysts, clients, and developers to implement enhancements and support client