Urgent Hiring :: Data Analyst :: Richmond, VA (Hybrid) Local Candidates Only :: Rate $45 on C2C MAX :: MUST HAVE RECENT BANKING FINANCIAL CLIENT OR CAPITAL ONE.
Abhay Dubey
Hello,
I hope you are doing well!
Kindly acknowledge me, are you Comfortable with this Position then please share with me your updated resume
Job Title: Data Analyst
Job Location: Richmond, VA (Hybrid) Local Candidates Only
Job Type: Contract
Interview Mode: Interviews- 2 rounds of interviews (30-minute fitment round +1 hour coding question on PySpark & Python, SQL, Amazon QuickSight, Databricks)
MUST HAVE RECENT BANKING FINANCIAL CLIENT OR CAPITAL ONE.
Job Description
MUST SKILLS REQUIRED
• PySpark- very strong – all the coding questions are on PySpark, Python – Need to be very strong
• Databricks
• SQL
• AWS
• Amazon Quick Sight dashboards.
• Snowflake
This role is a part of the scanner mediation team which helps in converting large validated data from one infrastructure to another, scanning the HSA information with large amount of data .This team has 2 developers /2 analysts and 3rd role will be reporting to the HM, partner with the partnership team, daily stands up .
ROLE OVERVIEW
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.
Thanks & Regards,
Abhay
Source Infotech Inc.
E-mail: ab...@sourceinfotech.com
Hangout: waybi...@gmail.com
LinkedIn: linkedin.com/in/abhayy-dubey-a5425423a
Disclaimer: If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at rem...@sourceinfotech.com for automatic removal. And mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. We are sorry for the inconvenience.