DATA MAINTENANCE ANALYST

Canada Dry Potomac Corp

Pennsauken Township (NJ)

On-site

USD 28,000 - 30,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Junior Data analyst
Junior Data analyst

Ledgent Technology • Vancouver (WA)

Hybrid
USD 65,000 - 90,000
Data Integrity Analyst
Data Integrity Analyst

ManTech • Herndon (VA)

Hybrid
USD 75,000 - 105,000
Data Anaylst
Data Anaylst

Reliable Safety & Flow Corporation • Farmers Branch (TX)

On-site
USD 41,000 - 44,000
Medical, Dental, Vision and FSA
401k with company match
Company-provided Life Insurance
+2
Data Anaylst
Data Anaylst

Reliable Sprinkler Co. • Farmers Branch (TX)

On-site
USD 41,000 - 44,000
Medical, Dental, Vision
401k with company match
Life Insurance
+3
Senior ERP Data Analyst
Senior ERP Data Analyst

Versique Executive, Professional & Interim Recruiting • Saint Paul (MN)

Hybrid
USD 90,000 - 120,000
Medical insurance
Dental insurance
Vision insurance
+7
Data Anaylst
Data Anaylst

Reliable Safety and Flow Corporation • Farmers Branch (TX)

On-site
USD 41,000 - 44,000
Medical, Dental, Vision and FSA after
401k with company match
Company-provided Life Insurance
+3
Data Quality Analyst
Data Quality Analyst

Taylor Hodson Staffing • New York (NY)

On-site
USD 60,000 - 80,000
IT Data Analyst
IT Data Analyst

OdoBan | Clean Control Corporation • Warner Robins (GA)

On-site
USD 70,000 - 110,000
Competitive salary
Modern Microsoft tech
Collaborative environment
+2
Data Quality Coordinator
Data Quality Coordinator

Vertex Solutions Inc. • Maryland

On-site
USD 55,000 - 75,000
Data Administrator
Data Administrator

Rawson • Houston (TX)

On-site
USD 40,000 - 55,000