Sales and Marketing MIS Analyst

Swid Process Technologies Pvt. Ltd.

Pune

On-site

INR 900,000 - 1,300,000

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Swid Process Technologies Pvt. Ltd.

in Pune seeks a Master Role Bank — Sales and Marketing MIS Analyst to provide independent, timely visibility of sales and marketing activity, funnel, forecasts, conversion, productivity and ROI. You will manage dashboards, ensure data quality, and deliver actionable insights to the COO.

Qualifications

  • Graduate in analytics/business/finance/engineering.
  • 3+ years MIS, sales operations or commercial analytics.
  • Advanced Excel / BI tools, CRM, data validation and independent communication.

Responsibilities

  • Own definitions, dashboards and data-quality controls for leads, opportunities, stages, forecast and campaigns.
  • Reconcile CRM data with proposals, orders and Finance/Operations records.
  • Publish daily exceptions and weekly/monthly performance MIS directly to COO.
  • Analyse source, region, employee, segment, stage, ageing, conversion, cycle time and forecast accuracy.
  • Maintain independence; report facts without altering data to match functional narratives.
  • Maintain and update the Daily Work Report (DWR) every working day with tasks, progress, results, pending actions, blockers and supporting evidence.

Skills

Advanced Excel
BI Tools
CRM
Data validation
Independent communication

Education

Analytics
Business
Finance
Engineering

Job description

Master Role Bank — Sales and Marketing MIS Analyst
Designation

Sales and Marketing MIS Analyst

Department

Marketing

Reports To

Chief Operating Officer

Direct Reports

None

Backup Coverage

COO or nominated independent analyst; Sales/Marketing may supply data but not suppress findings

Role Purpose

Provide the COO with independent, accurate and timely visibility of Sales and Marketing activity, funnel, forecasts, conversion, productivity and ROI.

Job Description and Responsibilities
  • 1. Own definitions, dashboards and data-quality controls for leads, opportunities, stages, forecast and campaigns.
  • 2. Reconcile CRM data with proposals, orders and Finance/Operations records.
  • 3. Publish daily exceptions and weekly/monthly performance MIS directly to COO.
  • 4. Analyse source, region, employee, segment, stage, ageing, conversion, cycle time and forecast accuracy.
  • 5. Detect stalled, duplicate, inflated, unsupported or unassigned opportunities and obtain corrections.
  • 6. Maintain independence; report facts without altering data to match functional narratives.
  • Maintain and update the Daily Work Report (DWR) every working day with tasks, progress, results, pending actions, blockers and supporting evidence.
  • Use Zoho CRM / Equivalent for complete lead and deal management, from lead/deal quality and qualification through proposal, follow-up and won/lost closure. Maintain accurate data and dates; update every activity and stage in real time. Complete every available field, using a justified Not Applicable only where genuinely inapplicable. Attach customer meeting voice recordings, location check-ins, WhatsApp / Equivalent, email and other communication screenshots, and customer call recordings as applicable; increase recording and evidence coverage. Recordings must follow company consent and data-access requirements.
Daily Modus Operandi
  • 1. Extract CRM/campaign/order data.
  • 2. Validate completeness and reconcile key values.
  • 3. Update dashboard and ageing.
  • 4. Issue exception list to owners.
  • 5. Analyse movement, conversion, productivity and ROI.
  • 6. Report unresolved/material issues directly to COO.
  • 7. Submit DWR.
  • Update DWR daily in the company-provided software and share with the reporting manager.
  • Update Zoho CRM / Equivalent immediately after each customer activity, status change or communication; reconcile open actions, dates and evidence.
Role Boundary

The role remains accountable for its outputs even when work is delegated. Backup coverage does not transfer pricing, contractual, publication, data-change or customer-commitment authority. All commitments, approvals, CRM records, source files and handovers must remain documented in approved systems.

Key Result Areas
  • 1. Single commercial MIS
  • 2. Data accuracy and reconciliation
  • 3. Funnel and forecast analytics
  • 4. Productivity and conversion
  • 5. Campaign ROI
  • 6. Independent exception reporting
  • Daily Work Report completeness and accuracy
  • Real-time CRM data accuracy, complete field usage and customer-interaction evidence
Key Performance Indicators
  • 1. Daily individual KPI achievement updates | Target: 100% daily | Review: Daily
  • 2. Saturday reports to individuals and uplines through MD | Target: 100% every Saturday to individual and reporting chain up to MD | Review: Weekly
  • 3. Data accuracy | Target: >=98% | Review: Monthly
  • 4. CRM and order reconciliation | Target: 100% monthly reconciliation | Review: Monthly
  • 5. Missing data and material variance alerts | Target: Within one working day of identifying a material gap | Review: Per exception
  • 6. No unauthorized data changes | Target: Zero | Review: Continuous
  • 7. DWR updation and accuracy | Target: 100% of working days with a complete, accurate DWR | Review: Daily
  • 8. CRM data quality, field utilisation and real-time updates | Target: 100% applicable fields complete; accurate data and dates; real-time updates from qualification to deal closure | Review: Daily
KPI Measurement Method

1. Items completed within the specified deadline / items due in the review period x 100; use timestamped records.

2. Items completed within the specified deadline / items due in the review period x 100; use timestamped records.

3. Correct records or items / records or items checked x 100; retain the review evidence.

4. Reconciled CRM/order records / records due x 100.

5. Items completed within the specified deadline / items due in the review period x 100; use timestamped records.

6. Count verified occurrences in the review period using the incident or exception register.

7. Working days with a complete and accurate DWR / working days due x 100; verify work evidence, progress, blockers and manager review.

8. Audit applicable field completeness, date/data accuracy and activity-to-entry timestamps; verify linked recordings, check-ins and communication evidence; track recording coverage and exceptions.

KPI Weights

1. Daily individual KPI achievement updates: 30%

2. Saturday reports to individuals and uplines through MD: 25%

3. Data accuracy: 20%

4. CRM and order reconciliation: 10%

5. Missing data and material variance alerts: 10%

6. No unauthorized data changes: 5%

7. DWR updation and accuracy: 0%

8. CRM data quality, field utilisation and real-time updates: 0%

Performance Framework

Review performance monthly using the specified KPI periods and evidence. Weights total 100% and express relative importance. Assess each KPI against its stated target and approved weight. Non-Sales roles have no exceeds-expectations band. Mandatory requirements remain applicable regardless of weight. Where no activity is due, record not applicable with the reason; do not record zero or invent achievement.

Target Rules

Use the applicable approved work plan, documented deadlines and source records for this role. Retain existing mandatory controls and elevate missing inputs or dependencies.

DWR is mandatory for every role: update every working day. It is monitored as a separate compliance requirement with no additional weight; existing KPI weights remain unchanged.

CRM completeness, accurate data/dates, real-time updates and interaction evidence are mandatory, non-weighted compliance requirements. Do not fabricate evidence or enter inaccurate values to fill fields.

Total KPI Weight

100%

Approval Status

Approved targets retained; hierarchy revised

KPI Register — Detailed Records

Daily individual KPI achievement updates
Department: Marketing
Target: 100% daily
Review: Daily
Measurement method: Items completed within the specified deadline / items due in the review period x 100; use timestamped records.
Weight: 30%
Status: Approved targets retained; hierarchy revised

Saturday reports to individuals and uplines through MD
Department: Marketing
Target: 100% every Saturday to individual and reporting chain up to MD
Review: Weekly
Measurement method: Items completed within the specified deadline / items due in the review period x 100; use timestamped records.
Weight: 25%
Status: Approved targets retained; hierarchy revised

Data accuracy
Department: Marketing
Target: >=98%
Review: Monthly
Measurement method: Correct records or items / records or items checked x 100; retain the review evidence.
Weight: 20%
Status: Approved targets retained; hierarchy revised

CRM and order reconciliation
Department: Marketing
Target: 100% monthly reconciliation
Review: Monthly
Measurement method: Reconciled CRM/order records / records due x 100.
Weight: 10%
Status: Approved targets retained; hierarchy revised

Missing data and material variance alerts
Department: Marketing
Target: Within one working day of identifying a material gap
Review: Per exception
Measurement method: Items completed within the specified deadline / items due in the review period x 100; use timestamped records.
Weight: 10%
Status: Approved targets retained; hierarchy retained

No unauthorized data changes
Department: Marketing
Target: Zero
Review: Continuous
Measurement method: Count verified occurrences in the review period using the incident or exception register.
Weight: 5%
Status: Approved targets retained; hierarchy revised

DWR updation and accuracy
Department: Marketing
Target: 100% of working days with a complete, accurate DWR
Review: Daily
Measurement method: Working days with a complete and accurate DWR / working days due x 100; verify work evidence, progress, blockers and manager review.
Weight: 0%
Status: Mandatory requirement; no separate weight

CRM data quality, field utilisation and real-time updates
Department: Marketing
Target: 100% applicable fields complete; accurate data and dates; real-time updates from qualification to deal closure
Review: Daily
Measurement method: Audit applicable field completeness, date/data accuracy and activity-to-entry timestamps; verify linked recordings, check-ins and communication evidence; track recording coverage and exceptions.
Weight: 0%
Status: Mandatory requirement; no separate weight

Requirements
  • Graduate in analytics/business/finance/engineering.
  • 3+ years MIS, sales operations or commercial analytics.
  • Advanced Excel / Equivalent/BI, CRM, data validation and independent communication.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Head Marketing
Head Marketing

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 4,000,000 - 6,000,000
Marketing Executive
Marketing Executive

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 400,000 - 650,000
Regional Sales Manager
Regional Sales Manager

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 1,500,000 - 2,300,000
Marketing Manager
Marketing Manager

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 1,500,000 - 2,500,000
Sales Manager
Sales Manager

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 1,200,000 - 2,400,000
Sales Executive
Sales Executive

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 350,000 - 550,000
Head Sales
Head Sales

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 1,200,000 - 2,200,000
Customer Relationship Manager
Customer Relationship Manager

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 700,000 - 1,200,000
Chief Operating Officer
Chief Operating Officer

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 6,000,000 - 7,500,000
PRCC Manager / Commercial Finance Manager
PRCC Manager / Commercial Finance Manager

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 1,800,000 - 2,400,000