Senior Business operation Analyst (Power BI,Advance Excel)

About BU The Business Operations team brings together business solutions and latest technology to help empower our leaders with data-driven insights that enable better decision making. Primarily responsible for design, development and governance of the business data, the team measures, manages, and connects business KPIs across verticals to build a single view of impact areas within the organization. They augment our leaders with insights, strategic vision and actionable plans to function effectively. Equipped with data and technology, the team is keen on bringing novel business solutions to life. Why we are looking for you

• For having skills to contribute to development of company objectives and principles and to achieve goals in creative and effective ways
• For having advanced knowledge on Microsoft tools – Excel, Power BI, Sharepoint
• Able to create interactive dashboards in Excel or other visualization tools
• Automation experience in Excel VBA, Python and other AI tools
• Working experience in Power Platform
• Able to work on multiple projects simultaneously and manage time efficiently
• Have excellent analytical skills and deadline focused, detail oriented, well organized, and self-motivated
• Ability to connect the trends and perform predictive analysis
• Eager to learn new skills and technologies that enhance value to our stakeholders
• Able to gather requirements and translate to user stories
• Good communication skills (written & verbal) to communicate directly with global stakeholders
• Exceptional analytical skills; the ability to see patterns; and a structured and logical approach to decision making
• Ability to gather business requirements, create user stories, create project plan and drive project status meetings
• Good understanding of database structure and SQL
• Strong willed, a fast learner and able to work independently

• Interacting with various stakeholders and contribute efforts on building enterprise tools and processes
• Continuous learning and development on various tools like Power BI / Tableau, SQL, Business Objects, Power Platform, ETL Integration tools like SnapLogic and AI tools for automation
• Apply statistical knowledge using R, Python and SQL to define metrics and derive actionable insights
• Solve new challenges to meet changing business requirements, identify and implement process improvement areas and contribute towards web development.
• Open and transparent environment that values innovation and efficiency

• Design and develop executive dashboards on Power BI and Excel to present metrics and derive statical insights that enable management decision making
• Support BAU reporting activities to publish dashboards to stakeholders
• Manage data sets to ensure they are accurate, clean and ready for analysis and manage ETL process
• Automate process thru Python, Excel VBA or other automation tools
• Actively engage to identify, evaluate and recommend new metrics and automation tools
• Design prototypes using standard industry / company practices
• Gather and document requirements for the program in a structured manner
• Evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from underlying true needs
• Execute quantitative analysis that translates data into actionable insights.
• Own and drive work stream(s) within a program assigned and drive them to closure within defined timelines
• Escalate issues/risks in a timely manner and support in driving resolution
• Manage program and publish status report and dashboards for program sponsor and stakeholders
• Collaborate with various business stakeholders to understand data needs and deliver solutions to meet their requirements
• Train end-users and coach team members on BI development & other activities.

• MBA or similar degree or comparable experience
• 5 – 8 years professional experience in reporting, analytics or automation field
• Advanced experience in excel with ability to write complex formulas, build power queries, power pivots and create data models
• Expert in creating dashboards in Excel and Power BI, and develop tools from scratch
• Working knowledge on SQL, DAX queries, data modelling and ETL workflow
• Good knowledge on managing end-to-end workflow of dashboards and dataset on Power BI platform including RLS for data security
• Good to have additional skills on Power Platform tools, Python, Excel VBA, AI tools and emerging technologies
• Added advantage for candidates with Business Analysis skills to gather requirements and translate to user stories
• Experience in creating good visualizations that focuses on intuitive, user-friendly wireframes that enhances the user experience and enables quick decision making.
• Experience in business operations reporting, data analysis and similar role.
• Knowledge on SDLC, Agile practices and project management tools