Senior Data Analyst

Job TitleSenior Data AnalystLocationMcLean, VALocal candidates only – no relocationScheduleOnsiteTypeW2 Contract OnlyLong-term contract (~19 months, possible direct opportunities)Pay Rate$55–65/Hr W2SummaryWe are seeking a Senior Data Analyst to support advanced transaction data analysis and merchant attribution efforts. This role focuses on analyzing large volumes of raw card transaction data, developing complex pattern-matching logic, and ensuring high-precision merchant mapping through data-driven rule creation and validation. The ideal candidate is highly analytical, detail-oriented, and experienced in SQL-based analysis and unstructured data parsing.Key ResponsibilitiesAnalyze raw card transaction data to identify transaction patterns, noise, and merchant-specific identifiers across eligible merchantsDevelop and maintain complex Regex patterns and rule-based logic to accurately map unstructured transaction strings to merchant entitiesUse SQL to monitor transaction volumes and performance metrics, identifying anomalies that indicate changes in merchant naming conventions or logic failuresPerform false-positive impact analysis to ensure mapping logic maintains high precision while preserving transaction coverageDocument authoritative mapping rules and pattern logic to ensure transparency, maintainability, and team-wide understandingManage quarterly update cycles by analyzing the impact of merchant list changes on existing logic and infrastructureEstablish and execute repeatable QA validation processes using historical datasets prior to production deploymentIdentify and escalate data integrity issues or inconsistencies in raw transaction feeds that could drive downstream errorsConduct root-cause analysis on missing or dropped transactions by querying raw data and refining existing logic as merchant behavior evolvesRequired QualificationsStrong experience analyzing large, unstructured datasetsAdvanced SQL skills for data querying, validation, and anomaly detectionHands-on experience writing and maintaining complex Regex logicProven ability to perform detailed data quality analysis and root-cause investigationStrong documentation skills to clearly explain logic, decisions, and outcomesAbility to manage multiple workstreams and iterative rule updates in a production environmentPreferred QualificationsExperience working with financial or card transaction dataBackground in merchant data attribution or transaction normalizationFamiliarity with QA validation methodologies for large-scale data environmentsExperience supporting long-term, rule-based data platforms in an enterprise setting#INDPRO