Design high-performance data models optimized for reporting (Power BI / SSRS) purposes adhering to the enterprise architecture and data governance standards.
Expertise in every stage of project life cycles (Design, Analysis, Implementation and testing).
Research technical problems, analyse business requirements, evaluate alternative design approaches, and design technical processes to meet business requirements.
Estimate and document required work effort to develop, test and implement new technical processes/changes.
Coordinate with data engineers to create and manage stored procedures and views
Ensure to provide the viable long-term solutions for the relevant business data concerns
Provide technical support and mentor other team members in order to foster professional development.
Act as an ambassador for DP World at all times when working; promoting and demonstrating positive behaviours in harmony with DP World's Founder's Principles, values and culture; ensuring the highest level of safety is applied in all activities; understanding and following DP World's Code of Conduct and Ethics policies
JOB CONTEXT
Develop reports/dashboards using Power BI, SSRS, Power BI Report Builder
Responsible for creating reusable and scalable data models and/or OLAP cubes
Experience on working with underlying technologies such: Azure Data Lake, Azure SQL Database, Azure Databricks, Azure Analysis Service.
Should have an edge in making advance DAX queries/functions for the business queries.
Create and maintain KPI metrics and provide insight for sustained problem solving and predictive decision making.
Develop SQL Queries, Stored procedures, Optimize SQL Queries to support Power BI and paginated SSRS reports.
Manage Power BI Apps, Workspaces and User access.
Install and configure personal and enterprise Gateways on Power BI Service.
Implement row level security (RLS) on reports/dashboards and understand application security layer models in Power BI
Create Automated workflows using Power Automate to synchronize notifications/subscriptions.
Ability to work in an agile environment such as sprint planning and managing activities using Azure DevOps
Previous hands-on technical working experience with programming in Python / R
Qualification
QUALIFICATIONS, EXPERIENCE AND SKILLS
College/University Degree - preferable in Computer Science, Software Engineering
Power BI / Azure certifications will be an added advantage (PL-300 ,AZ-900 and/or AZ-204, AZ-303, AZ-304 or AZ-400).
Experience: 5 - 8 Years
Skills
Conceptual, logical, and physical data modelling proficiency
