Senior BI Analyst

Dentsu Aegis Network Ltd.; Hinoba-an; On-site; PHP 795,000 - 1,193,000; Full time

Job summary

Merkle in Bengaluru is seeking an experienced BI Analyst to design, develop, and maintain Power BI dashboards, translating business requirements into actionable insights. You will write optimized SQL queries, validate data, and build robust data models to support reporting across the organization.

The ideal candidate has 4+ years of Power BI experience, strong SQL skills, and familiarity with DAX, ETL processes, and stakeholder collaboration.

Qualifications

• 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 modeling concepts and DAX, and understanding ETL process & GITHUB.
• Experience in data validation, reconciliation, and quality assurance.

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

Data modelling

DAX

ETL

GITHUB

Dashboards

Data validation

Stakeholder management

Python

Education

Bachelor's degree

Tools

Databricks

Power Query

Power Query

GitHub

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

Permanent

About dentsu

For over 120 years, innovation has been a core tenet of our offering - exploring new ways to reach, engage and nurture relationships with audiences. Together we drive a multiplier effect for clients at a global scale, through the development of Integrated Growth Solutions that are underpinned by our promise to clients: innovating to impact. Be a force for good. Sustainability is a vital part of our business and an important area of focus for our clients. We're leading the way - helping to build a more sustainable planet. Dream loud. In this moment of transformation, we need our people to be fearless, embracing change and ambiguity, driven by the love for their work and excitement for the future. Team without limits. We create opportunities for connection and collaboration between our colleagues and clients, building a sense of belonging and having some fun along the way. Find out more about us