MIS analyst

2 Minutes ago • 1-3 Years
Business Analysis

Job Description

CRED is an exclusive community for India’s most trustworthy and creditworthy individuals, rewarding good financial behavior. The MIS Analyst will design, develop, and maintain regular and ad-hoc reports, optimize SQL queries, manipulate data in Excel, build dashboards, and ensure data quality. This role involves collaborating with stakeholders, automating reporting processes, and supporting forecasting, all while maintaining data security.
Good To Have:
  • Knowledge of macros/VBA in Excel.
Must Have:
  • Design, develop, and maintain regular and ad-hoc reports.
  • Write and optimize SQL queries for data extraction.
  • Manipulate, clean, and transform datasets in Excel.
  • Build dashboards and visual presentations of data.
  • Identify data discrepancies and perform quality checks.
  • Collaborate with business stakeholders for reporting requirements.
  • Streamline and automate reporting processes.
  • Document report definitions, data sources, and logic.
  • Support forecasting and perform variance analyses.
  • Ensure data security and confidentiality.
  • Bachelor’s degree in a relevant field.
  • 1-3 years of experience in MIS reporting/data analysis.
  • Strong proficiency in SQL.
  • Advanced Microsoft Excel skills.
  • Good analytical thinking and attention to detail.
  • Ability to understand business processes and data flows.
  • Strong communication skills.
  • Ability to work under deadlines and prioritize tasks.
Perks:
  • Stacked, in-house pantry with lunch and dinner.
  • Paid sick leaves.
  • Comprehensive health insurance.
  • No fixed work timings.
  • Salaries before joining date.

Add these skills to join the top 1% applicants for this job

ms-office
communication
excel
forecasting-budgeting
game-texts
business-analysis
microsoft-excel
sql

what is CRED?

CRED is an exclusive community for India’s most trustworthy and creditworthy individuals, where the members are rewarded for good financial behavior.

CRED was born out of a need to bring back the focus on a long lost virtue, one of trust, the idea being to create a community centered around this virtue. a community that constantly strives to become more virtuous in this regard till they finally scale their behavior to create a utopia where being trustworthy is the norm and not the exception. to build a community like this requires a community of its own; a community special in its own way, working towards making this vision come true.

here’s a thought experiment: what do you get when you put a group of incredibly passionateand driven people and entrust them with the complete freedom to chase down their goals in a completely uninhibited manner? answer: you get something close to what we have at CRED; CRED just has it better.

here is what you will do when you join as a part of the team.

what will you do:

  • design, develop, and maintain regular reports (daily, weekly, monthly, quarterly) and ad‐hoc reports to track key performance indicators (KPIs)
  • write and optimize SQL queries to extract data from relational databases
  • manipulate, clean, transform datasets in Excel: using advanced formulas, pivot tables, macros/VBA (if applicable)
  • build dashboards or visual presentations of data to communicate insights in a clear & meaningful way
  • identify data discrepancies, perform data quality checks, troubleshoot data integrity issues
  • collaborate with business stakeholders (operations, finance, sales, etc.) to gather reporting requirements & translate into technical queries/reports
  • streamline and automate reporting processes to reduce manual effort (e.g. using script/VBA, SQL, ETL tools)
  • document report definitions, data sources, logic used in queries & calculations
  • support periodic forecasting or planning exercises if required; perform variance analyses
  • ensure security & confidentiality of data in reports as per company policies.

you should apply if you have:

  • bachelor’s degree in a relevant field (Information Systems, Computer Science, Finance, Statistics, Business Analytics, etc.)
  • proven experience (e.g. 1-3 years, or more for senior roles) in MIS reporting / data reporting/analyst role
  • strong proficiency in SQL: ability to write complex queries, joins, subqueries, aggregate functions, etc
  • advanced skills in Microsoft Excel: pivot tables, complex formulas (LOOKUPs, INDEX/MATCH, IFs etc.), charts, conditional formatting; knowledge of macros/VBA is a plus
  • good analytical thinking; attention to detail; ability to spot patterns, anomalies
  • ability to understand business processes & data flows; bridging between technical data and business meaning
  • strong communication skills: able to present insights, explain data, work with non‐technical stakeholders
  • ability to work under deadlines, prioritize multiple reporting tasks.

how is life at CRED?

working at CRED would instantly make you realize one thing: you are working with the best talent around you. not just in the role you occupy, but everywhere you go. talk to someone around you; most likely you will be talking to a singer, standup comic, artist, writer, an athlete, maybe a magician. at CRED people always have talent up their sleeves. with the right company, even conversations can be rejuvenating. at CRED, we guarantee a good company.

hard truths: pushing oneself comes with the role. and we realize pushing oneself is hard work. which is why CRED is in the continuous process of building an environment that helps the team rejuvenate oneself: included but not limited to a stacked, in-house pantry, with lunch and dinner provided for all the team members, paid sick leaves and a comprehensive health insurance.

to make things smoother and to make sure you spend time and energy only on the most important things, CRED strives to make every process transparent: there are no work timings because we do not believe in archaic methods of calculating productivity, your work should speak for you. there are no job designations because you will be expected to hold down roles that cannot be described in one word. since trust is a major virtue in the community we have built, we make it a point to highlight it in the community behind CRED: all our employees get their salaries before their joining date. a show of trust that speaks volumes because of the skin in the game. there are many more such eccentricities that make CRED what it is but that’s for one to discover. If you feel at home reading this, get in touch.

Set alerts for more jobs like MIS analyst
Set alerts for new jobs by Cred
Set alerts for new Business Analysis jobs in India
Set alerts for new jobs in India
Set alerts for Business Analysis (Remote) jobs

Contact Us
hello@outscal.com
Made in INDIA 💛💙