What are the responsibilities and job description for the Lead Business Analyst position at Soho Square Solutions?
Role: Lead Business Analyst
Location: Richmond, VA
Employment Type: Contract (Hybrid)
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.