Command Centre Analyst

Role & responsibilities:

The Power BI and Excel Reporting Analyst is responsible for developing and maintaining comprehensive reports and dashboards using Microsoft Power BI and Excel. This role will involve collecting and analyzing data, ensuring data accuracy, and providing actionable insights to support business decision-making processes.

• Report Development: Design, develop, and maintain Power BI and Excel reports and dashboards to meet business requirements
• Data Modeling: Create data models and perform data transformation using Power Query and DAX in Power BI, as well as advanced Excel functions and formulas.
• Data Integration: Integrate data from various sources such as SQL databases, Excel files, cloud services, and other business applications.
• Performance Optimization: Optimize report performance by fine-tuning data models, DAX queries, and Power BI/Excel settings.
• User Training: Provide training and support to end-users to help them understand and utilize Power BI and Excel reports and dashboards effectively.
• Collaboration: Work closely with business stakeholders to gather requirements, understand business processes, and ensure alignment of BI solutions with business needs.
• Documentation: Document report requirements, data models, and report specifications.
• Data Quality: Ensure data accuracy and integrity by implementing data validation and cleansing techniques.
• Troubleshooting: Identify and resolve issues related to Power BI and Excel reports and data discrepancies.
• Stay Current: Keep up to date with the latest trends and advancements in Power BI, Excel, and data analytics technologies
• Create, update and maintain reports in Power BI, Automate reports using VBA Macros and Develop and distribute contact center reports in accurate and timely manner.
• Ensure all periodic and ad hoc reports/dashboards are prepared as per stakeholder requirements and frequency.
• Update/Generate schedules using WFM tools, Create/Maintain SOPs and ID management: Update the

changes in role, attritions, new additions etc.

Preferred candidate profile

• 2 5 Years of experience in contact center reporting, data analysis, MIS and Power BI Tool.
• Should be amenable to work on different schedules (Day Shift, Mid Shift, Night Shift)
• Proficiency in Advanced Excel, SQL, VBA Macros, PowerBI
• Excellent Interpersonal skills with out of the box problem solving approach.
• Experience in developing dashboards and understandable reports using visualizations in Power BI