APAC Power BI & SQL Developer
Dentsu
7 - 10 years
Bengaluru
Posted: 1/16/2025
Job Description
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:
BangaloreBrand:
DentsuTime Type:
Full timeContract Type:
PermanentAbout 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).