Job Description

Role & 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. Preferred candidate profile • Minimum 3+ 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.