Power BI Analyst

Job Summary:

We are looking for a skilled Power BI Analyst with at least 3 years of experience in Power BI visualizations and a deep understanding of SQL. The ideal candidate will be responsible for creating interactive and insightful dashboards, optimizing data models, and ensuring data accuracy for business decision-making. This role requires strong analytical skills, business acumen, and the ability to transform complex datasets into meaningful insights.

Key Responsibilities:

Power BI Development & Visualization

· Design and develop interactive dashboards and reports in Power BI that provide actionable insights to business users.

· Optimize data models, measures, and DAX calculations for efficient performance and accurate reporting.

· Create visually compelling charts, graphs, and KPIs to enhance decision-making across various business functions.

· Ensure the accuracy and consistency of reports by implementing data validation and cleansing techniques.

· Work closely with stakeholders to understand business requirements and translate them into impactful data visualizations.

SQL & Data Management

· Write and optimize complex SQL queries to extract, manipulate, and analyse large datasets from multiple sources.

· Ensure data integrity by troubleshooting and resolving SQL-related issues.

· Assist in data modelling and ETL processes to improve the efficiency of data pipelines.

· Work with relational databases like SQL Server, PostgreSQL, MySQL, Snowflake, or Vertica.

Collaboration & Stakeholder Management

· Partner with business teams to gather reporting needs and translate them into data-driven insights.

· Provide training and support to business users on Power BI dashboard usage.

· Work closely with data engineers, analysts, and IT teams to enhance data availability and quality.

Qualifications & Experience:

Required:

· 3+ years of experience in Power BI development with strong expertise in DAX and Power Query.

· Proficiency in SQL with the ability to write and optimize complex queries.

· Strong understanding of data visualization best practices and dashboard performance optimization.

· Hands-on experience working with large datasets and relational databases.

· Experience integrating Power BI with different data sources (SQL Server, APIs, Excel, Cloud Data Warehouses, etc.).

Preferred:

· Experience with ETL tools, data modelling, and data warehousing concepts.

· Knowledge of Python or R for advanced data analysis (nice to have).

· Exposure to cloud platforms like Azure, AWS, or Google Cloud for data processing.

· Understanding of business intelligence (BI) and reporting frameworks.

Skills & Competencies:

Power BI Mastery – Expert in building interactive dashboards, reports, and data visualizations. SQL Expertise – Ability to handle complex queries and optimize database performance. Problem Solving – Strong analytical and critical thinking skills. Communication – Ability to explain technical insights to non-technical stakeholders. Attention to Detail – Ensuring accuracy and reliability in reporting. Business Acumen – Understanding business needs and translating them into data-driven solutions.