Understand business requirements in the BI context and design data models to convert raw data to meaningful insights
Create dashboards and visual interactive reports using Power BI
Identify KPIs with clear objectives and monitor them consistently
Understand business requirements to set functional specifications for reporting applications
Be experienced in tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, and PowerBI
Analyze data and present it through reports that can help in decision-making
Convert business requirements into technical specifications and decide the timeline to accomplish tasks
Design, develop, and deploy Power BI scripts and perform efficient detailed analysis
Perform DAX queries and functions in Power BI
Create charts and document data with algorithms, parameters, models, and relations explanations
Conduct data warehouse development
Perform SQL querying for best results
Use filters and graphs for a better understanding of the data
Define and design new systems by analyzing current ETL processes
Knowledge of database fundamentals such as multidimensional database design, relational database design, and more.
Requirements
BI tools : Skills in BI tools and BI systems, such as Power BI, SAP, Tableau, etc., creating data-rich dashboards, implementing Row-level Security (RLS) in Power BI, writing DAX expressions, developing custom BI products with scripting and programming languages such as R, Python, etc.
Experience in data-specific roles : A minimum experience of two or three years of experience working with BI tools or any data-specific role with a sound knowledge of database management, data modeling, business intelligence, SQL querying, data warehousing, and online analytical processing (OLAP)
Microsoft BI stack : In-depth understanding and experience with Microsoft BI stacks such as Power Pivot, SSIS, SSRS, and SSAS
Data analytics : The ability to drill down on data and visualize it in the best possible way through charts, reports, or dashboards
Software development skills : Understanding of software development architecture and technical aspects