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.

Experience: 7–10+ years | Industry Preference: Financial Services / BFSI

Role Overview

We are seeking a Senior Reporting Analyst / Business Intelligence Lead to own and drive

enterprise reporting, analytics, and data insights across the organization. This is a senior,

hands-on role requiring deep technical expertise across the Microsoft data and BI stack,

strong business acumen, and the ability to operate with minimal hand-holding. The ideal

candidate will act as a bridge between business leadership and technical teams, translating

complex business questions into scalable, reliable data models and executive-ready insights.

Key Responsibilities

 Serve as the primary owner of enterprise reporting and BI solutions, from data

ingestion through executive dashboards.

 Design, build, and maintain scalable Power BI / Microsoft Fabric semantic models using

STAR schema best practices.

 Partner closely with business stakeholders and C-level executives to define KPIs,

metrics, and reporting requirements.

 Lead and present weekly reporting and insights sessions with senior and executive

leadership.

 Ensure data accuracy, consistency, and trust across all reports and analytics outputs.

 Proactively identify data quality issues, root causes, and remediation strategies.

 Drive automation of reporting, alerts, and data refresh processes to reduce manual

effort.

 Collaborate with engineering, data, and application teams to align business logic with

source system data structures.

 Mentor junior analysts and establish BI standards, best practices, and documentation.

Technical Skills – Data & Backend

 Advanced SQL: complex queries, views, stored procedures, and validation against

source systems (RDN, Recovery Connect).

 Azure Data Factory: build and manage copy pipelines from SQL sources to data

warehouses / dedicated pools.

 Incremental refresh, parameterized pipelines, and schema replication.

 Data warehouse design: STAR schema, fact vs dimension tables, handling deleted

records and SCDs.

Technical Skills – Reporting & Frontend

 Power BI / Microsoft Fabric: Power Query, DAX, and M language expertise.

 Semantic model design (1-to-many, 1-to-1, many-to-1 relationships).

 Query folding and performance optimization best practices.

 Paginated Report Builder (SSRS-style) for automated Excel and PDF reporting.

 Power Automate integration for alerts and workflow-driven notifications.

Data Quality & Analytics

 Ability to clean, normalize, and reconcile data across multiple systems.

 Strong troubleshooting skills when business definitions and data do not align.

 Translate business terminology into accurate technical mappings and calculations.

Communication & Leadership

 Serve as a key liaison between business stakeholders and technical teams.

 Comfortable working directly with C-level executives and senior leadership.

 Ability to lead executive-level meetings and clearly communicate insights.

 Self-starter mindset with minimal hand-holding.

Qualifications

 7–10+ years of experience in BI, analytics, or enterprise reporting roles.

 Preferred experience in financial services or regulated environments.

 Strong experience across the Microsoft BI ecosystem.

Preferred Certifications

 Microsoft PL-300 (Power BI Data Analyst)

 Microsoft DP-600 (Fabric Analytics Engineer)

 Microsoft DP-700 (Fabric Data Engineer)

What Success Looks Like

 Executive leadership trusts and relies on BI dashboards for decisions.

 Reporting is automated, accurate, and scalable.

 BI functions as a strategic partner to the business.