Senior Data Analyst

Spectraforce Technologies; Richmond (VA); Hybrid; USD 90,000 - 120,000; Part time

Job summary

Spectraforce Technologies in Richmond, VA is seeking a Senior Data Analyst to join the Card Data Observability team. You will dive into AWS S3 environments, work in Snowflake, and apply cryptographic validation to reduce false positives across millions of records.

The role focuses on data protection, scan verification, and governance across data migrations, with hybrid work (3 days onsite) and a 3-month duration.

Qualifications

• Extensive hands-on experience writing complex SQL queries across Snowflake or similar cloud data platforms.
• Experience with Databricks compute frameworks to explore and inspect enterprise datasets.
• Fluency querying and inspecting AWS S3 data in a cloud environment.
• Experience configuring access and dashboards in Amazon QuickSight.
• Strong data cleansing, deduplication, and validation logic.
• Excellent technical writing for audit logs and Markdown playbooks.

Responsibilities

• Ingest data and reconcile missing files across migrations in S3 and Snowflake metadata.
• Analyze security events, map data types, and triage results into TP/FP/Unsure.
• Manage data dictionaries and validation logs; push false positives to data management platforms.
• Collaborate with data engineers to validate end-to-end remediation routines in Databricks.
• Use QuickSight dashboards to monitor data integrity and prevent leakage.

Skills

Data infrastructure mastery

Advanced data processing

Cloud architecture fluency

Data visualization delivery

Data cleansing logic

Agile communications delivery

Tools

Snowflake

Databricks

AWS S3

Amazon QuickSight

Job description

Title: Senior Data Analyst

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.

2. 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.

3. 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.

4. 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.

5. 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.