BSA Analyst with Marketing exp

Tata Consultancy Services; Raleigh (NC); On-site; USD 90,000 - 100,000; Full time

Job summary

Tata Consultancy Services seeks a Systems and Data Analyst with 8+ years of experience in Banking, Finance, and IoT domains. The role focuses on requirements gathering, system design, functional analysis, implementation, and testing of enterprise applications and data-driven systems.

Responsibilities include translating stakeholder needs into specifications, designing scalable solutions, and leveraging BI tools like Power BI and Tableau to deliver actionable insights.

Qualifications

• 8+ years of experience in Banking, Finance, and IoT domains
• Experience translating stakeholder needs into functional specifications
• Experience in data modeling, SQL development, and backend system design
• Experience leading data integration projects and cross-functional collaboration
• Experience with BI/reporting tools (Power BI, Tableau) and data visualization

Responsibilities

• Gather and document system requirements from stakeholders
• Translate business needs into functional and technical specifications
• Design and implement end-to-end system integrations across platforms
• Lead data integration projects (e.g., Marketo-LinkedIn) and oversee data flow mappings
• Develop and validate data pipelines and perform data profiling
• Create dashboards and reports to support decision-making
• Coordinate testing, training, and change management for new systems
• Apply project management practices to track deliverables, timelines, and budgets
• Communicate complex technical concepts to non-technical audiences

Skills

Requirements gathering

System design

Functional analysis

Project management

Communication to non-technical users

Tools

SQL

Power BI

Tableau

Google Analytics

Python

Excel

Marketo

BlueConic CDP

Job description

Systems and Data Analyst with 8+ years of experience in Banking, Finance, and IoT domains, specializing in requirements gathering, system design, functional analysis, implementation, and testing of enterprise applications and data-driven systems.

Job Description

• Systems and Data Analyst with 8+ years of experience in Banking, Finance, and IoT domains, specializing in requirements gathering, system design, functional analysis, implementation, and testing of enterprise applications and data-driven systems.
• Demonstrated expertise in analyzing business objectives, translating stakeholder needs into functional and technical specifications, and designing system solutions aligned with organizational goals.
• Skilled in conducting system feasibility studies, evaluating existing systems, and recommending enhancements to improve efficiency, scalability, and user experience.
• Adept at data modeling, SQL development, and working with major RDBMS platforms such as Oracle, SQL Server, and PostgreSQL for backend system design and validation.
• Experienced in integrating and migrating data across systems, ensuring consistency, integrity, and accuracy through robust data validation and profiling practices.
• Strong background in BI and reporting tools such as Power BI, Tableau, and Google Analytics for translating system data into actionable business insights.
• Collaborated with cross-functional teams to define and document system requirements, ensuring alignment between business stakeholders, development teams, and QA.
• Supported system implementations by coordinating testing, training end-users, managing change requests, and facilitating smooth transitions to new technologies.
• Applied project management principles to track deliverables, timelines, and budgets, ensuring successful deployment of system solutions.
• Proficient in Excel-based data analysis, including advanced functions (VLOOKUP, INDEX/MATCH, Pivot Tables, Macros) for data validation and reporting.
• Experienced in creating technical documentation, including user manuals, system workflows, data dictionaries, and process guides.
• Strong ability to communicate technical concepts to non-technical users and recommend system and process improvements based on analytical findings.
• Skilled in identifying system anomalies, conducting root-cause analysis, and implementing corrective actions to optimize performance and data reliability.
• Proven ability to manage multiple high-visibility projects in a cross-functional, Agile/Scrum environment, ensuring quality delivery under tight deadlines.
• Design and implemented end-to-end system integrations across multiple marketing and data platforms (e.g., Marketo, BlueConic CDP, Splash, CRM, Oracle, EDW) to enable seamless automation and data consistency.
• Serve as a Subject Matter Expert (SME) for marketing technology systems, advising on architecture, integrations, and process improvements.
• Participated as a key member of the Architecture Board, contributing to the development of Data Integration and Attribute Mapping (DIAM) frameworks for cross-platform system integration.
• Lead the Marketo-LinkedIn data integration project, overseeing system design, data flow mapping, testing, and deployment for enhanced lead management capabilities.
• Conduct data and system quality assessments across billions of records, identifying gaps, anomalies, and inconsistencies, and implemented automated Python-based validation scripts.
• Support the management and optimization of the MarTech Stack, defining KPIs and monitoring system performance against industry benchmarks.
• Design and maintained dashboards and reports using Tableau, Power BI, and Python visualization tools to support business decision-making and monitor system health.

Salary Range- $90,000-$100,000 a year