HamburgerMenu
hirist

Data Analyst - DAX Power BI

MAGIC BLOOMS MEDIA PRIVATE LIMITED
Bangalore
1 - 5 Years

Posted on: 17/11/2025

Job Description

Description :


Key Responsibilities :


- Collect, clean, and process data from multiple sources to ensure accuracy and consistency.


- Perform Exploratory Data Analysis (EDA) to identify trends, patterns, and anomalies.


- Develop and maintain ETL pipelines to automate data ingestion, transformation, and loading processes.


- Write efficient SQL queries for data extraction, manipulation, and reporting.


- Utilize Python for data analysis, statistical modelling, automation, and advanced analytics tasks.


- Build interactive dashboards and reports using Power BI to present insights to stakeholders.


- Use Excel for data validation, pivot tables, advanced formulas, and quick analysis tasks.


- Collaborate with cross-functional teams (Product, Business, Operations, Technology) to understand data needs and deliver actionable insights.


- Assist in defining and tracking key performance indicators (KPIs) and business metrics.


- Ensure data quality, integrity, and security while working with sensitive information.


- Prepare clear and concise analytical reports, visualizations, and presentations for management.


Required Skills & Qualifications :


- Bachelors degree in Data Science, Computer Science, Statistics, Mathematics, Engineering, or a related field.


- 15 years of hands-on experience as a Data Analyst or in a similar role.


- Strong proficiency in:


- Python (Pandas, NumPy, data manipulation libraries)


- SQL (Joins, subqueries, window functions, optimization techniques)


- Excel (Advanced formulas, pivot tables, charts)


- EDA (statistical summaries, data profiling)


- ETL concepts and pipeline development


- Power BI (DAX, data modelling, dashboard creation)


- Solid understanding of relational databases and data warehousing concepts.


- Ability to translate complex data into understandable insights and business recommendations.


- Strong problem-solving abilities, attention to detail, and communication skills.


Preferred Qualifications (Optional) :


- Experience with cloud data platforms (AWS, Azure, GCP).


- Familiarity with version control tools such as Git.


- Exposure to machine learning fundamentals or predictive analytics


info-icon

Did you find something suspicious?