DATA MAINTENANCE 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

Job Summary:

We are seeking a detail-oriented and analytical Data Maintenance Analyst to join our team. This role is responsible for maintaining, validating, and updating critical business data across systems to ensure accuracy, consistency, and integrity. The ideal candidate will have a strong background in data management, experience with enterprise systems, and a commitment to upholding high data quality standards.

Key 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.
• Cleanse, validate, and standardize 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.

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.

Preferred:

• 3+ years of experience in a data-focused role (data analysis, master data maintenance, or data quality management).
• Hands-on experience with Microsoft Dynamics 365 (D365), Arete, and VIP systems.
• Experience working with or supporting internal data quality and governance standards.

We offer a competitive hourly rate of $20 - $22 an hour.

Excellent benefits which include medical, dental and vision.

Eligibility in benefit plans begins the first of the month following 60 days of employment.

• Six (6) days of sick leave
• two (2) weeks of vacation accrued throughout the year
• nine (9) Company Paid Holidays
• a 401K Plan with employer match

EOE without regard to race, color, religion, creed, affectional or sexual orientation or sex, national origin, ancestry, age, disability, genetics, veteran status, gender, gender identity, citizenship status, marital status, VEVRAA Federal Contractor.

The statements herein are intended to describe the general nature and level of work being performed by employees and are not to be construed as an exhaustive list of responsibilities, duties, and skills required by personnel so classified. Furthermore, they do not establish a contract for employment and are subject to change at the discretion of the company.