Experienced Consultant

RubixHR; Washington (District of Columbia); Hybrid; USD 70,000 - 110,000; Full time

Benefits offered by this job

Hybrid work arrangement

Professional development opportunities

Collaborative culture

Competitive compensation

Job summary

KCIC, a Washington, DC–based consulting and technology firm, is seeking a data analyst to transform claims, litigation, and insurance data into actionable insights. You will partner with clients, analyze large datasets, and deliver clear recommendations to support decision-making.

The role requires 2–3 years of experience, strong SQL/Excel/Power BI skills, and the ability to work both independently and within teams. Hybrid opportunities may develop over time.

Qualifications

• Bachelor’s degree in an analytical or technical field (e.g., business, data science, finance, economics, systems engineering).
• 2–3 years of post-graduation career experience.
• Proficient knowledge of relational databases; strong Excel, Power BI, and data analysis for reporting and automation.
• Ability to work independently and in a collaborative team environment.

Responsibilities

• Partner with clients to solve complex litigation, claims, insurance, and business challenges through data analysis and recommendations.
• Analyze large datasets using SQL, Excel, Power BI to support reporting, forecasting, and client decisions.
• Review and validate data from claims and payments, ensuring accuracy of client deliverables.
• Collaborate with clients, analysts, and developers to document requirements and support software rollouts, including Ligado.
• Participate in user acceptance testing, gather feedback, troubleshoot, and maintain documentation.
• Develop domain expertise in clients' business and KCIC's consulting and technology offerings.
• Prepare analyses and communicate findings, risks, and next steps to clients and colleagues.
• Balance multiple client projects with strong organization and accountability.

Skills

SQL

Excel

Power BI

VBA

Relational databases

Analytical thinking

Problem solving

Communication

Independent & collaborative

Time management

Education

Bachelor’s degree in analytics/technical field

Master’s degree (preferred)

Tools

Microsoft 365

Ligado (KCIC platform)

Job description

Select how often (in days) to receive an alert:

KCIC is a consulting and technology firm specializing in risk management, litigation support, insurance analytics, and data-driven business solutions. Since 2002, KCIC has helped organizations navigate complex legal, financial, and operational challenges through a combination of industry expertise, advanced analytics, and innovative technology.The company is recognized for its work in mass tort litigation, product liability, asbestos, talc, PFAS, and other emerging risk areas. By leveraging proprietary technology platforms and deep analytical capabilities, KCIC helps clients gain actionable insights, improve decision-making, and effectively manage risk.

Headquartered in Washington, D.C., KCIC brings together consultants, data scientists, technologists, and subject matter experts who are committed to solving complex problems and delivering meaningful results. The company's collaborative approach and focus on innovation have established it as a trusted partner across a range of industries.

Key Accountabilities

• Partner with clients to solve complex litigation, claims, insurance, and business challenges through data analysis, problem-solving, 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.

Experience and Qualifications

• Bachelor’s degree in an analytical or technical field such as business, data science, finance, economics, or systems engineering. Master’s degree is a plus.
• 2-3 years of post-graduation career experience
• Willing to work in the office 5 days per week, with future development into flexible, hybrid opportunities
• 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.
• Strong analytical and problem-solving abilities, as well as communication and interpersonal skills
• Ability to work independently and within a collaborative, team-based environment
• Intellectually curious, motivated, and eager to learn
• Exceptional organizational skills with the ability to balance competing priorities and effectively manage time to consistently meet deadlines.

Life at KCIC

Our people make KCIC the high-energy, high-performance, collaborative environment that it is. Those
who are new to the KCIC community bring innovative ideas, fresh perspectives, and the latest skills for
developing new technologies — all of which foster creative client solutions. We have developed an
environment where our employees feel confident to give voice to their ideas and are encouraged to take
ownership of their work. Our team is comprised of passionate individuals with diverse backgrounds,
including but not limited to business, systems engineering, data analytics, finance, and economics. At
KCIC, you will help solve some of the most complex problems and technical challenges that companies
face today.
KCIC is committed to creating a community where people can be their authentic selves. We embrace all
diversity, including race, ethnicity, gender identity, sexual orientation, and religion in our KCIC community
and in our clients. Each consultant at KCIC understands the value of diversity and inclusion and that
diverse ideas can lead to unique, powerful solutions for our clients.

The workplace
Since 1932, we’ve been who people turn to in tough times. That’s a huge responsibility. It’s also a
huge opportunity. McLarens is a premier independent loss adjusting and forensic technical services
firm, with a global network that delivers consistently excellent service supported by deep local
expertise.
Our work spans industries and the globe. From disaster relief to aviation, engineering to natural
resources, our people get everything they need to impact lives on a global scale. We take our
development seriously and offer careers that empower our people to strive for bigger goals and
reach new heights. And we’ve got the expertise to help them get there: our Loss Adjusters boast an
average of over 20 years' experience.
We’re building a culture where talent shines. Where ambition is everything. And people come first.
It's your career, so why compromise?

At McLarens, our commitments shape every experience- for our clients, our people, and the communities we serve.

What Drives Us:

• Purpose: Positively impacting people and communities across the globe.
• Progress: Excellence, expertise, and growth opportunities.
• Place: Our culture of empowerment, support and belonging.

Our people live by a shared set of values: Excellence, Teamwork, Respect, Knowledge, Thought Leadership, and Accountability. Together, they contribute to an inclusive culture that will help you thrive.

Here’s what else we offer:

Our Benefits:

• Compensation: Competitive salary and performance-related incentives.
• Development: Access to technical training, global knowledge-sharing, and career growth opportunities.
• Wellbeing & Flexibility: Support to balance professional and personal life (e.g., hybrid work, flexible schedule where applicable).
• Global Exposure: Opportunity to work with colleagues and clients across different countries.
• Inclusive Culture: A collaborative environment where your voice and contribution are valued.

Individual progress, global purpose. It’s all here at McLarens.

Our Company is an equal employment opportunity employer. The Company’s policy is not to discriminate against any applicant or employee based on race, color, sex, sexual orientation, gender identity, genetic information, religion, national origin, age, disability, veteran status, or any other basis protected by applicable federal, state, or local laws. The Company also prohibits harassment of applicants or employees based on any of these protected categories.