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 AWS 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.