Management Information Systems Specialist

About the Role
True Nutrition Performance Private Limited is looking for a detail-oriented and analytical MIS & Meta Ads Specialist to manage business reporting, sales MIS, data analysis, Meta Ads reporting, and digital advertising performance.
The ideal candidate should be highly proficient in MS Excel/Google Sheets, possess strong data-handling and reporting skills, and have practical experience with Meta Ads (Facebook & Instagram), including campaign analysis, optimization, and identifying discrepancies or misreporting in advertising data.
Key Responsibilities
1. MIS, Business Reporting & Sales Analysis
Prepare accurate and timely daily, weekly, and monthly MIS reports, dashboards, and management reports using Excel/Google Sheets.
Maintain and analyze sales, purchase, inventory, collection, outstanding, and business-performance data.
Track sales by product, customer, salesperson, territory, and time period, including targets vs. actuals and variance analysis.
Prepare customer/party-wise sales, payment, receivables, outstanding, repeat-customer, inactive-customer, and new-customer reports.
Identify trends, gaps, variances, and actionable business insights.
Ensure data accuracy and coordinate with sales, accounts, operations, and management teams for data collection and verification.
2. Meta Ads Management, Reporting & Reconciliation
Manage and monitor Meta Ads campaigns across Facebook and Instagram, including campaign, ad set, audience, creative, and placement performance.
Track and report spend, leads, conversions, reach, impressions, CTR, CPC, CPL, ROAS, and other relevant KPIs through daily, weekly, and monthly reports.
Reconcile Meta Ads data with CRM, website, sales, order, payment, and revenue data wherever applicable.
Investigate discrepancies between Meta-reported and actual results, including duplicate, invalid, spam, or delayed leads; attribution issues; tracking errors; and data mismatches.
Verify advertising spend, leads, conversions, and revenue against internal MIS and other platforms.
Monitor Meta Pixel, Conversions API, events, UTM parameters, attribution settings, and conversion tracking for data accuracy.
Maintain advertising expenditure and performance MIS, compare marketing spend with business results, and identify underperforming campaigns and optimization opportunities.
Coordinate with marketing/creative teams on testing and improving creatives, budgets, and campaign efficiency.
Report discrepancies, possible causes, corrective actions, and optimization recommendations to management.
Required Skills
Strong knowledge of MS Excel and Google Sheets, including Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, IF formulas, charts, and dashboards.
Strong analytical, numerical, data-reconciliation, and reporting skills.
Good understanding of sales and business MIS.
Practical experience with Meta Ads Manager and Facebook & Instagram advertising metrics.
Ability to identify Meta Ads misreporting, attribution discrepancies, tracking issues, and mismatches with CRM, website, sales, order, and revenue data.
Familiarity with Meta Pixel, Conversions API, events, UTM tracking, and attribution reporting.
Ability to prepare clear, management-friendly reports and work with large datasets under deadlines.
Strong attention to detail, data accuracy, communication, and coordination skills.
Preferred Skills
Experience in FMCG, nutraceutical, sports nutrition, supplements, e-commerce, or D2C businesses.
Knowledge of Google Analytics, Google Ads, Shopify, CRM, or other business analytics tools.
Experience creating automated Excel/Google Sheets dashboards.
Basic understanding of accounting, receivables, and business finance.
Ability to connect marketing data with sales and overall business performance.
Experience investigating differences between platform-reported and actual business results.
Key Performance Indicators (KPIs)
Accuracy and timeliness of MIS, sales, collection, outstanding, and Meta Ads reports.
Quality and usefulness of management dashboards and insights.
Timely identification of business trends, data discrepancies, attribution issues, and tracking problems.
Accuracy of advertising-data reconciliation.
Improvement in campaign performance and advertising efficiency.
Effective monitoring and utilization of marketing budgets.
Ability to provide actionable business recommendations.
Ideal Candidate
We are looking for someone who is data-driven, responsible, proactive, and highly organized, with the ability to convert raw business and advertising data into meaningful information for management decision-making. The candidate should be capable of managing Meta Ads reporting while identifying misreporting, attribution issues, tracking discrepancies, and differences between platform results and actual business performance.
Experience: 1–3+ years preferred
Education: Graduate in any relevant field; candidates with backgrounds in Commerce, Business Administration, Statistics, Economics, Computer Applications, or related fields preferred.

Work arrangement
No