Data Analyst

About Advantage

For the past 28 years, Advantage Investigations has been the Nation's only insurance defense investigation firm that invests in the operational capabilities necessary to produce consistent, high-quality results—ultimately helping our clients "See What's True."

With over 200+ licensed private investigators Nationwide, Advantage uses strategic planning and technology to give our clients greater clarity on a claimant's daily activities. Providing Covert Surveillance, Claims Investigations, Net-Sweep Investigations, Remote Controlled Surveillance, and more, we're able to save our clients time and money on insurance fraud cases.

The role

Advantage Investigations is seeking a Full Time Data Analyst to work remotely from anywhere in the United States. The qualified candidate will be responsible for turning our case, client, and financial data into the reporting our operations leaders, executives, and clients rely on. This position reports to the Director of Data & AI.

Duties & Responsibilities

• Building and maintaining operational and executive reporting in Power BI, including case volume, KPIs, investigator utilization, margin by line of business, and service quality
• Producing monthly, quarterly, and annually reporting packages for clients
• Completing ad-hoc analysis requests from operations, sales, and leadership
• Writing SQL queries against our data platform to answer business questions and investigate discrepancies
• Maintaining recurring Excel reporting and updating weekly reporting deliverables
• Building lightweight process automations
• Shadowing operations, case management, and finance to understand how work gets done and where reporting or automation removes manual effort
• Documenting metric definitions and report logic

Qualifications & Requirements

• 2+ years in a data analyst or business analyst role
• Strong SQL, including joins, window functions, and CTEs
• Power BI report development experience, including working DAX
• Advanced Excel
• Demonstrated ability to work directly with non-technical stakeholders and translate business questions into analysis
• Python or R experience preferred
• Masters in Computer Science or related field preferred
• Experience producing client-facing or externally published reporting preferred
• Self-motivated, ability to work independently and manage shifting priorities
• Good oral and written communication skills
• Reliable high-speed internet and a suitable remote work environment

Compensation

This position is salaried and exempt, at an annual rate commensurate with experience, within $65,000 to $90,000.

Company Benefits

• Fully remote - work from anywhere in the United States
• Monthly Cell Phone Allowance
• Equipment Provided
• Medical, Dental, Vision, and Disability insurance
• Life Insurance and other supplemental options
• 401(k) - with match
• Parental Leave
• Professional development and certification support