Data Integrity Analyst: ERP/CRM Automation

Allied Business Solutions; Boise (ID); On-site; USD 60,000 - 90,000; Full time

Job summary

Allied Business Solutions is seeking a Data Analyst to ensure the accuracy, integrity, and consistency of our core business data across ERP, CRM, and PSA platforms. This hands-on role combines data stewardship, automation, and reporting to deliver trusted data and actionable insights for sales, service, and finance.

You will own data standards, run regular audits, build integrations, and automate workflows to reduce manual entry and improve data quality.

Qualifications

• Associate's or Bachelor's degree in Information Systems, CS, Business, or related field, or equivalent experience.
• Experience managing data across CRM, ERP, PSA, or comparable business systems.
• Hands-on SQL skills for querying, validation, and reconciliation.
• Experience building and maintaining integrations (APIs) and troubleshooting data-sync issues.
• Experience with process automation and Excel proficiency.
• Strong attention to detail and a high standard for data accuracy.
• Ability to manage multiple priorities and document data standards.

Responsibilities

• Serve as the single point of accountability for data accuracy across the ERP, CRM, PSA, and related systems.
• Establish and enforce data standards, naming conventions, and entry rules.
• Perform regular audits to identify and resolve errors, duplicates, gaps, and cross-system mismatches.
• Own master data (customers, products, pricing, equipment) so a single source of truth is reflected consistently.
• Maintain data dictionaries and documentation covering field definitions, ownership, and standards.
• Own the flow and synchronization of data between the ERP, CRM, PSA, and other platforms, ensuring records stay aligned.
• Write and maintain SQL queries to validate, extract, and reconcile data.
• Build and maintain API-based integrations; troubleshoot sync failures and drive root-cause resolution.
• Monitor integration health and proactively catch and correct data drift.

Skills

SQL

Data analysis

Excel

Data integration

Automation

Attention to detail

Multi-tasking

Education

Associate's or Bachelor's degree in Information Systems, Computer Science, Business, or related field

Equivalent relevant experience

Tools

SQL Server

Python

PowerShell

Excel

APIs

Job description

Allied Business Solutions is seeking a Data Analyst to ensure the accuracy, integrity, and consistency of our core business data across ERP, CRM, and PSA platforms. This hands-on role combines data stewardship, automation, and reporting to deliver trusted data and actionable insights for sales, service, and finance.

You will own data standards, run regular audits, build integrations, and automate workflows to reduce manual entry and improve data quality.