Functional Consultant

Tata Consultancy Services; Marlborough (MA); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Discretionary incentive

Medical coverage

Parental leave

Insurance options

Certification reimbursement

Vacation & holidays

Legal assistance

Job summary

Tata Consultancy Services in Marlborough, MA seeks a Retail Functional Consultant to lead requirements, design data models, and map data across source systems for a unified customer view.

Role requires 5-7+ years in data consulting or analytics within retail, strong SQL, and ability to translate business needs into technical specifications. Extensive stakeholder collaboration and UAT support are part of the responsibilities.

Qualifications

• 5-7+ years of experience as a Data Consultant, Business Systems Analyst, or Functional Analyst.
• Retail industry expertise with understanding of loyalty tiers and cross-channel behavior.
• Proficiency in Customer 360 / Master Data Management concepts.
• Strong SQL skills for data profiling, source-to-target mapping validation, and ad-hoc analysis.
• Ability to translate ambiguous business needs into precise technical requirements.

Responsibilities

• Lead workshops and interviews with client stakeholders to understand and document current and future-state needs for a unified customer view.
• Define and design the conceptual and logical customer data model. Identify key attributes, entities, relationships, and hierarchies.
• Analyze source systems (POS, e-commerce, Loyalty, Marketing Cloud, ERP, Customer Service) and create data mapping specs for ETL/ELT teams.
• Collaborate with business teams to define how Customer 360 data activates use cases like campaign segmentation and personalization.
• Serve as the functional expert during testing and validation phases to ensure data quality and requirements are met.
• Create and maintain functional documentation including data dictionaries and process flows.

Skills

SQL

Retail data

Data modeling

Stakeholder communication

ETL/ELT

Education

Bachelor's degree

Tools

POS systems

ERP

Marketing Cloud

Job description

Job Description

Retail Functional Consultant

Must Have Technical/Functional Skills

• Experience: 5-7+ years of experience as a Data Consultant, Business Systems Analyst, or Functional Analyst, with a proven track record of working on large-scale data projects.
• Retail Industry Expertise: Deep, hands-on experience in the retail sector. Must understand the nuances of retail customer data (householding, loyalty tiers, promotional activity, cross-channel behavior).
• Customer Data Proficiency: Demonstrable experience with core Customer 360 / Master Data Management (MDM) Concepts.
• Data Analysis & SQL: Strong proficiency in SQL for data profiling, source-to-target mapping validation, and ad-hoc analysis. You must be comfortable getting your hands dirty in the data.
• Exceptional Communication: World-class ability to communicate complex data concepts to non-technical business audiences and to translate ambiguous business needs into precise technical requirements.

Roles & Responsibilities

• Stakeholder Engagement & Requirements Gathering: Lead workshops and interviews with client stakeholders to deeply understand and document their current and future-state needs for a unified customer view.
• Functional Design & Data Modeling: Define and design the conceptual and logical customer data model. Identify key customer attributes, entities, relationships, and hierarchies required to meet business objectives.
• Source System Analysis & Data Mapping: Analyze the client's myriad source systems (e.g., Point-of-Sale, e-commerce, Loyalty Program, Marketing Cloud, ERP, Customer Service) and create detailed data mapping specifications for the ETL/ELT development teams.
• Use Case Enablement: Collaborate with business teams to define how the Customer 360 data will activate key use cases, such as campaign segmentation, personalization, churn prediction, and customer lifetime value (CLV) calculation
• Solution Validation & UAT: Act as the functional expert during the testing and validation phases, ensuring that the built solution meets the documented business requirements and data quality thresholds.
• Documentation & Knowledge Transfer: Create and maintain comprehensive functional documentation, including data dictionaries, process flows, and business rule definitions, to ensure the client can successfully adopt and govern the solution.

Education

Bachelor's degree

TCS Employee Benefits Summary

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support: Maternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 40 1K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Salary Range: $120000 - $150000 a year

Qualifications:

BACHELOR OF COMPUTER SCIENCE