Public Partnerships | PPL

BI Developer

11 October 2024
Apply Now
Deadline date:
£90000 - £110000 / year

Job Description

Key Responsibilities:

  • Collaborate with Data Engineers to design and build data models within Databricks SQL
  • Create optimized external tables for serving data from the Gold layer to BI tools.
  • Develop and maintain analytical datasets for enterprise reporting and self-service BI.
  • Design and develop Power BI reports and dashboards.
  • Enable business users to extract data through self-service extracts.
  • Implement row-level security (RLS) and column-level security (CLS) in Power BI.
  • Create compelling data visualizations using Power BI for enterprise analytics.
  • Ensure high performance of reports and dashboards through proper data modeling.
  • Automate the scheduling and publishing of Power BI reports.
  • Monitor and optimize Power BI datasets and dataflows for performance.
  • Work closely with business stakeholders to gather reporting requirements.
  • Document the data models, metrics, and KPI definitions.

Technical Skills:

  • Power BI (Dashboards, Reports, Dataflows).
  • SQL Server and Databricks SQL for building analytical models and queries.
  • Data Warehousing and ETL pipelines.
  • DAX and Power Query for advanced reporting.
  • Row-level security (RLS), column-level security (CLS).
  • Azure Data Factory and Databricks for orchestrating data pipelines.
  • Report automation, data scheduling, and self-service BI