Transforms operational and financial data into actionable insights through SQL analysis, MIS reporting, Power BI dashboards, KPI tracking, forecasting, automation, and process improvement. The role validates data, supports workforce planning, identifies performance trends and risks, develops management reports, and collaborates with operational teams to deliver decision-support solutions.
Assistant Manager – Business Analyst is responsible for transforming business data into actionable insights through reporting, dashboard development, data analysis, automation, and process improvement initiatives. The role supports operational leadership by delivering accurate analytics, forecasting, performance tracking, and decision-support tools to drive business outcomes.
Responsibilities- Analyze operational, productivity, quality, and financial data to identify trends and business insights.
- Develop and maintain interactive dashboards, scorecards, and KPI tracking reports for leadership.
- Create daily, weekly, monthly, and ad-hoc MIS reports to support business decision-making.
- Write and optimize SQL queries to extract, validate, and analyze data from multiple sources.
- Automate reporting processes using Excel Macros, VBA, Power Query, and other automation tools.
- Perform data validation, reconciliation, and quality checks to ensure reporting accuracy.
- Support workforce planning, forecasting, capacity analysis, and resource utilization reporting.
- Conduct root cause analysis and provide data-driven recommendations for performance improvement.
- Collaborate with Operations, Quality, Training, and Leadership teams to understand analytical requirements.
- Translate business requirements into reporting solutions, dashboards, and actionable insights.
- Identify opportunities for process improvement, standardization, and automation across business functions.
- Present performance trends, risks, and recommendations through management-ready reports and presentations.
- Maintain reporting documentation, metric definitions, and governance standards.
- Support audits, business reviews, and strategic initiatives through accurate and timely analytics
- Monitor key operational metrics and proactively highlight risks, gaps, and improvement opportunities.
Communication Skill:
Need to have active communication and interpersonal skills.
Working Hours:
Minimum 8 hours per day (can be vary as per the process requirement.)
Primary External Interactions- Based on the requirement.
- Advanced Excel (Macros, VBA, Power Query, Power Pivot)
- SQL (Joins, Stored Procedures, Views, Data Validation)
- Power BI Dashboard Development
- Data Visualization & Storytelling
- Forecasting & Capacity Planning Analytics
- Power Automate (Preferred)
- Basic Python/R (Good to Have)
EXL (NASDAQ: EXLS) is a leading data analytics and digital operations and solutions company. We partner with clients using a data and AI-led approach to reinvent business models, drive better business outcomes and unlock growth with speed. EXL harnesses the power of data, analytics, AI, and deep industry knowledge to transform operations for the world’s leading corporations in industries including insurance, healthcare, banking and financial services, media and retail, among others. EXL was founded in 1999 with the core values of innovation, collaboration, excellence, integrity and respect. We are headquartered in New York and have more than 54,000 employees spanning six continents. For more information, visit www.exlservice.com.
EXL Chennai, Tamil Nadu, IND Office
Chennai, India
Similar Jobs
Information Technology • Software
Supports business analysis, gathers reporting and dashboard requirements, translates requirements into specifications, and helps implement solutions using multiple data sources. Transitions completed reports to Operations & Support, assists with performance and availability, provides technical support and cross-training, and trains users on ad hoc reporting. Establishes technology best practices and repeatable processes while working with moderate to low supervision.
Top Skills:
Ad Hoc ReportingBusiness Intelligence Dashboards
Digital Media • Information Technology • News + Entertainment
Designs and customizes software applications, manages releases, gathers requirements, and improves functionality and user experience. Collaborates with stakeholders, QA, and cross-functional teams to deliver reliable solutions. Tracks performance metrics, maintains technical documentation, researches industry trends, and leads development, prototyping, and design sessions. Mentors junior engineers and exercises independent judgment while supporting variable work schedules.
Digital Media • Information Technology • News + Entertainment
Develops and optimizes data structures, ingestion frameworks, ETL pipelines, warehouses, and data lakes. Ensures data quality, governance, lineage, and compliance while supporting analytics and machine learning initiatives. Designs storage solutions across on-premises and cloud platforms, manages migrations, develops APIs, monitors data flows, collaborates with technology and analytics teams, and participates in code reviews and model deployments.
Top Skills:
Amazon RedshiftAPIsAws S3DatabricksETLKubernetesMinioTeradata
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
