Master Data & Quality Analyst

Colonial Group; Pennsauken Township (NJ); On-site; USD 28,000 - 30,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

401K with employer match

Sick leave

Vacation time

Company paid holidays

Job summary

Colonial Group is seeking a detail-oriented Data Maintenance Analyst to join our team in New Jersey. The role focuses on maintaining, validating, and updating critical business data across systems to ensure accuracy and integrity.

The ideal candidate will have a data management background and experience with enterprise systems. You will work with IT, Finance, Sales, and Operations to gather accurate data, develop dashboards, and perform data audits.

Qualifications

• Bachelor’s degree in information systems, business administration, data management, or a related field.
• Strong analytical and problem-solving skills with high attention to detail.
• Proficiency in Microsoft Excel and basic understanding of SQL.
• Experience using or supporting Power BI, Tableau, and enterprise data systems.
• Excellent communication skills and the ability to work collaboratively across teams.

Responsibilities

• Maintain and update master data records across business systems including D365, Arete, and VIP (e.g., customer, vendor, product, pricing data).
• Perform regular data audits to identify inconsistencies, duplicates, and errors.
• Cleansing, validating, and standardizing data in line with business rules and internal policies.
• Work closely with cross-functional teams (IT, Finance, Sales, Operations) to gather accurate data and support end-to-end data processes.
• Develop and maintain data quality dashboards and reports using Power BI and Tableau.
• Write and execute queries using SQL to support data validation and reporting tasks.
• Support implementation and enhancement of data management tools and processes.
• Document procedures, maintain data dictionaries, and contribute to training and onboarding related to data systems.
• Troubleshoot and resolve data-related issues in a timely and effective manner.

Skills

Analytical thinking

Problem solving

Excel proficiency

SQL basics

Power BI

Tableau

Cross-team collaboration

Education

Bachelor’s degree in information systems, business administration, data management, or related field

Tools

D365 (Dynamics 365)

Arete

VIP system

SQL Server

Job description

Colonial Group is seeking a detail-oriented Data Maintenance Analyst to join our team in New Jersey. The role focuses on maintaining, validating, and updating critical business data across systems to ensure accuracy and integrity.

The ideal candidate will have a data management background and experience with enterprise systems. You will work with IT, Finance, Sales, and Operations to gather accurate data, develop dashboards, and perform data audits.