Data Analyst - REMOTE

AIS Insurance Specialists; United States; Remote; USD 77,000 - 142,000; Full time

Benefits offered by this job

Competitive compensation

Remote work across US

Paid time off and holidays

Bonus programs potential

Medical, dental, vision, life and pet

401(k) retirement with company match

Education assistance

Professional development opportunities

Wellbeing resources

Job summary

AIS Insurance Specialists is hiring a Data Analyst to provide data and reporting support remotely from home in the United States. The role focuses on identifying profitable opportunities, reducing premium leakage, and improving AIS processes through data analysis and reporting.

The position requires collaboration with the Data Analyst Team Lead and AIS management, with a strong emphasis on Excel, SQL, Power BI, and knowledge of Property & Casualty insurance lines.

Qualifications

• Proficient in data analysis and reporting with Excel, SQL and Power BI.
• Ability to build dashboards and visualizations for decision-making.
• Experience with data modeling and cross-functional collaboration.
• Knowledge of insurance processes, underwriting and premium analytics.
• Strong communication and time-management skills.

Responsibilities

• Provide data and reporting support to leadership and AIS management.
• Identify unprofitable risk segments and opportunities to reduce premium leakage.
• Develop dashboards and reports; monitor underwriting production and goals.
• Collaborate with AIS leaders to drive process improvements and data-driven decisions.
• Utilize tools such as Power BI, MicroStrategy, and EDW for data gathering.

Skills

Data Analysis

Excel

SQL

Power BI

Data Visualization

Data Modeling

Communication Skills

Project Management

Learning & Self-Development

Adaptability & Flexibility

Confidentiality & Compliance

Technical Knowledge Development

Underwriting & Analytical Skills

Industry Knowledge: P&C Insurance

Education

Bachelor's degree in Business Admin / Math / Stats

Statistics or Business Analytics coursework

Tools

MicroStrategy

Power BI

Winbroker II

Amazon Connect

Taske

Mercury EDW

UiPath

Power Automate

Job description

Overview:

Data Analyst -- REMOTE
Auto Insurance Specialists

Amazing Opportunity

Excellent corporate career opportunity! We are currently recruiting a dedicated, service-oriented professional who is interested in an analyst career. This position will be working remotely from home.

An in-person interview may be required during the hiring process

State specific pay scales for this role are as follows:

$98,568 to $120,473 (CA, NJ, NY, WA, HI, AK, MD, CT, RI, MA)
$88,712 to $108,425 (NV, OR, AZ, CO, WY, TX, ND, MN, MO, IL, WI, FL, GA, MI, OH, VA, PA, DE, VT, NH, ME)
$78,855 to $96,378 (UT, ID, MT, NM, SD, NE, KS, OK, IA, AR, LA, MS, AL, TN, KY, IN, SC, NC, WV)
The expected base salary for this position will vary depending on a number of factors, including relevant experience, skills and location.
In CA: Typical hiring range is $98,568 to $120,473

Job Summary

The Data Analyst will provide data and reporting support to the Data Analyst Team Lead, helping to drive data-informed business decisions. In this role, the team member will assist in identifying unprofitable risk segments and uncover opportunities to reduce premium leakage across all lines of business. The team member will also contribute to improving AIS processes and procedures by performing data analysis, creating reports, and supporting the monitoring of underwriting production and goals. This position is ideal for someone eager to develop their skills in data analytics while supporting a lead analyst and contributing to the organization's success.

Responsibilities:

ESSENTIAL JOB FUNCTIONS:

• Data Analysis & Reporting : Assist in generating on-demand reports as requested by the Data Analyst Team Lead and AIS management, creating standardized reporting templates, and ensuring data accuracy. Support the premium leakage initiative to increase profitability.
• Collaboration & Support: Work independently with AIS leaders to identify and provide data support for process improvements, system changes, and innovative ideas. Present analysis needs and work within a project plan that includes business objectives, data scope, research methodology, resources, and timelines.
• Reporting & Productivity Monitoring: Create, monitor, audit, and analyze recurring reports on CSR and Sales Agent productivity, system behavior, call handling, and AIS processes. Look for opportunities to improve efficiency and prepare reports, graphs, and charts based on analysis.
• Tools & Systems Usage: Coordinate and execute reporting, directing and supporting AIS users and leaders in identifying data needed for reporting. Use tools such as MicroStrategy, Power BI, Winbroker II, Amazon Connect, Taske, and Mercury's Enterprise Data Warehouse to gather and present data.
• General Support: Assist in developing and administrating current and future goals within AIS departments. Perform additional functions as the Data Analyst Team Lead assigns to support team and company objectives.

Qualifications:

• Data Analysis & Reporting : Proficient in performing data analysis and reporting using Excel , SQL , and Power BI. Ability to collaborate with cross-functional teams to identify and address operational challenges and assist in the development of new dashboards and visualizations.
• Excel Skills : Strong knowledge of VLOOKUP/XLOOKUP, pivot tables, charts, data sorting, and conditional formatting to analyze and present data effectively.
• Data Visualization : Experience using Power BI (or similar tools like Tableau) to create compelling visualizations and metrics. Familiarity with DAX for Power BI or VisQL for Tableau to build insightful and interactive dashboards.
• Data Modeling & SQL : Knowledge of SQL, including inner and outer joins, lag/lead functions, case statements, and basic data modeling/design. Ability to create complex queries and support data-driven decision-making.
• Robotic Process Automation : Basic experience with UiPath or Power Automate for automating repetitive tasks and improving data workflows.
• Industry Knowledge : General understanding of the Property & Casualty Insurance industry, including specific product lines such as Home , Auto , and Commercial.
• Underwriting & Analytical Skills: Strong analytical and quantitative skills with experience in underwriting practices, procedures, and data analysis related to premium and loss ratio analysis.
• Communication Skills: Excellent written and verbal communication skills, with the ability to present findings on underwriting data projects clearly and effectively to management and stakeholders.
• Project Management & Time Management: Capable of producing quality work within tight timeframes, managing multiple projects simultaneously, and working efficiently within a team setting.
• Learning & Self-Development: Must be a self-starter who can quickly learn new responsibilities, adapt to new technologies, and learn from peers or independently. Ability to stay up-to-date with new industry tools and techniques.
• Adaptability & Flexibility: Ability to work a flexible schedule and travel as needed, including occasional overnight or weekend stays.
• Confidentiality & Compliance: Ability to adhere to the company's privacy policies and ensure the secure handling of sensitive data.
• Technical Knowledge Development : Required to learn SQL , SAS , and potentially R coding if not already familiar, to further enhance data analysis capabilities.

Education/Experience

• Bachelor's degree; preferably in Business Administration, Mathematics, or Statistics
• Coursework in statistics or business analytics
• At least 3 years of insurance-related experience, preferably in an analytical role
• SAS and SQL training
• Or equivalent combination of education and experience

Physical Requirements:

Work-from-home requirements

• Designated workspace free from noise and other distractions.
• Remote office internet connection via Internet Service Provider (ISP) or Cable Modem.
• High-speed internet access required.

About the Company:

Why choose a career at AIS?
Auto Insurance Specialists has been offering quality insurance products to California residents for over 55 years and since 2006 has expanded its online sales and service capabilities across all 50 states. Our team will encourage you to grow, make time to have fun, and work together to make great things happen. We embrace the strengths and values of each team member. We believe in having diverse perspectives where everyone is included, to serve customers from all walks of life.

We care about our people, and we mean it. We reward our talented professionals with a competitive salary, and a variety of benefits to help our team members reach their health, retirement, and professional goals.

Learn more about us here: https://www.aisinsurance.com/jobs

AIS is an independently-operated and wholly-owned subsidiary of Mercury Casualty Company, a California corporation. We are an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by federal, state, or local law.

Perks and Benefits:

We offer many great benefits, including:

• Competitive compensation
• Flexibility to work from anywhere in the United States for most positions
• Paid time off (vacation time, sick time, 9 paid Company holidays, volunteer hours)
• Incentive bonus programs (potential for holiday bonus, referral bonus, and performance-based bonus)
• Medical, dental, vision, life, and pet insurance
• 401 (k) retirement savings plan with company match
• Engaging work environment
• Promotional opportunities
• Education assistance
• Professional and personal development opportunities
• Company recognition program
• Health and wellbeing resources, including free mental wellbeing therapy/coaching sessions, child and eldercare resources, and more

Pay Range: USD $76,829.00 - USD $142,213.00 /Yr.