BSA with Data Mapping exp
$95,000 - $100,000/yr
BSA with Data Mapping exp System Data Analysis \& Mapping Lead end-to-end data mapping initiatives for system integrations, migrations, and ETL processes Analyze source and target data structures to identify relationships, dependencies, and transformation requirements Create comprehensive data mapping documentation including field-level specifications, transformation rules, and business logic Develop data lineage diagrams and data flow documentation to ensure traceability Conduct data profiling and quality assessment to identify anomalies, gaps, and inconsistencies Define data validation rules and acceptance criteria for data migration and integration projects Collaborate with data engineers and developers to ensure accurate implementation of mapping specifications SQL Development \& Analysis Write complex SQL queries to extract, transform, and validate data across multiple databases Develop stored procedures, views, and scripts to support data analysis and reporting needs Perform data reconciliation and validation using SQL to ensure data integrity post-migration Optimize SQL queries for performance and efficiency Conduct root cause analysis using SQL to troubleshoot data issues and discrepancies Create ad-hoc reports and data extracts to support business intelligence and decision-making Support database design reviews and provide input on data model optimization Business Analysis Elicit, document, and validate business requirements through interviews, workshops, and process analysis Translate business requirements into functional specifications and technical user stories Create detailed process flow diagrams, use cases, and business requirement documents (BRDs) Facilitate requirements review sessions with stakeholders and technical teams Conduct gap analysis between current state and future state data architectures Support UAT planning, test case development, and defect triage Serve as liaison between business stakeholders and technical development teams Stakeholder Collaboration Partner with cross-functional teams including IT, data engineering, business operations, and vendors Present findings, recommendations, and project updates to stakeholders at all levels Manage stakeholder expectations and ensure alignment on project scope and deliver ables Facilitate workshops and collaborative sessions to gather requirements and resolve issues Provide training and documentation to end-users on new systems and data processes Required Qualifications Technical Skills Advanced SQL proficiency including: Complex joins (inner, outer, cross, self-joins) Subqueries, CTEs (Common Table Expressions), and window functions Aggregate functions, grouping, and pivoting data Query optimization and performance tuning Stored procedures, triggers, and views Data mapping expertise including: Source-to-target mapping documentation Data transformation logic definition ETL (Extract, Transform, Load) process design Data quality and validation rules Master data management concepts Database knowledge: Relational database concepts and normalization Experience with SQL Server, Oracle, PostgreSQL, or MySQL Understanding of data warehousing and dimensional modeling Familiarity with NoSQL databases is a plus Business Analysis Skills 5-7 years of experience as a Business Analyst or Business Systems Analyst Strong requirements elicitation and documentation skills Experience with Agile/Scrum methodologies and tools (Jira, Confluence) Proven ability to create process flows, data flow diagrams, and technical specifications Experience with UAT coordination, test case development, and defect management Knowledge of SDLC (Software Development Life Cycle) best practices Salary Range- $95,000-$100,000 a year #LI-SP3 #LI-VX1 Location Raleigh, NC Job Function TECHNOLOGY Role Engineer Job Id 395496 Desired Skills Business Analysis Salary Range $95,000-$100,000 a year Desired Candidate Profile Qualifications : BACHELOR OF COMPUTER SCIENCE