Public Partnerships | PPL
BI Developer
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