VBA Developer (4-6 yrs)_Chennai_CBD

Job Description

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 modelsChart creation and data documentation explaining algorithms, parameters, models, and relationsDesign, develop, test, and deploy scripts and perform detailed analyticsPerform queries and functions in both Power BI & TableauAnalyse current ETL process, define and design new systemsRedefine and make technical/strategic changes to enhance existing Business Intelligence systemsCreate customize charts and custom calculations as per requirementsDesign, develop and deploy business intelligence solutions as per needsSQL querying for best results, use of filters and graphs for better understanding of dataWork with users and team members at all level for performance improvement and suggestionsSkills requiredAt least 4-5 years of experience using BI Tool in developing and publishing dashboardsIntegrating 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 typesExpertise in using creating measures, calculated columns and performing advanced analysisUtilizing best practices to ensure optimized Data Models Good to havePythonVB ScriptingRPower AutomateAZUREPower BI Qualifications Bachelors Job Location