Functional Consultant

Tata Consultancy Services Ltd

Marlborough, MA

JOB DETAILS
SALARY
$120,000–$150,000 Per Year
SKILLS
Acceptance Testing, Business Solutions, Campaigns, Cloud Computing, Communication Skills, Consulting, Customer Acquisition, Customer Churn, Customer Support/Service, Customer/Client Research, Data Analysis, Data Mapping, Data Modeling, Data Profiling, Data Quality, Database Extract Transform and Load (ETL), ERP (Enterprise Resource Planning), Employee Benefits, Functional Analysis, Legal, LifeTime Value (LTV), Loan Funding, Loyalty Programs, Marketing, Master Data Management (MDM), Process Flow, Requirements Management, Retail, Retail Management, SQL (Structured Query Language), Student Loans, Systems Analysis, Technical/Engineering Design, Use Cases, Validation Testing, eCommerce Sales
LOCATION
Marlborough, MA
POSTED
2 days ago

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

#LI-JH1

About the Company

T

Tata Consultancy Services Ltd