Data Quality Business Analyst

About This Role

The Data Quality Business Analyst will partner with various stakeholders to define data quality requirements and translate them into implementable rules, SQL logic, monitoring, and documentation. This role requires practical pharmaceutical data knowledge and the ability to independently move work from requirement discovery through validation and operational handoff.

Responsibilities

• Partner with business, data governance, data engineering, and data operations stakeholders to define data quality requirements
• Translate data quality requirements into implementable rules, SQL logic, monitoring, and documentation
• Independently move work from requirement discovery through validation and operational handoff
• Lead requirements workshops and translate business needs into clear DQ rules, thresholds, exceptions, ownership, notifications, SQL logic, acceptance criteria, and test scenarios
• Profile source data and implement checks for completeness, validity, uniqueness, consistency, accuracy, timeliness, volume, anomalies, reconciliation, and business rules
• Analyze failed checks and record-level evidence, investigate false positives, coordinate issue triage, and document status, resolution, and recurring patterns
• Identify opportunities for reusable rule templates, automation, and improved DQ operating processes

Requirements

• 4-5 years of hands-on data quality implementation experience, including rule design, testing, deployment, monitoring, and issue follow-up
• Relevant DQ experience in pharma or life sciences, preferably supporting commercial, medical, patient, or field analytics use cases
• Working knowledge of common pharma datasets, such as IQVIA claims and prescription data, LAAD/patient-level data, HCP/HCO and affiliation data, Veeva CRM activity, payer/market access data, product sales, specialty pharmacy, marketing, and master/reference data
• Intermediate SQL skills, including joins, CTEs, aggregations, window functions, data validation, reconciliation, and troubleshooting
• Strong analytical, documentation, facilitation, and stakeholder communication skills
• Able to explain technical results in business terms and maintain audit-ready traceability

Nice to have:

• Experience using Databricks and Snowflake for profiling, query development, view creation, validation, and source-to-target reconciliation
• Hands-on experience with Ataccama ONE, including profiling, catalog, rules, monitoring projects, scheduling, notifications, result analysis, and rule documentation
• Familiarity with Collibra for catalog search, business glossary, ownership, lineage, governance relationships, and connecting DQ rules and results to governed assets
• Experience with Collibra Data Quality & Observability and Collibra workflows