Data Quality & Integrity Analyst

Melissa; Rancho Santa Margarita (CA); On-site; USD 60,000 - 100,000; Full time

Benefits offered by this job

401(k) with company match

Medical, dental, and vision insurance

Life insurance, including company-pro:

Paid Holidays and personal time off

Tuition and loan assistance after one 

Office lunch on select weekdays

Haircuts and manicures

Workout and yoga classes

Onsite EV charging

Job summary

Melissa is seeking a curious, detail-oriented data professional to maintain and improve the quality of proprietary data assets. You will work with large datasets, investigate anomalies, and develop quality checks to ensure identifiers remain accurate and reliable.

You will write SQL queries, validate changes, and collaborate with Data Production, Programming, and QA teams to resolve issues and monitor quality trends. This role emphasizes data integrity and scalable processes.

Qualifications

• Strong analytical thinking and problem-solving skills.
• Working knowledge of SQL and relational databases.
• Ability to investigate complex data issues, identify patterns, and draw meaningful conclusions.
• Strong attention to detail and a commitment to data accuracy.
• Good written and verbal communication skills.
• Ability to work independently, take initiative, and follow problems through to resolution.
• Experience working with data in an analytical, operational, or technical capacity.
• 2+ years of relevant experience in data analysis, data quality, data operations, or a related field.
• Experience working with large datasets.
• Familiarity with Python or other scripting tools for data analysis and automation.
• Understanding of data matching, deduplication, entity resolution, or master data management.
• Experience with data profiling, data validation, or quality monitoring.
• Familiarity with ETL processes, APIs, or data-processing pipelines.
• Experience investigating production data issues and evaluating changes between data releases.

Responsibilities

• Analyze and validate data for accuracy, consistency, uniqueness, and reliability.
• Investigate data anomalies, duplicate identifiers, unexpected key changes, incorrect matches, and other data-quality issues.
• Write SQL queries to compare datasets, identify patterns, investigate problems, and validate results.
• Develop repeatable data-quality checks, reports, and automated validation processes.
• Evaluate changes in data sources, matching rules, and data-processing procedures to identify potential impacts on identifier quality.
• Collaborate with Data Production, Programming, and Quality Assurance teams to investigate and resolve issues.
• Test and validate improvements, corrections, and new capabilities involving Melissa's identifiers.
• Monitor quality trends and recommend opportunities for improvement.
• Maintain documentation of findings, quality standards, known issues, and validation procedures.
• Help establish and maintain data-integrity metrics and reporting.

Skills

Analytical thinking

SQL

Data analysis

Attention to detail

Independent work

Communication

Education

Bachelor's degree in a data-related field

Tools

Python

ETL tools

Job description

Melissa is seeking a curious, detail-oriented data professional to maintain and improve the quality of proprietary data assets. You will work with large datasets, investigate anomalies, and develop quality checks to ensure identifiers remain accurate and reliable.

You will write SQL queries, validate changes, and collaborate with Data Production, Programming, and QA teams to resolve issues and monitor quality trends. This role emphasizes data integrity and scalable processes.