Fresher- Business Analyst / Data Analyst (Internship+Job Opportunity)

Key Responsibilities

• Collect, consolidate and manage data from various internal systems, SaaS platforms, CRM/ERP modules, logs, and databases.
• Generate daily, weekly, monthly, and ad-hoc MIS reports and dashboards for operations, sales, finance, customer-support or other relevant teams.
• Use advanced Excel to build, maintain, and manage complex spreadsheets — including pivot tables, VLOOKUP / HLOOKUP / INDEX-MATCH, SUMIF/COUNTIF, conditional formatting, charts/graphs, macros/VBA (if needed) to automate routine reporting tasks.
• Validate and clean data — ensure data integrity, consistency; identify and rectify discrepancies or anomalies.
• Collaborate with cross-functional teams (product, operations, support, finance, sales) to understand their data/reporting needs and deliver appropriate reports/insights.
• Provide ad-hoc data analysis or custom reporting as required by management or US stakeholders.
• Maintain documentation of reporting processes, data definitions/SOPs, report templates, and standard workflows.
• Ensure timely delivery of reports — especially considering night-shift schedule — so that US-based stakeholders receive data at start of their business day.
• Identify opportunities for process improvement and automation to make MIS reporting more efficient and reliable.

Required Skills & Qualifications

• Bachelor’s degree (in IT, Computer Science, Business, Statistics, or related field) or equivalent.

• Strong proficiency in Microsoft Excel — including advanced formulas/functions (VLOOKUP/HLOOKUP/INDEX-MATCH), pivot tables, charts/graphs, conditional formatting, data cleaning, data validation.
• Ability to build and maintain dashboards/reports; comfortable using Excel for recurring and ad-hoc reports.
• Strong analytical and problem-solving skills; ability to work with large datasets, identify trends, anomalies, and draw insights.
• Good communication skills — ability to coordinate with different teams/stakeholders, understand requirements, and present data/insights clearly.
• Readiness for night-shift work from office; ability to work independently, meet deadlines and manage time effectively.

We are looking for a Lead – Information Systems who can combine strong Salesforce/CRM expertise, advanced Excel skills, MIS reporting and business analytics to support data-driven decision-making.

🔹 What We’re Looking For

• Minimum 4 years of hands-on experience with CRM systems, preferably Salesforce

• Minimum 3 years of practical Salesforce experience preferred

• Advanced proficiency in Microsoft Excel, including:

Advanced formulas, Pivot Tables, Power Query, Data analysis, Automation

• Strong experience in MIS reporting, data validation, analysis and presentation of insights

• Proven experience creating and maintaining dashboards, KPI reports and management reports

• Good technical aptitude with the ability to understand business processes and convert them into effective reporting solutions

• Basic to intermediate understanding of finance and business metrics, including revenue, costs, budgeting and financial reporting concepts

• Strong analytical and problem-solving skills

• Excellent stakeholder management and communication skills

• Ability to work independently and convert data into actionable business insights

🔹 Key Responsibilities

• Manage and analyze data from Salesforce/CRM and other business systems

• Develop and maintain MIS reports, dashboards and KPI trackers

• Ensure data accuracy, validation and consistency across reports

• Analyze business data and identify trends, gaps and opportunities

• Translate business requirements into meaningful reports and dashboards

• Work closely with business and functional stakeholders to understand reporting requirements

• Support management with timely and accurate business insights and performance reports

• Identify opportunities to improve reporting processes through Excel, Power Query and automation

• Support CRM-related reporting and process improvements

🎯 Ideal Candidate

Someone who is comfortable working at the intersection of CRM + MIS + Excel + Business Analytics, and can go beyond preparing reports to explain what the data means and what action the business should take.

This role will be permanent with NAM info and deploy to client location Hyderabad & Pune.

Work Mode: WORK FROM OFFICE

Role Descriptions:

• Perform detailed data analysis and support business decision-making
• Gather and document business requirements and translate them into technical specifications
• Work closely with stakeholders to define data needs and reporting requirements
• Create user stories, functional specifications, and support UAT activities
• Ensure alignment between business objectives and data solutions

Required Skills:

• Strong expertise in SQL and data querying
• Proven experience in data analysis, requirement gathering, and stakeholder management
• Ability to translate business requirements into technical solutions and user stories
• Good understanding of data models, reporting, and analytics concepts

Skills: Business Analysis~ORACLE SQL

Locations: ~HYDERABAD~PUNE~

Desire candidate

• Candidate should have valid PF.