Sr. Data Analyst / Business Systems Analyst

Ampcus Incorporated

Richmond, VA

JOB DETAILS
SKILLS
Analysis Skills, Business Processes, Business Services, Business Solutions, Consulting, Data Analysis, Data Mapping, Data Quality, Data Sets, Documentation, Identify Issues, Incident Management, Problem Solving Skills, Reconciliation, Reporting Skills, Root Cause Analysis, SQL (Structured Query Language), Status Reports, Systems Analysis, Writing Skills
LOCATION
Richmond, VA
POSTED
17 days ago

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: Sr. Data Analyst / Business Systems Analyst

Location:Richmond, VA (Hybrid)

Duration: 6 Months contract

Job Description - Key Responsibilities

  • Data Analysis & Mapping: Analyze complex source data sets and business processes to define comprehensive mapping logic. You will be responsible for creating the "Source-to-Target" documentation used by the development teams.
  • SQL Development: Write and execute complex SQL queries to identify data quality issues, anomalies, and gaps in source systems before they hit the production pipeline.
  • Conversion & Reconciliation Reporting: Build and execute automated reporting frameworks to track data conversion health. You will perform side-by-side reconciliations between load-ready files and destination systems to ensure 100% data integrity.
  • Stakeholder Communication: Create and present mapping materials for socialization and formal sign-off. You will provide regular status updates to the broader project team, translating technical data hurdles into clear business impacts.
  • Triage & Incident Management: Support the verification phase by triaging system issues. You will analyze incidents, determine root causes, and develop status reports to keep stakeholders informed of resolution progress.

Technical Requirements

  • Advanced SQL: Must be able to write joins, subqueries, and window functions to audit large datasets.
  • Data Lineage: Proven experience in creating Source-to-Target Mappings (STTM) and data flow diagrams.
  • System/Tools: Proficiency in Snowflake and Google Sheets.
 

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans, or individuals with disabilities.

About the Company

A

Ampcus Incorporated

Ampcus Inc is a global technology and business consulting firm specializing in Digital Transforrmation, Big Data, Analytics, Cyber Security, Testing, IV&V, Infrastructure Management and Enterprise Solutions. Ampcus Inc is an SBA 8(a) certified Women and Minority Owned global Provider of broad range of consulting Services. From strategy to execution, our disciplined yet flexible approach starts and ends with our clients. By listening hard and working harder, their goals become our goals. We are an ISO 9000, ISO 20000, ISO 27000 and CMMi Level certified company.

Ampcus consultants have significant business, engineering and technology experience. Our consultants have over 20 years of business experience and an average of over 10 years of engineering and technology experience. This means that the project teams understand how systems work and how the technology impacts the business processes of organizations.

We believe that success of an engagement is determined by strong project management, clear communication and mutual commitment working collaboratively. Our methodology begins by listening to the customer needs, then working with their teams to gain a clear understanding of the requirements, while providing a knowledge transfer of best practices for the organization. As a recognized leader providing customized software services, management and engineering solutions to companies around the world, our ability to deliver is a "granted"​ that makes companies put their trust in us to answer their day-to-day business challenges and put them on a path for greater success. We are the choice for our clients because we look at our clients business from a growth perspective.

Industry: Information Technology and Services

Specialties: Digital Transformation, Big Data and Analytics, Infrastructure Management Services, Testing and IV&V, Cyber Security, Active Directory and E-mail Infrastructure, Project Management, Training, and ERP, CRM. EAI, BI

COMPANY SIZE
500 to 999 employees
INDUSTRY
Staffing/Employment Agencies
WEBSITE
http://www.ampcus.com