Internship (Business Analytics & Reporting)
Intas Pharmaceuticals · Ahmedabad, Gujarat, India
Posted 20 Nov 2026 · Internship
Job Description - Intern / Apprentice (Business Analytics & Reporting)
Position: Business Analytics Intern (6 Months Paid Internship) / Business Analytics Apprentice (11 Months Apprenticeship)
Location: Ahmedabad
Department: Business Analytics / HR Analytics / Commercial Excellence / Operations Analytics
Stipend: As per company norms
Eligibility: BCA / MCA (2026 & 2027 Pass-Outs)
About the Role
We are looking for enthusiastic and analytical BCA/MCA freshers who are passionate about data analysis, business reporting, and transforming data into meaningful insights. The selected candidates will work closely with business teams to create reports, dashboards, and data-driven solutions that support decision-making across various functions.
Key Responsibilities
- Analyze business data and generate actionable insights.
- Develop and maintain MIS reports using Advanced Microsoft Excel.
- Create interactive dashboards and reports using Power BI.
- Collect, clean, validate, and organize large datasets from multiple sources.
- Prepare weekly, monthly, and ad-hoc business reports.
- Monitor key performance indicators (KPIs) and performance metrics.
- Support automation initiatives through Excel formulas, Power Query, and reporting tools.
- Identify trends, patterns, and business opportunities through data analysis.
- Collaborate with stakeholders to understand reporting requirements.
- Present data findings through charts, graphs, and dashboards.
Required Skills
- Strong knowledge of Advanced Microsoft Excel, including:
- VLOOKUP/XLOOKUP
- Pivot Tables & Pivot Charts
- Conditional Formatting
- Data Validation
- Advanced Formulas and Functions
- Power Query (Preferred)
- Dashboard Creation
- Basic to Intermediate knowledge of Power BI:
- Data Modeling
- DAX Fundamentals
- Power Query
- Dashboard Development
- Report Publishing
- Basic understanding of:
- Data Analysis Techniques
- Business Intelligence Concepts
- Statistics and Data Interpretation
- SQL (Preferred)
- Data Visualization Best Practices
Soft Skills
- Strong analytical and problem-solving abilities.
- Attention to detail and accuracy.
- Good communication and presentation skills.
- Ability to work with large datasets.
- Quick learner with a proactive attitude.
- Team player with strong organizational skills.
Educational Qualification
- BCA or MCA from a recognized university.
- Freshers or candidates with up to 1 year of experience can apply.