Data Analyst with Regex -Only Local to VA
Full Time
50% Travel Required
Able to Sponsor
Hybrid
$50+
cloudingest inc
Fitment
Dice Job Match Score™
⏳ Almost there, hang tight...
Job Details
Skills
- SQL
- Regex
- Snowflake
Summary
Role : Data Analyst
Location: McLean, VA ONLY -- Hybrid 3 days
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
Mode of Interview: 1 hr -- 1 round
Timeline (review, interview, start) : ASAP-- Slight delay expected (hiring manager currently on vacation)
What are the top 3-5 skills?
Primary Tools:
o SQL (most critical)
o Regex (core to role)
o Snowflake (data warehouse)
o Google Workspace (Sheets, Docs, Drive advanced)
Internal Tool: I2 (for rule writing / mapping)
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
Mode of Interview: 1 hr -- 1 round
Timeline (review, interview, start) : ASAP-- Slight delay expected (hiring manager currently on vacation)
What are the top 3-5 skills?
Primary Tools:
o SQL (most critical)
o Regex (core to role)
o Snowflake (data warehouse)
o Google Workspace (Sheets, Docs, Drive advanced)
Internal Tool: I2 (for rule writing / mapping)
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: RTX1bc3ac
- Position Id: 8962508
- Posted 1 hour ago
Company Info
About cloudingest inc
CloudIngest is a full-service tech software firm. We possess extensive practical experience in Management, Business, and Economics. We stay up-to-date on emerging trends in terms of both the evolving cloud-based tech stack and client considerations in terms of Financial Billing and Payments. Our team consists of Client Intake Managers, Project Managers, Software Developers, Quality Assurance, and Integrative Solution and NLP Specialists all of whom are fully-equipped and ready to interface with members of your existing team. We are experienced working with client-side Project Managers as well as Designers and C-Suite business executives.
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs