Data Analyst

About

Dice is the leading career destination for tech experts at every stage of their careers. Our client, cloudingest inc, is seeking the following.

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

Skills

• SQL (most critical)
• Regex (core to role)
• Snowflake (data warehouse)
• Google Workspace (Sheets, Docs, Drive advanced)
• Internal Tool: I2 (for rule writing / mapping)

Interview Process

• Mode of Interview: 1 hr -- 1 round
• Timeline (review, interview, start) : ASAP-- Slight delay expected (hiring manager currently on vacation)