Business Intelligence Analyst I, Technology

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

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: