Data Analyst - Power BI

Embitel Technologies; Bengaluru; On-site; INR 800,000 - 1,100,000; Full time

Job summary

Embitel Technologies in Bengaluru is seeking a Data Analyst to transform complex datasets into meaningful business insights, develop interactive dashboards, and automate reporting processes using Power BI, Python, and SQL. The role focuses on data modeling, data validation, and delivering KPI dashboards to support data-driven decision making across functions.

Experience with DAX, Power Query, and Azure is a plus.

Qualifications

• Strong experience with Power BI Desktop and Power BI Service.
• Expertise in Python (Pandas, NumPy, Matplotlib, Seaborn).
• Strong SQL skills including Joins, CTEs, Window Functions, and Stored Procedures.
• Experience with DAX, Power Query, and data modeling.
• Good understanding of ETL processes and data transformation.
• Experience in dashboard development, KPI reporting, and business intelligence solutions.

Responsibilities

• Gather, analyze, and interpret large datasets to identify business trends and actionable insights.
• Design, develop, and maintain interactive dashboards and reports using Power BI.
• Build and optimize data models, DAX calculations, measures, and KPIs.
• Perform data extraction, transformation, and analysis using Python and SQL.
• Develop automated reporting solutions to improve operational efficiency.
• Partner with business stakeholders to understand reporting and analytics requirements.
• Conduct data validation, quality checks, and ensure data accuracy across reports.
• Create visualizations and executive dashboards for business performance tracking.
• Perform exploratory data analysis (EDA) and identify trends, anomalies, and opportunities.
• Document reporting processes, data definitions, and analytical methodologies.

Skills

Python

SQL

Excel

Data analysis

Education

Bachelor's Degree in CS/IT/Stats/Math/Engineering

Tools

Power BI

DAX

Power Query

Azure Data Platform

Databricks

Job description

Job Summary

We are seeking a highly analytical and detail-oriented Data Analyst with strong expertise in Power BI, Python, and SQL . The ideal candidate will be responsible for transforming complex datasets into meaningful business insights, developing interactive dashboards, automating reporting processes, and supporting data-driven decision-making across business functions.

Key Responsibilities

• Gather, analyze, and interpret large datasets to identify business trends and actionable insights.
• Design, develop, and maintain interactive dashboards and reports using Power BI .
• Build and optimize data models, DAX calculations, measures, and KPIs.
• Perform data extraction, transformation, and analysis using Python and SQL.
• Develop automated reporting solutions to improve operational efficiency.
• Partner with business stakeholders to understand reporting and analytics requirements.
• Conduct data validation, quality checks, and ensure data accuracy across reports.
• Create visualizations and executive dashboards for business performance tracking.
• Perform exploratory data analysis (EDA) and identify trends, anomalies, and opportunities.
• Document reporting processes, data definitions, and analytical methodologies.

Required Skills

• Strong experience in Power BI Desktop and Power BI Service
• Expertise in Python (Pandas, NumPy, Matplotlib, Seaborn)
• Strong SQL skills including Joins, CTEs, Window Functions, and Stored Procedures
• Experience with DAX , Power Query, and data modeling
• Good understanding of ETL processes and data transformation
• Experience in dashboard development, KPI reporting, and business intelligence solutions
• Advanced Excel skills (Pivot Tables, Power Query, Lookup Functions)
• Understanding of statistics and data analysis concepts

Nice to Have

• Experience with Azure Data Platform (Azure SQL, Azure Data Factory, Databricks)
• Knowledge of Machine Learning and predictive analytics
• Experience with Tableau or other visualization tools
• Exposure to cloud-based data warehousing solutions

Qualifications

• Bachelors Degree in Computer Science, Information Technology, Statistics, Mathematics, Engineering, or a related field.
• Relevant certifications in Power BI, Data Analytics, or Python are preferred.

Soft Skills

• Strong analytical and problem-solving abilities
• Excellent communication and stakeholder management skills
• Data storytelling and presentation skills
• Ability to work independently and collaboratively in a fast-paced environment

Preferred Experience

• Building executive and operational dashboards
• Business reporting and KPI management
• Data cleansing, transformation, and automation
• Cross-functional stakeholder collaboration
• Data-driven decision-making initiatives

Power BI, Python, SQL, DAX, Power Query, Pandas, NumPy, Dashboard Development, Data Visualization, Business Intelligence, Data Modeling, ETL, Reporting, Analytics, KPI, Azure, Databricks, Excel