APAC Power BI & SQL Developer

Dentsu

7 - 10 years

Bengaluru

Posted: 1/16/2025

Job Description

The APAC Power BI & SQL Developer is a new key role within the APAC Enterprise Technology team. We are looking for a well-rounded Senior Power BI Developer with deep data visualization experience, and strong capability around DAX, SQL and data modelling techniques. This is a unique opportunity to be involved in delivering leading-edge business analytics using the latest and greatest cutting-edge BI tools, such as cloud-based databases, self-service analytics and leading visualisation tools enabling the company’s aim to become a fully digital organisation.

Job Description:

Key Responsibilities

  • Collaborate with the APAC Data Architect & Engineer to evaluate, design, develop BI semantic models and dashboarding solutions according to multi-market business requirements.
  • Transform large, complex datasets into presentable dashboards and reports for business decision-making.
  • Work closely with various stakeholders to understand their data needs and deliver solutions that meet them, defining implementation requirements and specifications, applying best practices of data modelling & dashboard design
  • Deliver technical documentation capturing metric definitions, descriptions of techniques, parameters, business rules, and relationships, including approach to acquire, clean, and transform data for reporting purposes.
  • Establish row-level security on data and comprehend Power BI's application security layer models.
  • Monitor Power BI Infrastructure and take steps to ensure efficient utilization
  • Work independently within guidelines, responsible for initiating, planning, executing, controlling, and implementation of projects using a formal project management and agile methodology
  • Coaching, mentoring, and providing technical direction and training to other BI Consumers
  • Working with BI & Analytic teams to develop and establish BI road Map/Vision
  • Stay updated with the latest Power BI features, updates, and best practices
  • Provide ad-hoc SQL development and reporting support for existing analytics and Power BI solutions across the APAC region where BAU support is needed, including SSRS and SSIS support, store procedures, basic SQL administration, uptime of data syncs

Qualifications

Experience:

  • 7-10 years of experience in Power BI Development, with demonstrable experience designing high-quality models and dashboards using Power BI, transforming raw data into meaningful insights
  • 5+ years experience using Power BI Desktop, DAX, Tabular Editor and related tools
  • 3+ Years experience using Power BI Premium capacity administration
  • 3+ Years SQL development experience
  • 3-5 years of experience in Data warehousing and Business Intelligence
  • Comprehensive understanding of data modelling, administration, and visualization
  • Detailed knowledge and understanding of Data warehousing conceptions, Azure Cloud databases, ETL (Extract, Transform, Load) framework

  • Familiarity with the Microsoft Fabric technologies including One Lake, Lakehouse and Data Factory
  • Excellent communication and stakeholder management skills
  • Being delivery-focused with a can-do attitude in a sometimes-challenging environment is essential.
  • Experience working with finance data highly desirable
  • Integration experience will be well regarded

Other key Competencies:

  • Strong communications skills and ability to turn business requirements into technical solutions
  • Strong database design skills, including an understanding of both normalised form and dimensional form databases.
  • In-depth knowledge and experience of data-warehousing strategies and techniques e.g., Kimble Data warehousing
  • Experience in Cloud based data integration tools like Azure Data Factory
  • Experience in Azure Dev Ops or JIRA is a plus
  • Experience working with finance data is highly desirable

Familiarity with agile development techniques and objectives

Location:

Bangalore

Brand:

Dentsu

Time Type:

Full time

Contract Type:

Permanent

About Company

Dentsu is a global advertising and digital marketing agency headquartered in Tokyo, Japan. It is part of the Dentsu Group Inc., one of the largest advertising and communications groups in the world. Dentsu specializes in providing integrated marketing solutions, including digital marketing, media planning, content creation, data analytics, public relations, and customer experience management. The company operates across numerous industries and markets, serving clients with innovative strategies to drive brand growth and engagement. With a strong focus on technology and creativity, Dentsu aims to deliver impactful, data-driven campaigns tailored to modern consumer behavior.

Services you might be interested in

One-Shot Campaign

Reach out to ideal employees in one shot!

The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).