Business Intelligence Analyst – FP&A

Location: Chennai
Job Code: 423512
Experience: 3–8 Years
Band: BPO 2/3
Salary: Up to ₹9 LPA
Shift: 12:30 PM – 3:30 AM IST (as per business requirements)
Education: Bachelor's degree in Finance, Computer Science, or a related field. Minimum 15 years of regular, full-time education (10+2+3) is mandatory.

Job Summary

We are looking for a skilled Business Intelligence Analyst with strong expertise in SQL, data modeling, BI tools, advanced Excel, and data visualization. The ideal candidate will be responsible for designing and maintaining dashboards, analyzing business and financial data, automating reports, and delivering actionable insights to support strategic decision-making.

The role will work closely with Finance, Financial Planning & Analysis (FP&A), IT, and business stakeholders to support budgeting, forecasting, performance monitoring, and financial reporting. The candidate should have strong analytical and problem-solving skills, attention to detail, and the ability to translate complex datasets into meaningful business insights.

Key Responsibilities

• Design, develop, and maintain interactive BI dashboards, reports, and performance scorecards using Power BI, Tableau, or similar tools.

• Write and optimize complex SQL queries to extract, transform, validate, and analyze large datasets.

• Develop and maintain data models to support accurate, consistent, and efficient reporting.

• Analyze financial and operational data to identify trends, patterns, variances, and opportunities for business improvement.

• Support FP&A activities, including budgeting, forecasting, financial performance analysis, and KPI monitoring.

• Prepare reports and provide insights explaining business performance, key variances, and future trends.

• Collaborate with Finance, IT, and business stakeholders to understand reporting requirements and deliver suitable BI solutions.

• Ensure data accuracy, integrity, consistency, and reliability across dashboards and reporting systems.

• Automate recurring reports and improve reporting workflows to enhance efficiency and reduce manual effort.

• Apply advanced Excel functions, formulas, and data modeling techniques to support complex analysis.

• Support data integration and reporting requirements involving data warehouses and ETL processes.

• Build scenario-based analyses and performance reports to support management decisions.

• Document reporting processes, data definitions, business rules, and analytical methodologies.

Required Skills

• Strong proficiency in SQL, including complex queries, joins, aggregations, and data manipulation.

• Hands-on experience with data modeling and database concepts.

• Proficiency in Power BI, Tableau, or other business intelligence and reporting tools.

• Advanced Microsoft Excel skills, including formulas, lookups, pivot tables, and data analysis.

• Knowledge of data warehousing, ETL processes, and data integration.

• Strong data visualization and dashboard development capabilities.

• Understanding of financial reporting, budgeting, forecasting, variance analysis, and FP&A concepts.

• Excellent analytical, critical-thinking, and problem-solving skills.

• Strong communication skills and stakeholder management capabilities.

• High attention to detail and commitment to data quality.

Good-to-Have Skills

• Experience with DOMO or other BI and analytics platforms.

• Exposure to financial planning and analysis (FP&A) and management reporting.

• Experience in reporting automation and workflow optimization.

• Knowledge of KPI development, scenario modeling, and business performance analysis.

• Experience working with cross-functional Finance, IT, and business teams.

Educational Qualifications

• Bachelor's degree in Finance, Computer Science, Information Technology, Data Analytics, or a related discipline.

• Minimum 15 years of regular, full-time education (10+2+3) is mandatory.

Experience Requirements

• 3–8 years of relevant experience in Business Intelligence, Data Analytics, Reporting, or FP&A analytics.

• Strong hands-on experience in SQL, data modeling, and BI dashboard development.

• Practical experience in advanced Excel and data visualization.

• Experience supporting financial or business reporting processes is preferred.

Important Eligibility Criteria

• Ex-TCS employees are not eligible to apply.

• PAN and date of birth (DOB) are required for candidate profile creation.

• Candidates must be comfortable working in the specified shift schedule.

Ideal Candidate Profile

The ideal candidate will combine strong technical expertise in SQL, BI tools, Excel, and data modeling with a sound understanding of financial and business performance analysis. The candidate should be capable of converting complex data into actionable insights that support business planning, forecasting, reporting accuracy, and strategic decision-making.