Power BI Developer (Property & Casualty)

Job description

Key Responsibilities

• Design and build multi-page, interactive Power BI dashboards featuring drill-throughs, bookmarks, custom visuals, and role-based filters to deliver tailored, actionable insights for diverse business users.
• Develop complex DAX measures, calculated tables, and time-intelligence functions to support dynamic KPI reporting and scenario modeling directly within the Power BI data model.
• Leverage Power Query (M-Query) to perform advanced data transformations??such as unpivoting, merging, conditional logic, and parameterization??ensuring source data is cleansed and shaped for optimal dashboard performance.
• Configure and maintain on-premises or cloud Power BI Gateways, automate incremental and full refresh schedules, and troubleshoot connectivity issues to guarantee up-to-date reporting.
• Optimize report and data model performance through query folding, aggregation tables, star-schema design patterns, and best-practice visuals to minimize load times and enhance user experience.
• Partner closely with stakeholders to elicit requirements, design storyboard prototypes, and iterate on layouts and visuals based on user feedback and adoption metrics.
• Architect and implement end-to-end ETL pipelines in Azure Data Factory, orchestrating data ingestion, transformation, delivery, error handling, and monitoring for reliable data flows.
• Develop and maintain PySpark notebooks on Azure Databricks to execute complex KPI logic, data cleansing, and aggregation workflows, supplemented by SQL scripts to validate ETL outputs and reconcile key metrics.
• Provision, secure, and govern data in Azure Data Lake Storage Gen2 via Unity Catalog, managing access controls, data lineage, schema evolution, and audit trails in compliance with organizational policies.
• Operate within an Agile/Scrum framework??participating in sprint planning, daily stand-ups, backlog grooming, and retrospectives??and perform root cause analyses to identify data quality and performance issues, implementing preventive measures.

Required Qualifications

Technical Skills required:

• Power BI Desktop and Service, DAX, Power Query (M),
• Python, Apache PySpark, SQL (T-SQL, ANSI),
• Azure Data Factory, Databricks, ADLS Gen2, Unity Catalog, CI/CD tools (Git, Azure DevOps), data modeling, performance tuning.

Soft Skills required:

• Strong problem-solving skills and attention to detail.
• Excellent communication and collaboration skills.
• Adaptability to changing priorities,
• Collaboration in cross-functional teams,
• Time management, and a continuous-learning attitude.

If you are interested, please share your resume at [email protected]