Senior BI Analyst

ThoughtFocus; Hyderabad; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

ThoughtFocus seeks an experienced Senior BI Analyst to deliver high-impact Power BI dashboards and finance analytics. You will partner with Finance and leadership to translate requirements into scalable BI solutions using MySQL and MS SQL Server.

Deep FP&A knowledge, strong data modeling, and data governance are essential for driving decisions. You will design, implement, and optimize data models, automate reports, and provide insights through compelling data storytelling.

Qualifications

• 8+ years in BI/Data Analytics roles.
• Proficient in Power BI and SQL.
• Strong FP&A/Finance domain knowledge.

Responsibilities

• Develop, enhance, and maintain Power BI dashboards for Finance and FP&A.
• Build and optimize data models using DAX and Power Query.
• Extract, transform, and manage data from MySQL and MS SQL Server databases.
• Write complex SQL queries, stored procedures, and transformations for financial reporting.
• Support FP&A activities including budgeting, forecasting, and variance analysis.
• Translate business requirements from Finance into scalable BI solutions.
• Ensure data accuracy, validation, and governance across datasets.
• Collaborate with Finance and FP&A teams to define KPIs and reporting needs.
• Provide actionable insights to leadership through clear visualizations and storytelling.
• Identify gaps in financial reporting and propose BI-driven improvements.
• Automate recurring financial reports to drive efficiency.

Skills

Power BI

DAX

Power Query

Data Modeling

SQL (MySQL)

SQL Server

Finance FP&A

Budgeting

Tools

SQL Server

MySQL

Power BI Desktop

Job description

ThoughtFocus is a global IT services and solutions company with deep capabilities across Data & Analytics, Cloud, Modern Engineering, and Financial Services technology. Headquartered in the US with delivery centers in India, we partner with leading enterprises to build scalable, future-ready technology solutions. Our teams are built on a culture of ownership, expertise, and long-term client partnerships — and talent is at the heart of how we grow. - https://thoughtfocus.com/

Job Summary

We are seeking an experienced Senior BI Analyst with strong expertise in Power BI, MySQL, MSSQL, and a deep understanding of Finance and FP&A processes. The ideal candidate will partner closely with Finance and leadership teams to deliver high-impact dashboards, insights, and financial analytics to support strategic decision-making.

Key Responsibilities

• Develop, enhance, and maintain interactive Power BI dashboards and reports for Finance and FP&A teams.
• Build and optimize data models using DAX, Power Query, and BI best practices.
• Extract, transform, and manage data from MySQL and MS SQL Server databases.
• Write complex SQL queries, stored procedures, and transformations for financial reporting.
• Support FP&A activities including budgeting, forecasting, variance analysis, headcount analysis, and profitability reporting.
• Translate business requirements from Finance into scalable BI solutions and analytical data models.
• Ensure high levels of data accuracy, validation, and governance across financial datasets.
• Collaborate with Finance, Accounting, and FP&A teams to understand business processes, KPIs, and reporting needs.
• Provide actionable insights to Finance leadership through clear visualizations and data storytelling.
• Identify gaps or inefficiencies in financial reporting processes and recommend BI-driven improvements.
• Automate recurring financial reports and manual data processes to drive efficiency and accuracy.
• Document BI models, datasets, logic, and workflows for transparency and future reference.
• Work with cross-functional teams to align on data structures, business rules, and KPI definitions.

Required Skills & Qualifications

• 8+ years of experience as a BI Analyst, Data Analyst, or similar role.
• Strong expertise in Power BI (DAX, Power Query, Data Modeling).
• Advanced SQL skills in MySQL and MS SQL Server databases.
• Solid understanding of Finance and FP&A concepts, including budgeting, forecasting, margin analysis, variance analysis, and financial KPIs.
• Strong business understanding with ability to translate financial needs into BI solutions.
• Excellent problem-solving, analytical, and communication skills.
• Ability to partner with CFO, FP&A, and Finance teams effectively.

Experience in a fast-paced environment with end-to-end BI ownership.