Job Description – Data Management Specialist (Sales & Marketing)

Company: Makams Industries Pvt. Ltd.
Job Title: Data Management Specialist – Sales & Marketing
Location: Gurugram, Haryana
Department: Administration
Experience: 2–5 Years
Qualification: Graduate in Business Administration, Marketing, Data Analytics, Statistics or a related field.

Important Note

Candidates must have strong practical working knowledge of Microsoft Excel, including formulas, data analysis and reporting. Candidates without hands-on experience in Excel formulas are requested not to apply.

About the Role

We are looking for a detail-oriented and analytical Data Management Specialist to manage, analyse and interpret sales and marketing data. The selected candidate will support business decision-making through accurate reporting, dashboards, market research and performance analysis.

The role will also involve coordinating with market vendors, sales partners and internal stakeholders to collect, verify and maintain relevant business information.

Key Responsibilities

- Collect, organise, clean and analyse sales and marketing data from multiple sources.
- Develop and maintain Excel-based reports, dashboards and MIS to monitor sales performance, targets, leads and business KPIs.
- Analyse customer behaviour, market trends, competitor activities and potential business opportunities.
- Prepare periodic sales reports, performance summaries and management presentations.
- Support sales forecasting, territory planning and pipeline management through data analysis.
- Monitor sales and marketing campaign performance and evaluate their effectiveness.
- Coordinate with sales teams, market vendors, business partners and other stakeholders for data collection and follow-ups.
- Ensure data accuracy, consistency and timely reporting.
- Automate recurring reports and improve existing data management processes.
- Work closely with Sales, Marketing,



Finance and Operations teams to provide meaningful business insights.

Required Skills & Technical Competencies

1. Microsoft Excel – Mandatory

- Advanced knowledge of Excel formulas and functions.
- VLOOKUP, HLOOKUP, XLOOKUP.
- IF, AND, OR, SUMIF, SUMIFS, COUNTIF and COUNTIFS.
- INDEX & MATCH.
- Pivot Tables and Pivot Charts.
- Conditional Formatting and Data Validation.
- Data Cleaning, Sorting and Filtering.
- Dashboard creation and MIS reporting.
- Basic knowledge of Excel automation and macros will be an added advantage.

2. Other Technical Skills

- Working knowledge of MS Word and PowerPoint.
- Knowledge of Power BI or Tableau will be an advantage.
- Basic understanding of SQL and database management is preferred.
- Familiarity with CRM/ERP systems is desirable.

3. Professional Skills

- Strong analytical and problem-solving abilities.
- Excellent attention to detail and data accuracy.
- Good communication and coordination skills.
- Ability to manage multiple tasks and meet deadlines.

Preferred Industry Experience

Candidates having experience in any of the following industries will be preferred:

- Pharmaceuticals
- Chemicals and Ingredients
- FMCG
- Manufacturing
- Export-Oriented Industries

Why Join Us?

- Professional and collaborative working environment.
- Opportunity to work with cross-functional teams and global business partners.
- Exposure to sales analytics, business intelligence and management reporting.
- Market-competitive salary based on experience and skills.

How to Apply?

Interested candidates can share their updated CV at:

Email: [email protected]

Email Subject: Application – Data Management Specialist – Sales & Marketing

Important: Only candidates with practical knowledge of Microsoft Excel formulas and data analysis should apply.

Job Types: Full-time, Permanent

Pay: ₹20,000.00 - ₹40,000.00 per month

Benefits:

- Cell phone reimbursement
- Paid sick time
- Provident Fund

Work Location: In person

📌 MIS Executive (Gurugram)
🏢 Makams Industries Private
📍 Gurugram