Data Analyst

World Insurance Associates LLC; Woodbridge Township (NJ); On-site; USD 80,000 - 90,000; Full time

Job summary

World Insurance Associates LLC is seeking a data analyst in New Jersey to provide technical expertise, coordinate data analysis and governance, and interpret large datasets. You will analyze data, create dashboards using Power BI, and ensure data quality across the organization.

Requirements include a bachelor’s degree and 3–5+ years of BI/data experience with strong communication and collaboration skills. You will contribute to data pipelines, testing, and code reviews, while working in a

Qualifications

• Bachelor’s degree or foreign equivalent from an accredited institution.
• Experience designing, developing, and deploying BI solutions using PowerBI, Python, PySpark, Google BigQuery.
• Knowledge or experience implementing solutions 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) like stored procedures, functions.
• Knowledge of data models, data modelling (Relational and Dimensional), Data profiling and working with large data environments.
• Strong communication, team player and advanced analytical skills to analyze data issues and drive appropriate actions with data operations and business processes.

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, developing and implementing data quality standards and working 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.
• Self-motivated with ability to work effectively with limited supervision, enthusiasm for collaboration, continuous learning, and a team player.
• Advanced Excel expertise (pivot tables, VLOOKUPS, Power Pivot, functions, etc.)
• Understand importance of code review and automated testing and different levels at which these need to be performed and write and implement tests as required.

Education

Bachelor’s degree

Tools

Power BI

Python

PySpark

Google BigQuery

T-SQL

Power Apps/Power Automate

Job description

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 & should contribute to technology-specific best practices & 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, developing and implement data quality standards and working 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
• Self-motivated with ability to work effectively with limited supervision, enthusiasm for collaboration, continuous learning, and a team player.
• Advanced Excel expertise (pivot tables, VLOOKUPS, Power Pivot, functions, etc.)
• Understand importance of code review and automated testing and different levels at which these need to be performed and 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 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.
• 3-5+ years of proven experiences as a data analyst
• 3-5+ years of T-SQL language/query experience with data manipulation (SQL) like stored procedures, functions etc.
• Knowledge of data models, data modelling (Relational and Dimensional), Data profiling and working with large data environments.
• Strong communication, team player and advance analytical skills to analyze 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.

At World Insurance Associates (WIA), we celebrate and support our differences. We know employing a team rich in diverse thoughts, experiences, and opinions allows our employees, our products, and our community to flourish. WIA is honored to be an equal opportunity workplace. We are dedicated to equal employment opportunities regardless of race, color, ancestry, religion, sex, national orientation, age, citizenship, marital status, disability, gender identity, sexual orientation, or Veteran status. In addition, WIA makes reasonable accommodations to known physical or mental limitations of an otherwise qualified applicant or employee with a disability, unless the accommodation would impose an undue hardship on the operation of our business.