Tata Consultancy Services · 1 day ago
BSA with Data Mapping exp
Raleigh, NC
Full-time
Onsite
Mid, Senior Level
$95K/yr - $100K/yr
5+ years expTata Consultancy Services is looking for a Business Systems Analyst with expertise in data mapping. The role involves leading data mapping initiatives, performing data analysis, and collaborating with cross-functional teams to ensure successful data integration and migration.
Business Information SystemsConsultingInformation TechnologyIT Management
Responsibilities
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
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
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
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
Qualification
Required
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
Relational database concepts and normalization
Experience with SQL Server, Oracle, PostgreSQL, or MySQL
Understanding of data warehousing and dimensional modeling
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
BACHELOR OF COMPUTER SCIENCE
Preferred
Familiarity with NoSQL databases is a plus
Company
Tata Consultancy Services
Tata Consultancy Services is a business solutions company that specializes on information technology services and consulting.
10001+ employees
H1B Sponsorship
Tata Consultancy Services has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (7880)
2024 (9690)
2023 (8537)
2022 (11159)
2021 (9813)
2020 (11984)
Funding
Current Stage
Public CompanyTotal Funding
unknown2004-08-25IPO
Leadership Team
K. Krithivasan
Chief Executive Officer & Managing Director
Aarthi Subramanian
President and Chief Operating Officer
Recent News
2026-02-06
Tech Startups - Tech News, Tech Trends & Startup Funding
2026-02-06
Company data provided by crunchbase