Senior Data Analyst - STTM & Data Quality Specialist

Ampcus Inc; Richmond (VA); Hybrid; USD 90,000 - 115,000; Full time

Job summary

Ampcus Inc. is seeking a highly motivated Sr. Data Analyst / Business Systems Analyst to join their Richmond, VA team. The role involves analyzing complex data sets, executing SQL queries, and creating automated reporting frameworks. Candidates should have advanced SQL skills, data lineage knowledge, and proficiency in tools like Snowflake and Google Sheets.

This is a 6-month hybrid contract position, where you will communicate with stakeholders and ensure data integrity throughout the project's lifecycle.

Qualifications

• Must be able to write joins, subqueries, and window functions to audit large datasets.
• Proven experience in creating Source-to-Target Mappings (STTM) and data flow diagrams.

Responsibilities

• Analyze complex source data sets and business processes.
• Write and execute complex SQL queries.
• Build and execute automated reporting frameworks.
• Create and present mapping materials for stakeholders.
• Support the verification phase by triaging system issues.

Skills

Advanced SQL

Data Lineage

Proficiency in Snowflake

Proficiency in Google Sheets

Job description

Ampcus Inc. is seeking a highly motivated Sr. Data Analyst / Business Systems Analyst to join their Richmond, VA team. The role involves analyzing complex data sets, executing SQL queries, and creating automated reporting frameworks. Candidates should have advanced SQL skills, data lineage knowledge, and proficiency in tools like Snowflake and Google Sheets.

This is a 6-month hybrid contract position, where you will communicate with stakeholders and ensure data integrity throughout the project's lifecycle.