Experienced Data & Risk Analytics Consultant

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

Benefits offered by this job

Hybrid work (potential)

Career growth opportunities

Global exposure

Job summary

KCIC, a consulting and technology firm specializing in risk management, litigation support, insurance analytics, and data-driven solutions, seeks a data-savvy consultant for Washington, DC. You will analyze large datasets with SQL, Excel, Power BI, validate data, and collaborate with clients, analysts, and software developers to document requirements and support KCIC’s Ligado platform.

This onsite role requires a bachelor’s degree in a technical field, 2–3 years’ experience, and the ability to

Qualifications

• Bachelor’s degree in an analytical or technical field such as business, data science, finance, economics, or systems engineering.
• 2–3 years of post‑graduation career experience.
• Proficient knowledge of relational databases; proficient in Microsoft 365 suite (Word, Excel, PowerPoint, Outlook), with a deep understanding of leveraging Excel for complex data analysis, reporting, and automation. Familiarity with additional tools such as Power BI, VBA.

Responsibilities

• Partner with clients to solve complex litigation, claims, insurance, and business challenges through data analysis and thoughtful recommendations.
• Analyze and interpret large, complex datasets using SQL, Excel, Power BI, and other tools to support reporting, forecasting, financial analyses, and client decision-making.
• Review, validate, and investigate data from claims, insurance policies, payments, and related sources, identifying discrepancies and ensuring the accuracy and quality of client deliverables.
• Collaborate with clients, analysts, and software developers to understand business needs, document requirements, test new functionality, and support the rollout of enhancements to KCIC’s technology platforms, including Ligado.
• Support ongoing improvements to Ligado by participating in user acceptance testing, gathering user feedback, troubleshooting issues, maintaining documentation, and helping clients effectively use the platform.
• Develop expertise in clients’ businesses, litigation and claims management processes, insurance coverage structures, and KCIC’s consulting and technology offerings.
• Prepare and communicate analyses, reports, and recommendations to clients and colleagues, clearly explaining methodologies, findings, risks, and proposed next steps.
• Manage multiple priorities across client projects, demonstrating strong organization, attention to detail, sound judgment, and accountability for meeting deadlines and client expectations.
• Review work for accuracy and completeness, identify opportunities for improvement, and contribute to solving complex client problems.
• Support the development of junior team members through training, knowledge sharing, and day-to-day collaboration.
• Contribute to the growth of the firm through recruiting, training, thought leadership, and other internal initiatives.

Skills

Analytical thinking

Data analysis

Power BI

SQL

Excel

VBA

Database knowledge

Communication

Education

Bachelor’s degree in analytical/technical field

Tools

Power BI

SQL

Excel

VBA

Job description

KCIC, a consulting and technology firm specializing in risk management, litigation support, insurance analytics, and data-driven solutions, seeks a data-savvy consultant for Washington, DC. You will analyze large datasets with SQL, Excel, Power BI, validate data, and collaborate with clients, analysts, and software developers to document requirements and support KCIC’s Ligado platform.

This onsite role requires a bachelor’s degree in a technical field, 2–3 years’ experience, and the ability to