We are seeking a skilled Business Intelligence Analyst to construct and uphold analytics and reporting solutions that convert data into actionable insights. The BI Analyst role is pivotal, involving the conversion of provided data into meaningful insights through user-friendly dashboards and reports. An ideal BI Analyst possesses proficiency in Business Intelligence tools and technology, overseeing the creation and administration of BI tools with comprehensive knowledge of the BI system.

This role demands a grasp of business concepts, robust problem-solving abilities, and prior experience in data and business analysis. Analytical prowess and effective communication skills are highly valued attributes for this position.

The day-to-day responsibilities include but not limited to:

· Recognize business requirements in the context of BI and create data models to transform raw data into relevant insights

· Using Power BI, create dashboards and interactive visual reports

· Define key performance indicators (KPIs) with specific objectives and track them regularly

· Analyze data and display it in reports to aid decision-making

· Convert business needs into technical specifications and establish a timeframe for job completion

· Create, test, and deploy Power BI scripts, as well as execute efficient deep analysis

· Use Power BI to run DAX queries and functions

· Create charts and data documentation with explanations of algorithms, parameters, models, and relationships

· Construct a data warehouse

· Use SQL queries to get the best results

· Make technological adjustments to current BI systems to improve their performance

· For a better understanding of the data, use filters and visualizations





· Transform existing Non-Power BI Reports into dashboards

· Experience with custom/ third party visuals

Essential traits:

Minimum level of education required is BA/BS degree in computer science or other relevant educational or work experience; advanced degree is a plus

· Background with BI tools and systems especially Power BI

· Excellent Knowledge & hands on experience VBA (Visual Basic for Applications), SQL & Advance excel are required

· Graduate with 2-5 years' experience in Power BI, Advance Excel, VBA & SQL

· Prior experience in data-related tasks

· Understanding of the Microsoft BI Stack

· Be familiar with MS SQL Server BI Stack tools and technologies, such as SSRS and TSQL, Power Query, MDX, Power BI, and DAX

· Exposure in implementing row-level security and bookmarks.

· Analytical thinking for converting data into relevant reports and graphics

· Knowledge of Power BI application security layer models

· Ability to run DAX queries on Power BI desktop

· Proficient in doing advanced-level computations on the data set

· Ensure data and insights generated are maintained at high quality standards to meet stakeholder expectations

· Active learning and complex problem solving

· Excellent communication skills are required to communicate needs with client and internal teams

· Proven abilities to take initiative and be innovative

· Analytical mind with a problem-solving aptitude

· Translate business needs to technical specifications

· Open for feedback and learning opportunities

· Can work in metric driven system & work independently with onshore as per requirement

Preferred:

Microsoft/ Any other BI Certified Data Analyst

📌 Business Intelligence Analyst I, Technology (Mumbai)
🏢 Kroll Associates India Private
📍 Mumbai