Senior Data Analyst & Data Lineage Specialist — Hybrid

Ampcus, Inc; Richmond (VA); Hybrid; USD 80,000 - 110,000; Full time

Job summary

Ampcus, Inc is seeking a Sr. Data Analyst / Business Systems Analyst in Richmond, VA. This hybrid role entails analyzing complex data sets, crafting SQL queries, and presenting mapping materials for stakeholder approval.

The ideal candidate will possess advanced SQL skills, experience in data lineage, and proficiency with tools like Snowflake and Google Sheets. This 6-month contract will involve key responsibilities in data quality assurance and incident management.

Qualifications

• Proven experience in creating Source-to-Target Mappings (STTM) and data flow diagrams.
• Must be able to write joins, subqueries, and window functions for auditing.
• Strong communication skills to translate technical data into business impacts.

Responsibilities

• Analyze complex source data sets and business processes for mapping.
• Write and execute SQL queries to identify data quality issues.
• Build automated reporting frameworks to track data conversion health.
• Provide regular status updates to project teams on data incidents.

Skills

Advanced SQL

Data mapping

Stakeholder communication

Tools

Snowflake

Google Sheets

Job description

Ampcus, Inc is seeking a Sr. Data Analyst / Business Systems Analyst in Richmond, VA. This hybrid role entails analyzing complex data sets, crafting SQL queries, and presenting mapping materials for stakeholder approval.

The ideal candidate will possess advanced SQL skills, experience in data lineage, and proficiency with tools like Snowflake and Google Sheets. This 6-month contract will involve key responsibilities in data quality assurance and incident management.