The APAC Power BI & SQL Developer is a new key role within the APAC Enterprise Technology team. We are looking for a wellrounded 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 leadingedge business analytics using the latest and greatest cuttingedge BI tools such as cloudbased databases selfservice analytics and leading visualisation tools enabling the companys 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 multimarket business requirements.
- Transform large complex datasets into presentable dashboards and reports for business decisionmaking.
- 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 rowlevel security on data and comprehend Power BIs 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 adhoc 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:
- 710 years of experience in Power BI Development with demonstrable experience designing highquality 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
- 35 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 deliveryfocused with a cando attitude in a sometimeschallenging 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.
- Indepth knowledge and experience of datawarehousing 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