Associate Analyst Knowledge Services

As a Reporting Analytics professional with 5 years of experience, including 3 years of hands-on experience in Power BI, you will be responsible for participating in business requirements discussions with different operations teams. You should be a self-starter with the ability to work with minimal inputs and possess the skills to design Excel applications that interact robustly with users. Your role will also involve developing and maintaining Dashboards using Advanced Excel Formulas and charts. In addition to the above responsibilities, you will be required to develop and maintain Excel macros, Excel Access-based VB Script apps, web-based macros, and mainframe automation using VBA (Visual Basics for Applications). You will provide feasibility analysis for projects, document requirements post-completion, and offer support to end users once tools are deployed. To excel in this role, you should have a working knowledge of Advanced Excel graphs, dynamic graphs, 3-axis charts, Waterfall chart, and detailed knowledge of VBA and VB Scripts. Your ability to write complex SQL queries and experience with Python and JavaScript will be advantageous. Demonstrated experience in working on multiple applications integration with Excel is preferred. Proficiency in Excel, Access, MS PowerPoint, MS Outlook, Internet Explorer, Chrome Browsers, MS SQL, Oracle, and Teradata Databases is essential. Your expertise in Excel Charts, Pivots, Slicers, Excel formulas, Dashboard views, Index Match, Vlookup, Hlookup, Offset, named ranges, and nested loops will be highly valued. It is also important to have a good understanding of client-server architecture, along with strong interpersonal, analytical, and written communication skills. Preferred skills include a background in Analytics, which will further enhance your capabilities in this role.,