MIS Analyst

Affine is looking for a MIS Analyst to join its Pimpri-Chinchwad team. You will turn raw operational data into clear, trustworthy analysis, and work directly with the people who use it to run the business. About the role This MIS Analyst role is hands-on and delivery-focused. Expect to spend your time producing accurate MIS and automating the recurring reporting cycle, working primarily in Advanced Excel, SQL and Power BI. You will own your outputs end to end — from the data pull and the sanity checks to the final recommendation. Key responsibilities • Prepare daily, weekly and monthly MIS for business functions • Automate recurring reports with Excel, SQL and Power BI • Validate data accuracy and reconcile against source systems • Maintain reporting trackers and management dashboards • Handle ad-hoc data requests within agreed turnaround • Validate and reconcile numbers before they are published, and document known data caveats • Automate recurring reporting so the team spends its time on analysis rather than refreshes • Present findings to non-technical stakeholders in clear, plain language Required skills and tools • Advanced Excel • SQL • Power BI • MIS Reporting • VBA / Macros • Pivot Tables • Data Cleaning • Report Automation • Data Validation • Google Sheets • Attention to Detail • Communication Eligibility criteria • Education: B.Com/BBA/B.Sc/BCA/B.E./B.Tech/MBA or an equivalent degree. Candidates from any recognised university are welcome. • Graduation year: 2023–2026 batches. Freshers and final-year students awaiting results may apply. • Minimum 60% / 6.0 CGPA in the highest qualification (indicative — strong practical skills can offset this). • Experience: 0–3 years in analytics, reporting, MIS or a closely related function. • Technical skills: Advanced Excel, SQL, Power BI, MIS Reporting, VBA / Macros, Pivot Tables. • Soft skills: structured thinking, attention to detail, stakeholder communication, ownership and the confidence to flag a number that looks wrong. Salary and compensation • Annual CTC: ₹2,60,000 – ₹5,70,000 per year (2.6 LPA – 5.7 LPA), an indicative market range for this role in Pimpri-Chinchwad. • Monthly equivalent: approximately ₹35,000 per month at the mid-point of the range. • Currency: INR (₹). • Performance bonus / variable pay as per Affine's policy, reviewed annually. • The exact offer is confirmed by Affine based on your interview performance and current compensation. Perks and benefits • Annual performance bonus / variable pay • Health insurance for you and your dependants • Provident Fund and statutory benefits • Structured onboarding and mentorship • Learning & certification support (SQL, Power BI, Tableau, cloud) • Paid leaves and public holidays • Flexible / hybrid working options • Modern analytics tooling and licensed BI seats Location, work mode and employment type • Location: Pimpri-Chinchwad, Maharashtra • Work mode: Hybrid • Employment type: Full-time, permanent • Working hours: 10:00 AM – 7:00 PM, Monday to Friday • Number of openings: 3 • Joining: immediate to 60 days, as per your notice period Selection process • Round 1 — Resume screening and profile shortlisting by the talent acquisition team • Round 2 — Technical interview 1 — SQL joins, aggregations, window functions and data modelling • Round 3 — Case study / take-home assignment on a real dataset, with a walkthrough of your approach • Round 4 — HR discussion — compensation, notice period, joining date and offer roll-out Who should apply Candidates from B.Com/BBA/B.Sc/BCA/B.E./B.Tech/MBA or an equivalent degree with up to 3 years of relevant experience who are based in Pimpri-Chinchwad or willing to relocate. You should be comfortable with Advanced Excel, SQL, Power BI and able to explain your analysis to someone who has never seen the data. Portfolio projects, Kaggle work, a GitHub repo or published dashboards strengthen an application, especially for early-career candidates. Why join Affine Working at Affine means modern tooling, clean processes and colleagues who will review your logic properly. Analysts here grow into senior, lead and specialist tracks. High performers move into senior and lead analyst roles, take ownership of a business vertical, or specialise in data science, data engineering or product analytics. You will leave every year of this role with a reporting cycle that runs itself instead of eating your week. About this employer — Established mid-size company Affine is an established company in Technology — big enough to run a real data function with proper tooling, small enough that your work is visible to the people who use it. Interns here typically sit close to the team that owns the numbers and get answers without going through three layers. How to apply Click Apply Now. If you are not signed in you will be asked to log in or create a free MyInternships.in candidate account first, after which you will be taken directly to Affine's official careers page to submit your application. Applications close on 24 September 2026 and are reviewed on a rolling basis, so apply early. Additional information • Documents required at the interview stage: updated resume, degree certificates or provisional certificate, and government photo ID. • Experienced candidates should also carry recent payslips and a relieving or experience letter. • There is no service bond for this position, and no equipment deposit is taken. • A laptop and licensed analytics tooling are provided by Affine for office and hybrid roles. • Affine and MyInternships.in never charge a fee at any stage of the application, selection or onboarding process. If anyone asks you for money in the name of this job, do not pay — report it. Responsibilities: Prepare daily, weekly and monthly MIS for business functions; Automate recurring reports with Excel, SQL and Power BI; Validate data accuracy and reconcile against source systems; Maintain reporting trackers and management dashboards; Handle ad-hoc data requests within agreed turnaround; Validate and reconcile numbers before publishing, and document data caveats; Automate recurring reporting to free up time for real analysis; Present findings clearly to non-technical stakeholders. Requirements: B.Com/BBA/B.Sc/BCA/B.E./B.Tech/MBA or an equivalent degree from a recognised university; 0–3 years of experience in analytics, reporting or MIS — freshers and 2026 graduates are welcome; Working knowledge of Advanced Excel, SQL, Power BI; Comfort with Advanced Excel, SQL and Power BI and with cleaning messy, real-world data; Ability to define a metric precisely and explain a result to a non-technical stakeholder; Attention to detail, ownership and the discipline to document your work; Based in Pimpri-Chinchwad, Maharashtra or willing to relocate.