Data Analyst

Overview

We are seeking a highly skilled Data Analyst to design, build, and maintain scalable business intelligence solutions for Finance. The ideal candidate will possess strong analytical acumen and hands-on expertise with the Microsoft BI stack to deliver actionable insights that drive data-informed decision-making across departments, including exposure to finance and financial planning and analysis (‘FP&A’) concepts such as forecast, actuals, variance analysis, etc.

Key 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 experienc
• eAbility 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 development, including data modelling, Power Query, and advanced DAX
• .Solid understanding of data warehousing concepts, ETL pipelines, and relational database management systems (e.g., SQL Server, Oracle)
• .Proficiency in SQL 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 Agile environments and with tools like Jira, or Confluence is advantageous

.Tools and Technologies

• :Power BI Desktop and Power BI Service (publishing, scheduling, and workspace management
• )Microsoft SQL Server (SSMS, SSIS, T-SQL
• )Power Query (M) and DA
• XExcel (Power Pivot, Power Query
• )Powerpoin

t