- 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
