Power BI Dashboard Developer / BI Engineer

Role Title: Power BI Dashboard Developer / BI Engineer

Programme: DMV — Data Management Revamping (Tactical Reporting Workstream)

Reporting To: Lead Architect / Programme Lead

Experience Required:3–6 years in BI development / analytics engineering

Engagement Type: Full-time, project-based (aligned to DMV programme timeline)

Role Overview

The DMV programme is repairing, building and automating a portfolio of 14+ priority Power BI dashboards (Acquisition, Collection, Persistency, ILP Valuation, Attrition, Onboarding Funnel, Cash-In, and others) while re-platforming reporting onto a governed AWS S3 / Snowflake data foundation. The Power BI Dashboard Developer owns end-to-end delivery of assigned dashboards — from data modeling and DAX development through UAT sign-off — and works closely with data engineering, business stakeholders, and the governance workstream to ensure every dashboard is accurate, reconciled, and production-ready.

Key Responsibilities

• Design and build Power BI dashboards and reports from governed Snowflake data sources, including data modeling, DAX measures, and Power Query transformations.
• Translate Business Requirement Documents (BRDs) and KPI definitions into accurate, performant dashboard logic — flagging ambiguous or incomplete requirements early to avoid downstream delays.
• Validate and reconcile dashboard outputs against authoritative source data before submitting for business review.
• Support the "first view" → business review → UAT → sign-off → production lifecycle for each assigned dashboard, and actively drive stakeholder sign-off rather than leaving it open.
• Apply row-level security, refresh scheduling, and performance optimization best practices for enterprise Power BI deployments.
• Collaborate with Data Engineering to ensure dashboards consume clean, tested, and documented Snowflake models (dbt-based) rather than ad hoc extracts.
• Maintain dashboard documentation: data lineage, KPI definitions used, refresh logic, and known limitations.
• Participate in Data Quality triage — investigate and help resolve discrepancies flagged during reconciliation or business review.
• Support re-platforming of existing dashboards from legacy/interim sources onto Snowflake as the primary source of truth.

Required Skills & Technical Experience

• Power BI (Desktop & Service): advanced DAX, Power Query (M), data modeling (star schema), Row-Level Security.
• Strong SQL — able to write and troubleshoot complex queries directly against Snowflake.
• Working knowledge of Snowflake (warehouses, roles/RBAC, performance tuning) and AWS S3 as a data source layer.
• Familiarity with dbt or similar transformation/modeling frameworks (able to consume and validate dbt-modeled datasets).
• Understanding of data quality and reconciliation practices — validating counts, values, and business logic against source systems.
• Experience working with CI/CD-deployed pipelines (e.g., GitLab) and troubleshooting service/pipeline issues that affect dashboard refreshes.
• Comfortable working from BRDs/KPI specifications and converting them into technical build requirements.
• Exposure to insurance or financial-services reporting (policy, premium, persistency, attrition, actuarial/ILP concepts) is a strong advantage given the current dashboard portfolio.

Experience Level

3–6 years of hands-on Power BI development experience, including at least one full re-platforming or migration engagement (legacy source → modern cloud warehouse). Prior experience in insurance, banking, or financial services reporting is preferred but not mandatory. Demonstrated experience owning dashboards through to business sign-off — not just build — is essential, given the current backlog of pending UAT approvals.

Soft Skills

• Strong stakeholder-management skills — able to proactively chase BRD clarifications and sign-offs rather than letting them stall.
• Comfortable working against fixed target-closure dates across multiple parallel dashboards.
• Clear written documentation habits — KPI logic, assumptions, and known gaps must be traceable, not tribal knowledge.
• Collaborative mindset — this role sits between business stakeholders, data engineering, and programme governance.

Success Measures for This Role

• Assigned dashboards move from "first view" to signed-off production within agreed target closure dates.
• No dashboard remains in an unresolved BRD or pending-sign-off state beyond 2 weeks without an escalated, documented reason.
• Dashboards are built against governed Snowflake sources, not manual extracts, by project completion.

Reconciliation discrepancies are identified and resolved before business review, not during UAT

Work Location: In person