Data Analyst

Title: Senior Data Analyst (W2 Only) Location: Richmond, VA (Hybrid 3 Days onsite in every week) Duration: 3 Months Job Description: We are seeking a high-caliber Senior Data Analyst to join our Card Data Observability team. In this role, you will be the analytical engine driving the data protection, scan verification, and data compliance tracking workflows for our large-scale ledger migration. This is not a passive reporting role. You will dive directly into AWS S3 environments, compile analytical views inside Snowflake, parse unmasked validation data inside Databricks, and apply cryptographic validation rules to eliminate false-positive alert noise across millions of records. Your data analysis will directly guide engineering teams on how and where to apply production-level data masking and tokenization plays. Key Responsibilities 1. Data Ingestion & Missing File Reconciliation Monitor automated enterprise notifications ensuring that structural migrations are captured and incoming datasets are mapped for assessment. Analyze active AWS S3 storage buckets to calculate full counts of active data partition files. Cross-reference S3 partition metrics against Snowflake metadata logging tables to run missing part-file reconciliation logic. Identify missing scans or pipeline discrepancies and autonomously coordinate with the Enterprise SCAN team to initiate targeted ad-hoc data scanning requests. 1. Deep-Dive Vulnerability Analysis & Triage Extract active security violation events from complex Snowflake analytical views Build programmatic pivot metrics and classification profiles to map an exhaustive list of unique combinations of sensitive data types across multiple schema extensions. Perform context-aware analysis inside Databricks platforms to evaluate unmasked validation values against underlying transactional metadata layouts. Execute card data logic validation routines, validating raw payloads against the Luhn algorithm within our proprietary toolset. Triage findings meticulously into defined structural buckets: True Positive, False Positive, or Unsure categories based on core risk profiles. 1. Compliance Tracking & Governance Engineering Manage structural data dictionaries and trackers, including the DSF Backbook Migration Log and the Sensitive Data Classification Validation Log. Isolate, format, and push verified false positives directly to data management platforms to run bulk suppression loads, systematically immunizing pipelines against redundant security alert fatigue. Synthesize granular validation evidence sheets mapping schema properties, target data types, remediation rationale, and reference context profiles. 1. Remediation Validation & Dashboarding Partner closely with data engineering operators to track the health of automated end-to-end data remediation routines executing via Databricks jobs. Ensure strict risk isolation logic is sustained, confirming that downstream consumption layer systems remain locked until rescan validations return clean. Perform end-to-end file auditing to verify that post-masked outputs generated inside targeted write paths precisely mirror input baseline file tallies. Leverage Amazon QuickSight business intelligence environments to monitor visual tracking boards, ensuring zero data leakage or partition drops across integration scopes. 1. Cross-Functional Stakeholder Alignment Prepare and frame analytical findings packets ahead of critical technical reviews. Champion insights and drive live consensus calls within cross-functional operational meetings, including Daily Standups and Bi-Weekly SME Alignment Forums with Chief Data Office (CDO) leads and external integration points. Technical Skills & Qualifications Data Infrastructure Mastery: Extensive hand-on experience writing complex querying logic over structured and semi-structured architectures within Snowflake or equivalent enterprise cloud data platforms. Advanced Data Processing Knowledge: Proven background working within Databricks compute frameworks to explore, extract, and inspect underlying enterprise code bases or dataset tables. Cloud Architecture Fluency: Direct technical comfort querying, calculating, and inspecting cloud objects directly inside AWS S3 environments. Data Visualization & Delivery: Experience configuring access and generating scannable metrics reporting within Amazon QuickSight dashboards. Data Cleansing Logic: Deep comprehension of programmatic data filtration approaches, deduplication routines, and standard mathematical string validations (e.g., Luhn check patterns). Agile Communications Delivery: Exceptional technical writing capacity to compile audit logs, create operational Markdown playbooks, and effectively drive multi-organizational daily tracking forums. Applicant Notices & Disclaimers • For information on benefits, equal opportunity employment, and location-specific applicant notices, click here At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws.This position's pay range is $40.00/hr - $45.00/hr.