• 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

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.