Roles & Responsibilities:
• Design and develop interactive dashboards and reports in Power BI to support business performance tracking and decision-making.
• Build efficient data models using Power BI and Power Query to ensure optimal report performance and scalability.
• Write DAX formulas to create calculated columns, measures, and custom calculations to enhance reporting capabilities.
• Write and optimize SQL queries to extract, transform, and load data from SQL Server into Power BI for analysis and reporting.
• Implement best practices in data visualization to ensure clear, effective, & visually appealing presentation of data. Deliver actionable insights through storytelling techniques.
• Analyze and interpret complex data sets to identify trends, anomalies, and insights that can drive business decisions.
• Work closely with cross-functional teams to understand business requirements and translate them into effective reports and dashboards. Present insights and recommendations to stakeholders.
• Perform ad-hoc analysis in Excel as and when required.
• Stay up to date with the latest developments in Power BI, SQL, and data analytics.
• Identify opportunities to improve processes, enhance tools, and automate tasks.
• Use Python for data automation, cleansing, and advanced analytics tasks as needed.
• Regularly conduct dashboard & report maintenance to ensure the data accuracy of the reports.
• Create and maintain documentation including requirements, design and user manuals. Required Skills and Experience:
• Minimum 1.5 years of experience with Power BI, including proficiency in data modeling,
• Power Query, DAX, and data visualization.
• Minimum 1 year of experience with SQL for data extraction and manipulation.
• Advanced Excel skills.
• Practical knowledge of Python.
• Strong analytical and problem-solving skills.
• Excellent communication and interpersonal skills.
• Ability to work independently and as part of a team.
• Curiosity and a passion for learning new technologies.