Senior BI Analyst

dentsu; New Delhi; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Merkle in Bengaluru is seeking a BI Analyst with 4+ years of Power BI and SQL experience to build end-to-end dashboards and provide actionable insights. You will translate business needs into reporting solutions, validate data, and collaborate with stakeholders to ensure accuracy and impact.

The role involves developing data models, DAX calculations, and maintaining dashboards while documenting data sources and validation steps. Full-time role in India.

Qualifications

• 4+ years of hands-on experience with Power BI and SQL.
• Ability to design end-to-end dashboards and reporting solutions.
• Knowledge of data modelling concepts and DAX, ETL concepts and GitHub.

Responsibilities

• Design, develop, and maintain interactive Power BI dashboards and reports.
• Gather and understand business requirements and translate them into reporting solutions.
• Write and optimize SQL queries for data extraction, analysis, and reporting.
• Perform data validation and quality checks to ensure accuracy and consistency of reports.
• Create and maintain data models, relationships, measures, and DAX calculations in Power BI.
• Collaborate with business stakeholders to identify reporting needs and provide analytical insights.
• Troubleshoot and resolve reporting and data-related issues.
• Document dashboard logic, data sources, and validation processes.

Skills

Power BI

SQL

Dashboards

DAX

Data modelling

Stakeholder mgmt

ETL concepts

Python basics

Education

Bachelor’s degree in Computer Science, Information Technology, Engineering, Statistics

Tools

Databricks

Power Query (M Language)

GitHub

Job description

Job Description:

Position: BI Analyst

Experience: 4-6 Years

Level : 30
Location : [Bangalore/Coimbatore/Pune/Mumbai]
Employment Type : Full-Time

Job Summary

We are seeking a detail-oriented BI Analyst with 4+ years of experience in Power BI and SQL. The ideal candidate should be capable of developing end-to-end dashboards, performing data analysis and validation, and transforming business requirements into actionable insights.

Key Responsibilities

• Design, develop, and maintain interactive Power BI dashboards and reports.
• Gather and understand business requirements and translate them into reporting solutions.
• Write and optimize SQL queries for data extraction, analysis, and reporting.
• Perform data validation and quality checks to ensure accuracy and consistency of reports.
• Create and maintain data models, relationships, measures, and DAX calculations in Power BI.
• Collaborate with business stakeholders to identify reporting needs and provide analytical insights.
• Troubleshoot and resolve reporting and data-related issues.
• Document dashboard logic, data sources, and validation processes.

Required Skills

• 4+ years of hands-on experience with Power BI.
• Strong knowledge of SQL for data extraction and analysis.
• Experience in developing end-to-end dashboards and reporting solutions.
• Good understanding of data modelling concepts and DAX, and understanding ETL process & GITHUB
• Experience in data validation, reconciliation, and quality assurance.
• Ability to analyze business requirements and convert them into meaningful visualizations.
• Strong problem-solving and analytical skills.
• Good communication and stakeholder management skills.

Nice to Have:

• Basic knowledge of Python
• Familiarity with Databricks
• Experience with Power Query (M Language).

Qualification

• Bachelor’s degree in Computer Science, Information Technology, Engineering, Statistics, or a related field.
• Relevant Power BI certifications are an added advantage.

Location:

DGS India - Bengaluru - Manyata N1 Block

Brand:

Merkle

Time Type:

Full time

Contract Type:

Consultant