BSA with Data mapping

Phoenix, NM - USA

Monthly Salary: Not Disclosed

Posted on: 5 hours ago

Vacancies: 1 Vacancy

Job Summary

Bill Rate: MAX CONFIRMED $65
MSP Owner: Mya Riecke
Location: ONSITE- Raleigh//Phoenix/ Remote
Duration: 6 months
GBaMS ReqID:

Role: BSA with Data mapping

Descriptions:

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 deliverables
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