01Key Responsibilities
AOP - Develop annual operating plans (AOP) & forecasts for all businesses, by PGs as per Corporate/ business calendar. Data Modelling & Architecture: Design robust semantic data models, define relationships, hierarchies, and KPIs that align with business rules and analytics goals. Data Transformation: Utilize Power Query (M) and SQL to cleanse, transform, and aggregate data from diverse sources including enterprise systems, data warehouses, and APIs. Visualization & Storytelling: Build insightful and interactive dashboards, reports, and visualizations in Power BI that translate complex data into clear, business-relevant narratives. Advanced Analytics: Develop and optimize complex DAX measures and time-intelligent calculations to support trend analysis, forecasting, and comparative insights (e.g., YoY, MTD, YTD). Collaboration: Partner with cross-functional stakeholders (business, IT, operations, and management) to gather requirements, understand pain points, and deliver tailored BI solutions. Performance Optimization: Monitor, troubleshoot, and enhance report performance and refresh schedules for high-volume datasets using Direct Query or Import modes. Governance & Documentation: Ensure compliance with data governance policies and maintain thorough documentation for data lineage, metrics definitions, and BI processes.
Required Skills and Qualifications.
Bachelor's of Commerce/ MBA. 3-5 years of FP&A experience Ability to work independently, exercise appropriate discretion and apply sound judgment with minimal direct supervision. Excellent time management and organizational skills. Strong inter-personal communication skills, written and verbal communication skills 3+ years of hands-on experience in Power BI developmen t, including data modellin g, Power Quer y, and advanced DA X Solid understanding of data warehousing concept s, ETL pipeline s, and relational database management system s (e.g., SQL Server, Oracle) Proficiency in SQ L for querying and transforming data across large datasets Strong analytical and problem-solving skills with a keen attention to detail Excellent communication skills to convey technical concepts and business insights effectively Experience working in Agil e environments and with tools like Jir a, or Confluenc e is advantageous. Tools and Technologies
Power BI Deskto p and Power BI Servic e (publishing, scheduling, and workspace management) Microsoft SQL Serve r (SSMS, SSIS, T-SQL) Power Query (M ) and DAX Excel (Power Pivot, Power Query Powerpoint .
