Note: The job is a remote job and is open to candidates in USA. AIS Management LLC/AIM is hiring a Data Analyst to support its Data Analyst Team Lead with reporting and data analysis. The role helps identify unprofitable risk segments, reduce premium leakage, monitor underwriting production and goals, and support process improvements through data-informed insights.
Responsibilities
- 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
Skills
- 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
- Strong knowledge of **VLOOKUP/XLOOKUP**, pivot tables, charts, data sorting, and conditional formatting to analyze and present data effectively
- Familiarity with DAX for Power BI or VisQL for Tableau to build insightful and interactive dashboards
- 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
- Basic experience with **UiPath** or **Power Automate** for automating repetitive tasks and improving data workflows
- General understanding of the **Property & Casualty Insurance** industry, including specific product lines such as **Home**, **Auto**, and **Commercial**
- Strong analytical and quantitative skills with experience in underwriting practices, procedures, and data analysis related to premium and loss ratio analysis
- Excellent written and verbal communication skills, with the ability to present findings on underwriting data projects clearly and effectively to management and stakeholders
- Capable of producing quality work within tight timeframes, managing multiple projects simultaneously, and working efficiently within a team setting
- 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
- Ability to adhere to the company's privacy policies and ensure the secure handling of sensitive data
- Bachelor's degree
- Coursework in statistics or business analytics
- At least 3 years of insurance-related experience
- SAS and SQL training
- Or equivalent combination of education and experience
- Experience using **Power BI** (or similar tools like **Tableau**) to create compelling visualizations and metrics
- Preferably in an analytical role
- Preferably in Business Administration, Mathematics, or Statistics
Benefits
- 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
Company Overview