Data Analyst

Insurancecenterinc; Woodbridge Township (NJ); On-site; USD 80,000 - 90,000; Full time

Benefits offered by this job

Competitive benefits

Job summary

World Insurance Associates is seeking a data analyst to lead analysis of large datasets, build dashboards, and ensure data quality. You will work with Power BI, Tableau, Python, and SQL to derive insights for business decisions. Collaboration across teams, strong communication, and an eye for data governance are essential.

Located in New Jersey, the role emphasizes data cleansing, automated testing, and developing standards while collaborating with data operations and business processes.

Qualifications

• Bachelor’s degree or foreign equivalent from an accredited institution.
• 3-5+ years of proven experiences as a data analyst.
• 3-5+ years of T-SQL language/query experience with data manipulation.

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.

Skills

Advanced Excel

Power BI

Python

Pyspark

Google BigQuery

T-SQL / SQL

Data Visualization

Communication

Team Collaboration

Education

Bachelor’s degree

Tools

Tableau

Power Apps

Power Automate

Common Data Service

Job description

Description

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 & 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.

Equal Employment Opportunity

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.