The role
Job description
Job Title: Power BI & AI Analyst
Experience: 4-9 Years
Location: Pune (Hinjawadi)
Job Overview
We are looking for an experienced Power BI Developer with strong expertise in Power BI, SQL, DAX, Data Visualization, Dashboard Development, and Data Analysis. The candidate should have hands-on experience in developing interactive dashboards, writing complex DAX calculations, optimizing SQL queries, and managing ETL processes using AWS Glue.
The ideal candidate should be capable of working independently on end-to-end BI solutions, from data extraction and transformation to dashboard development and deployment.
Key Responsibilities
Develop, design, and maintain interactive Power BI dashboards and reports.
Create complex DAX measures, calculated columns, and KPIs.
Write and optimize SQL queries, joins, stored procedures, and data transformations.
Perform data analysis, data validation, and data modelling.
Implement data visualization best practices to deliver meaningful business insights.
Work on data extraction, transformation, and loading (ETL) processes using AWS Glue.
Integrate data from multiple sources into Power BI.
Optimize Power BI reports, datasets, and dashboard performance.
Work with stakeholders to understand business requirements and convert them into BI solutions.
Ensure data accuracy, consistency, and reliability across reports.
Mandatory Technical Skills
Power BI – Strong hands-on experience in dashboard and report development.
DAX – Experience writing complex measures, calculated columns, and time intelligence functions.
SQL – Strong knowledge of joins, CTEs, subqueries, window functions, and query optimization.
Data Visualization – Ability to create effective and interactive visualizations.
Dashboard Development – Experience building end-to-end business dashboards.
Data Analysis – Strong analytical and data interpretation skills.
AWS Glue – Hands-on experience in ETL development and data transformation.
Mandatory Experience Criteria
Minimum 4.5 years of relevant hands-on Power BI experience.
Candidates must have relevant experience in SQL and DAX.
Hands-on AWS Glue experience is mandatory.
Candidates should have practical experience in developing and maintaining Power BI dashboards.
Important: Candidates with less than 4.5 years of relevant Power BI experience should not be considered, irrespective of their total IT experience.