Data Analyst-II

Title: Data Analyst-II

Location: RO, USA, CA, San Francisco, Folsom St Bay Area CA (Remote)

Pay rate-$50/hr on W2

Duration: 04+ Months

Internal Job Title: CRM Data Quality Analyst –Ads & Promotions (Franchise Segment) Role Overview

Client is seeking a detail-oriented CRM Data Quality Analyst to support the Ads & Promotions business within the Franchise segment.

This role is responsible for ensuring the accuracy, consistency, and integrity of CRM data that powers sales, account management, and marketing initiatives.

You will play a critical role in maintaining clean and reliable data across systems, enabling better decision-making, campaign execution, and partner engagement.

This position requires a strong analytical mindset, a high level of attention to detail, and the ability to collaborate cross-functionally with Sales, Account Management, and Operations teams.

Key Responsibilities

Reconcile data across multiple systems (CRM platforms, internal tools, data exports, and reporting dashboards) to ensure consistency and accuracy

Identify, investigate, and resolve duplicate, incomplete, or inconsistent records within the CRM

Execute bulk data cleanup and normalization efforts, including standardizing naming conventions, formatting, and account hierarchies

Conduct regular audits of CRM data quality and proactively surface systemic issues impacting data integrity

Build, maintain, and improve data validation rules, workflows, and QA processes to prevent future data issues

Partner closely with Sales, Account Management, and Operations teams to correct data discrepancies and reinforce best practices

Document data processes, cleanup methodologies, and governance standards

Recommend and implement process improvements to support ongoing data hygiene and scalability

Required Qualifications

2–5 years of experience in data quality, operations, CRM management, or a related field

Hands-on experience with CRM platforms (e.G., Salesforce or similar systems)

Strong proficiency in Excel or Google Sheets (e.G., pivot tables, VLOOKUP/XLOOKUP, data manipulation)

Experience with data reconciliation, cleansing, and validation techniques

Exceptional attention to detail and ability to spot inconsistencies and patterns in data

Strong organizational and problem-solving skills

Preferred Qualifications

Experience supporting Ads, Promotions, or Sales Operations functions

Familiarity with franchise or multi-location business models

Basic SQL or experience querying datasets

Experience working with large datasets and bulk data operations

Exposure to data governance or data stewardship practices

Additional notes:

Sets up new customers, establishing the customer role in the system. Contacts customers to request additional information and to verify customer data.

Troubleshoots and resolves issues relative to customer setup using established guidelines.

Works with supervisor to develop solutions when problem is more complex of affects multiple processes across the department.

Completes requests within established timeframes and keeps requestor notified of status.

Ensures data accuracy, validity, and completeness in results.

Creates and updates core master data procedures as directed.

Begins to demonstrate understanding of processing customer requests to downstream processes/systems.

Participates on projects as required and assigned by management.

Identifies technical issues encountered in the production environment to the IT department and escalates for resolution.