Sr. PowerBI Analyst

• 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