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 :
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 BIExcellent Knowledge & hands on experience VBA (Visual Basic for Applications), SQL & Advance excel are requiredGraduate with 2-5 years' experience in Power BI, Advance Excel, VBA & SQLPrior experience in data-related tasksUnderstanding of the Microsoft BI StackBe familiar with MS SQL Server BI Stack tools and technologies, such as SSRS and TSQL, Power Query, MDX, Power BI, and DAXExposure in implementing row-level security and bookmarks.Analytical thinking for converting data into relevant reports and graphicsKnowledge of Power BI application security layer modelsAbility to run DAX queries on Power BI desktopProficient in doing advanced-level computations on the data setEnsure data and insights generated are maintained at high quality standards to meet stakeholder expectationsActive learning and complex problem solvingExcellent communication skills are required to communicate needs with client and internal teamsProven abilities to take initiative and be innovativeAnalytical mind with a problem-solving aptitudeTranslate business needs to technical specificationsOpen for feedback and learning opportunitiesCan work in metric driven system & work independently with onshore as per requirementPreferred :
Microsoft / Any other BI Certified Data Analyst
Skills Required
Data Analyst, Power Bi, Excel