Business Analyst - Marketing Data Discovery

Systems Limited; Lahore; On-site; PKR 1,800,000 - 3,200,000; Full time

Job summary

Systems Limited is seeking a seasoned Business Analyst with strong CPG/FMCG and marketing analytics experience to bridge business stakeholders and data teams, translating marketing problems into precise data requirements and validating solutions with SQL during discovery.

You will collaborate with Marketing, Commercial and Analytics groups, define KPIs, data dictionaries and source-to-target mappings, and support testing to ensure delivered data solutions meet business needs.

Qualifications

• 5–7+ years of experience as a Business Analyst with strong CPG/FMCG and marketing analytics exposure.
• CPG/FMCG/Retail domain experience with understanding of products, brands, customers, retailers, distributors, consumers and channels.
• Marketing analytics exposure across Paid Media, Digital/Web, SEO, CRM/Loyalty, campaigns, consumer engagement or retail/trade marketing.
• Strong data and analytics understanding, including datasets, facts/dimensions, grain, KPIs, business rules, joins and data-quality concepts.
• SQL comfortability, with ability to query, join, aggregate and validate data independently; development-level SQL is not required.
• Strong Business Analysis capability, including discovery, requirements gathering, KPI/business rule definition and UAT support.
• Excellent communication and stakeholder management skills.

Responsibilities

• Conduct discovery sessions with Marketing, Commercial, Analytics and Data teams.
• Understand business problems and convert them into clear data, KPI and functional requirements.
• Analyze source data and work with Data team to define the appropriate analytical roadmap.
• Create and maintain key deliverables such as business requirements, KPI definitions, data dictionaries and source-to-target requirements.
• Perform SQL-based data analysis and validation during discovery and implementation.
• Support testing/UAT and ensure the delivered data solution meets the agreed business requirement.

Skills

SQL

Marketing analytics

KPI definitions

Data dictionaries

Data quality concepts

Discovery and UAT

Stakeholder management

Job description

The role requires a Business Analyst with strong CPG/FMCG and marketing analytics exposure who can bridge business stakeholders and data teams, translate marketing problems into data requirements, and work confidently with data and SQL during discovery and validation.

Responsibilities

• Conduct discovery sessions with Marketing, Commercial, Analytics and Data teams.
• Understand business problems and convert them into clear data, KPI and functional requirements.
• Analyze source data and work with Data team to define the appropriate analytical roadmap.
• Create and maintain key deliverables such as business requirements, KPI definitions, data dictionaries and source-to-target requirements.
• Perform SQL-based data analysis and validation during discovery and implementation.
• Support testing/UAT and ensure the delivered data solution meets the agreed business requirement.

Requirements

• 5–7+ years of experience as a Business Analyst with strong CPG/FMCG and marketing analytics exposure.
• CPG/FMCG/Retail domain experience with understanding of products, brands, customers, retailers, distributors, consumers and channels.
• Marketing analytics exposure across Paid Media, Digital/Web, SEO, CRM/Loyalty, campaigns, consumer engagement or retail/trade marketing.
• Strong data and analytics understanding, including datasets, facts/dimensions, grain, KPIs, business rules, joins and data-quality concepts.
• SQL comfortability, with ability to query, join, aggregate and validate data independently; development-level SQL is not required.
• Strong Business Analysis capability, including discovery, requirements gathering, KPI/business rule definition and UAT support.
• Excellent communication and stakeholder management skills.