Business Intelligence Analyst II

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.