Senior Data Analyst - Remote

Overview

World Insurance Associates is a unique insurance organization offering top products and services from major providers, combined with attentive service from local agents.

Founded in 2011, World is one of the fastest-growing insurance brokers in the U.S. with over 2,200 employees in over 260 offices across North America. We specialize in personal and commercial insurance lines, surety and bonding, employee benefits, financial and retirement services, and human capital management solutions.

Our rapid growth and market leading presence has created opportunities throughout the state and we offer top talent the choice to work from one of our multiple offices throughout the region.

In Short

• Conduct in-depth analysis of large datasets to identify trends, patterns, and anomalies
• Data cleansing and preparation, including cleaning and preprocessing raw data to ensure accuracy and reliability
• Create and maintain comprehensive dashboards and reports for key performance indicators
• Use visualization tools (e.g., Tableau, Power BI) to present complex data in an understandable format
• Provide training and guidance to junior analysts on data visualization best practices
• Self-motivated with ability to work effectively with limited supervision
• Advanced Excel expertise (pivot tables, VLOOKUPS, Power Pivot, functions, etc.)
• Understand importance of code review and automated testing
• Bachelor's degree or foreign equivalent from an accredited institution

Requirements

• Experience in design, development, and deployment of BI solutions using PowerBI (DAX, RLS), Python, Pyspark, Google Big query
• Knowledge or experience in implementing solutions with Microsoft PowerApps, Power Automate, and/or Common Data Service (Power Platform)
• Data Governance, Data Quality, Master Data Management knowledge
• 5+ years of proven experiences as a data analyst
• 5+ years of T-SQL language/query experience with data manipulation (SQL)
• Knowledge of data models, data modelling (Relational and Dimensional)
• Strong communication, team player and advance analytical skills

Benefits

• Equal Employment Opportunity workplace
• Support for diverse thoughts, experiences, and opinions
• Opportunities for continuous learning and collaboration