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
About the company We are a value-driven consulting and engineering partner, helping companies to design and execute their most challenging digital transformations in the Cloud.Moving to the Cloud is merely the foundation of your digital transformation. Once migration is complete, we integrate cutting-edge technologies into all areas of your organisation to redefine the way you do business.Our aim is to take you on a Cloud-centric journey to unlock the value hidden in your data and compete in an increasingly competitive and connected world. We take an evidence-based approach to setting up your transformation, leveraging ProArch’s solution set to accelerate your time to value. Apply To This Job