Job description - VBA Developer MIS - Advanced Excel, VBA Scripting, Power Query, Power Automate Resource will be responsible for the overall design & deployment of Dashboard and its effective implementation. The individual will understand business problems and create solutions to address them leveraging multiple Platform and other data sources. The individual is also responsible for effectively delivering the results to the relevant stakeholders.
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. Perform queries and functions in both Power BI & Tableau. 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 SQL querying for best results, use of filters and graphs for better understanding of data. Work with users and team members at all level for performance improvement and suggestions.
Skills required: At least 4-5 years of experience using BI Tool in developing and publishing dashboards. Integrating with different data-sources such as relational/non-relational databases, 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 Python, VB Scripting, R, Power Automate, AZURE, Power BI
Qualifications