Report automation Developer

Skills – Power BI, SharePoint List, Power Automate, Advanced Excel, Power Query, SQL

BI developer needs to use SharePoint list as a data source by connecting to it with a tool like Power BI Desktop to create reports and dashboards. The process involves getting the SharePoint site URL, selecting the "SharePoint Online List" connector in Power BI, authenticating, and then loading and transforming the data. The developer can then build visualizations.

Roles & Responsibilities -

• Understand business requirements in Business context and design data models to transform raw data into meaningful insights.
• Create dashboards and interactive visual reports using BI Tools etc.
• Identify key performance indicators (KPIs) with clear objectives and consistently monitoring.
• Analysing data and present data through reports that aid decision-making.
• Convert business requirements into technical specifications and decide timeline to accomplish.
• Create relationships between data and develop tabular and other multidimensional data models
• Chart creation and data documentation explaining algorithms, parameters, models, and relations
• Design, develop, test, and deploy scripts and perform detailed analytics
• Analyse current ETL process, define and design new systems
• Redefine and make technical/strategic changes to enhance existing Business Intelligence systems
• Create customize charts and custom calculations as per requirements
• Design, develop and deploy business intelligence solutions as per needs

Skills required

• At least 6-7 years of experience using BI Tool in developing and publishing dashboards
• Integrating with different data-sources such as relational/non-relational databases, SharePoint, One drive, Cloud components etc.
• Familiar with a wide variety of standard and community-sourced chart types
• Expertise in using creating measures, calculated columns and performing advanced analysis
• Utilizing best practices to ensure optimized Data Models

Good to have

1. Python
2. VB Scripting