JOB DESCRIPTIONDigital Marketing & MIS Executive (DME + MIS)

Company: Mayur Dynamic Tiles & Pavers

Location: Sitapura Industrial Area, Jaipur, Rajasthan

Salary: ₹20,000–₹28,000 per month

Qualification: Graduate in any stream

Department: Marketing & MIS

1. Job Purpose

To independently manage the company's digital marketing activities, content creation, online presence, advanced Google Sheets systems and MIS reporting. The candidate must be highly proficient in Google Sheets, capable of building automated reports and dashboards, and responsible for ensuring consistent marketing execution, accurate data management and timely management reporting.
1. Key Responsibilities

A. Advanced Google Sheets & MIS Reporting — Core Requirement

- Expert-level knowledge of Google Sheets is mandatory.
- Strong command of advanced formulas and functions, including QUERY, FILTER, ARRAYFORMULA, VLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS and IMPORTRANGE.
- Expertise in Pivot Tables, conditional formatting, data validation, dropdowns, checkboxes, data cleaning and error handling.
- Design automated MIS reports, interactive dashboards, management summaries and business trackers.
- Link multiple sheets, consolidate data from different sources and manage large datasets efficiently.
- Build formula-driven systems that reduce manual data entry, repetitive work and reporting errors.
- Create professional, user-friendly Google Sheets for daily operations, activity tracking and management review.
- Maintain data accuracy, consistency, access control and proper reporting formats.
- Identify reporting gaps and improve existing spreadsheet systems.
- Knowledge of Google Apps Script and workflow automation will be an added advantage.

B. Digital Marketing & Social Media Management

- Manage the company's Instagram and Facebook accounts, including posts, reels, stories and audience engagement.
- Plan and execute a regular social media content calendar.
- Create promotional content showcasing company products, projects, plant activities and customer installations.
- Prepare WhatsApp Status content, product-launch announcements, promotional offers and customer communication.
- Develop recent marketing ideas to strengthen brand awareness and customer engagement.

C. Photography, Videography & Editing

- Capture high-quality photographs and videos of products, projects, plants and customer sites.
- Record customer testimonials and perform basic drone shoots where permitted.
- Edit photographs and videos for social media, advertisements and promotional campaigns.
- Maintain an organized,



searchable photo and video library categorized by product, project and date.
- Plan and coordinate field visits for customer testimonials and project coverage.

D. Google Ads & Online Presence

- Manage Google Ads campaigns and monitor available performance metrics.
- Maintain and update Google Business Profile with fresh photographs, business updates and genuine customer reviews.
- Monitor online visibility and coordinate activities to improve brand presence.
- Track available advertising expenditure, leads and campaign performance.
- Support website updates, product information, project uploads and other online marketing activities.

E. Marketing Design & Branding

- Create professional marketing creatives using Canva and suitable editing tools.
- Prepare brochures, flyers, product catalogues, hoardings and other promotional materials.
- Ensure product specifications, company details and branding remain accurate and consistent.
- Coordinate with agencies and vendors for marketing material design, revisions and printing.

F. Agency Coordination & Follow-up

- Coordinate with SEO, lead-generation and digital-marketing agencies.
- Provide required product information, photographs, videos and marketing content.
- Follow up on pending tasks, campaign updates, website modifications and deliverables.
- Maintain a tracker of agency activities, deadlines, pending work and completion status.
- Ensure all assigned activities are followed through to completion.

G. AI Tools & Process Improvement

- Use ChatGPT and other AI tools for content ideas, captions, campaign planning, reporting support and productivity improvement.
- Verify AI-generated content for factual accuracy and brand suitability before publishing.
- Identify opportunities to improve marketing processes, reporting systems and operational efficiency.

1. Weekly Work Plan

- 1 day per week: Customer testimonials and customer-site coverage.
- 1–2 days per week: Project, plant and product photography, videography and drone shoots.
- Minimum 3 days per week: Office-based work covering Google Sheets automation, MIS reporting, content creation, editing, Google Ads, Google Business Profile, agency coordination, website updates and pending marketing activities.




- Maximum fieldwork: 3 days per week. Remaining working days must be dedicated to office-based execution, reporting, automation and content development.

The schedule may be adjusted according to customer availability, project requirements and business priorities.

1. Qualification & Required Skills

- Graduation in any stream is mandatory.
- Advanced Google Sheets expertise is essential , including formulas, automation, dashboards and MIS reporting.
- Good working knowledge of Microsoft Excel.
- Practical understanding of social media management and digital marketing.
- Knowledge of Canva, photography, videography and video-editing tools.
- Working knowledge of Google Ads and Google Business Profile.
- Robust analytical, problem-solving and data-management skills.
- Good communication, coordination, organization and follow-up abilities.
- Ability to independently manage multiple assignments and meet deadlines.
- Willingness to travel for customer visits, plant shoots and project coverage.

Experience: Relevant experience in Google Sheets/MIS, digital marketing, social media or content creation is preferred. Candidates must be able to demonstrate their Google Sheets skills through a practical assessment.

1. Key Performance Indicators (KPIs)

Performance will be evaluated on the basis of:
- Accuracy and timely submission of MIS reports.
- Quality of Google Sheets dashboards, formulas and automation.
- Reduction in manual reporting and repetitive work.
- Consistency and quality of social media content.
- Timely completion of photography, videography and editing assignments.
- Regular updates to Google Business Profile and online platforms.
- Proper tracking of leads, advertising expenditure and campaign performance.
- Timely agency follow-ups and closure of pending activities.
- Proper organization and maintenance of marketing data and content libraries.

1. Overall Accountability

The DME + MIS Executive will be responsible for the consistent execution of the company's digital marketing activities and the accuracy of its MIS reporting systems. The candidate must independently manage advanced Google Sheets, marketing dashboards, content creation, online presence, customer communication and agency coordination, ensuring that all assigned tasks are completed accurately, systematically and within deadlines. Important: This is a combined execution-oriented role. The selected candidate must be comfortable handling both advanced spreadsheet/MIS responsibilities and practical digital marketing work, including field visits.

📌 Digital Marketing & MIS Executive (DME + MIS) (Jaipur)
🏢 Mayur Dynamic Tiles u0026 Pavers
📍 Jaipur