Sr Data Analyst (Regex)

job summary: Develop and implement complex Regex patterns and logic within internal platforms to accurately map unstructured transaction strings to specific merchant entities Leverage SQL to monitor transaction volumes and performance metrics, identifying anomalies or significant drops that suggest a shift in merchant naming conventions or logic failure Perform false-positive impact analysis to ensure high precision in mapping logic, preventing incorrect mapping while maintaining high coverage for eligible transactions location: McLean, Virginia job type: Contract salary: $54.93 - 60.79 per hour work hours: 9am to 5pm education: Bachelors responsibilities:

Responsibilities:

Analyze raw card transaction data to identify distinct patterns, common noise, and merchant-specific identifiers for a rotating set of eligible merchants Develop and implement complex Regex patterns and logic within internal platforms to accurately map unstructured transaction strings to specific merchant entities Leverage SQL to monitor transaction volumes and performance metrics, identifying anomalies or significant drops that suggest a shift in merchant naming conventions or logic failure Perform false-positive impact analysis to ensure high precision in mapping logic, preventing incorrect mapping while maintaining high coverage for eligible transactions Document authoritative mapping logic and pattern definitions to ensure the "why" behind each rule is transparent and maintainable by the broader team Manage the quarterly update lifecycle by proactively evaluating the impact of merchant list changes on existing rule sets and infrastructure Establish repeatable QA patterns for validating new rules against historical data sets before they are implemented in the production environment Identify and escalate data integrity gaps or inconsistencies in raw transaction feeds that could lead to downstream errors Conduct root-cause analysis on missing or "dropped" transactions by querying raw data to refine and adjust existing rules in response to evolving merchant telemetry qualifications: ducation: Bachelor's degree in Computer Science, Statistics, Mathematics, or a related field

Experience:

2+ years of experience in data analysis, data engineering, or a related field - not including any internships

Technical Skills:

Proficiency in

SQL and Regex Tools:

Proficiency in Google Workspace (advanced Sheets, Drive, Docs)

Equal Opportunity Employer:

Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility). This posting is open for thirty (30) days. job detailssummary$54.93 - $60.79 per hourcontractbachelor degreecategorycomputer and mathematical occupationsreference1331547job details job summary: Develop and implement complex Regex patterns and logic within internal platforms to accurately map unstructured transaction strings to specific merchant entities Leverage SQL to monitor transaction volumes and performance metrics, identifying anomalies or significant drops that suggest a shift in merchant naming conventions or logic failure Perform false-positive impact analysis to ensure high precision in mapping logic, preventing incorrect mapping while maintaining high coverage for eligible transactions location: McLean, Virginia job type: Contract salary: $54.93 - 60.79 per hour work hours: 9am to 5pm education: Bachelors responsibilities:

Responsibilities:

Analyze raw card transaction data to identify distinct patterns, common noise, and merchant-specific identifiers for a rotating set of eligible merchants Develop and implement complex Regex patterns and logic within internal platforms to accurately map unstructured transaction strings to specific merchant entities Leverage SQL to monitor transaction volumes and performance metrics, identifying anomalies or significant drops that suggest a shift in merchant naming conventions or logic failure Perform false-positive impact analysis to ensure high precision in mapping logic, preventing incorrect mapping while maintaining high coverage for eligible transactions Document authoritative mapping logic and pattern definitions to ensure the "why" behind each rule is transparent and maintainable by the broader team Manage the quarterly update lifecycle by proactively evaluating the impact of merchant list changes on existing rule sets and infrastructure Establish repeatable QA patterns for validating new rules against historical data sets before they are implemented in the production environment Identify and escalate data integrity gaps or inconsistencies in raw transaction feeds that could lead to downstream errors Conduct root-cause analysis on missing or "dropped" transactions by querying raw data to refine and adjust existing rules in response to evolving merchant telemetry qualifications: ducation: Bachelor's degree in Computer Science, Statistics, Mathematics, or a related field

Experience:

2+ years of experience in data analysis, data engineering, or a related field - not including any internships

Technical Skills:

Proficiency in

SQL and Regex Tools:

Proficiency in Google Workspace (advanced Sheets, Drive, Docs)

Equal Opportunity Employer:

Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility). This posting is open for thirty (30) days.