Data Analyst Job at World Insurance Associates in Woodbridge Township

Data Analyst - World Insurance Associates

Join to apply for the Data Analyst role at World Insurance Associates.

Summary

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.

Position Overview

This position’s primary responsibility will be to provide technical expertise, coordinate day-to-day deliverables for the data analysis & data governance team and interpret and analyze large datasets. The candidate should be well versed in the fields of analytics, testing, programming, and development; able to research technologies independently to recommend appropriate solutions and should contribute to technology-specific best practices and standards; contribute to success criteria from design through deployment; contribute expertise on significant application components, program languages, databases, operating systems, testing phases etc.

Key Responsibilities

• 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; develop and implement data quality standards and work with a team to integrate and automate data pipelines
• 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
• Collaborate effectively with limited supervision, demonstrate enthusiasm for teamwork, continuous learning, and a self-motivated approach
• Advanced Excel expertise (pivot tables, VLOOKUPS, Power Pivot, functions, etc.)
• Understand importance of code review and automated testing; write and implement tests as required
• Bachelor’s degree or foreign equivalent from an accredited institution

Preferred Qualifications

• Experience in design, development, and deployment of BI solutions using Power BI (DAX, RLS), Python, PySpark, Google BigQuery
• Knowledge or experience with Microsoft PowerApps, Power Automate, and/or Common Data Service (Power Platform)
• Data Governance, Data Quality, Master Data Management knowledge
• 3-5+ years of proven experience as a data analyst
• 3-5+ years of T-SQL language/query experience with data manipulation (SQL) including stored procedures and functions
• Knowledge of data models, relational and dimensional data modelling, data profiling, and working with large data environments
• Strong communication, team collaboration, and advanced analytical skills to investigate data issues and drive appropriate actions with data operations and business processes

Position Summary

This position is located in New Jersey. The base salary for this position at the time of this posting may range from $80,000 to $90,000. Individual compensation varies based on job-related factors, including business needs, experience, level of responsibility, and qualifications. We offer a competitive benefits package and variable pay programs. Please visit https://www.worldinsurance.com/careers for more details.

Equal Employment Opportunity

At World Insurance Associates (WIA), we celebrate and support our differences. WIA is an equal opportunity workplace and provides equal employment opportunities regardless of race, color, ancestry, religion, sex, national origin, age, citizenship, marital status, disability, gender identity, sexual orientation, or veteran status. We also provide reasonable accommodations to qualified applicants or employees with disabilities, unless such accommodation would impose an undue hardship on the operation of our business.

Referrals increase your chances of interviewing at World Insurance Associates by 2x.