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, strong 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:

• Background with BI tools and systems especially Power BI
• Excellent Knowledge & hands on experience VBA (Visual Basic for Applications), SQL & Advance excel are required
• 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
• Preferably an MBA with 2-5 years’ experience in Power BI, Advance Excel, VBA & SQL
• 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

About Kroll

In a world of disruption and increasingly complex business challenges, our professionals bring truth into focus with the Kroll Lens. Our sharp analytical skills, paired with the latest technology, allow us to give our clients clarity—not just answers—in all areas of business. We value the diverse backgrounds and perspectives that enable us to think globally. As part of One team, One Kroll, you’ll contribute to a supportive and collaborative work environment that empowers you to excel.

Kroll is the premier global valuation and corporate finance advisor with expertise in complex valuation, disputes and investigations, M&A, restructuring, and compliance and regulatory consulting. Our professionals balance analytical skills, deep market insight and independence to help our clients make sound decisions. As an organization, we think globally—and encourage our people to do the same.

Kroll is committed to equal opportunity and diversity, and recruits people based on merit.

In order to be considered for a position, you must formally apply via careers.kroll.com

#LI-JC1