Data Analyst & Data Modeler – Bank/Finance - Power BI

Prior experience within the Banking or Financial Services sector is mandatory. Position Overview : We are seeking a highly skilled Data Analyst & Data Modeler with deep expertise in Product & Insurance Risk, specifically across Life & Health Insurance, Underwriting, Reinsurance, and Claims domains. This role focuses on designing enterprise-grade data models, analytics pipelines, and reporting solutions to support Insurance claims analytics, and regulatory reporting. The ideal candidate will combine strong data modeling and SQL expertise with advanced Power BI development skills, including Power BI Premium/Fabric architecture, Lakehouse, semantic modeling, and enterprise reporting design. Key Responsibilities : Insurance Risk Data Analysis & Modeling : • Analyze and document business processes for insurance product development, underwriting assessments, risk scoring, reinsurance allocations, and claims adjudication workflows. • Collaborate with actuarial, underwriting, risk, and claims teams to capture functional and non functional requirements. • Translate complex insurance risk rules into detailed Business Requirements Documents (BRDs), Functional Specifications (FSDs), and User Stories. • Analyze and model data related to insurance products, underwriting risk scores, reinsurance structures, and claims lifecycle events. • Develop conceptual, logical, and physical data models supporting insurance risk analytics and reporting layers. Risk Governance & Reinsurance Integration : • Support development and enhancement of Product & Insurance Risk frameworks that align with regulatory expectations and internal governance. • Assist in mapping reinsurance treaties, ceded and assumed reinsurance rules, and integration touchpoints across policy admin, underwriting, and claims systems. • Document reinsurance business processes, bordereaux reporting requirements, and quality assurance checkpoints. Data Mapping, Analytics & Reporting : • Develop source-to-target mappings for underwriting, reinsurance, and claims datasets across multiple systems (PAS, CRM, Rating Engines, Claims Platforms). • Support data quality checks, lineage documentation, and risk metric definitions (e.g., underwriting leakage, claims ratios, reinsurance, over retention). • Perform SQL-based data analysis to support underwriting rules, reserving calculations, risk exposure reporting, and claims trend analysis. Systems, Platforms & Agile Delivery : • Work with cross-functional Agile squads to design workflows, integrations, and platform enhancements supporting underwriting, reinsurance, or claims modernization. • Participate in sprint planning, backlog refinement, and product grooming sessions. • Collaborate with architects and developers to validate technical feasibility of requirements and ensure alignment with architectural patterns. Stakeholder & Vendor Engagement : • Serve as a primary liaison between business units (Underwriting, Actuarial, Claims, Reinsurance Operations) and IT delivery teams. • Coordinate with third-party vendors (reinsurance platforms, claims systems, fraud analytics tools, etc.) to support integration and system configuration activities. • Facilitate workshops, requirement walkthroughs, and UAT cycles to ensure clarity, completeness, and alignment. Advanced Power BI & Fabric Development : • Design and develop enterprise-scale Power BI solutions, including: • Semantic models (star schema, dimensional models) • Complex DAX measures and calculation groups • Multi-layered datasets optimized for performance • Build and manage Power BI Premium capacity and workspace architecture: • Capacity planning and optimization • Deployment pipelines (Dev/Test/Prod) • Row-level security (RLS) and object-level security (OLS) Microsoft Fabric & Modern Data Modeling : • Design and implement Fabric-based analytics solutions: • Lakehouse / Warehouse modeling • Delta tables and medallion architecture (Bronze/Silver/Gold layers) • Semantic model integration with Power BI • Optimize datasets for large-scale, near real-time analytics across insurance risk domains. Experience Summary : • Hands-on experience in both Business Analysis (BA) activities and Power BI development. • Strong knowledge of Power BI data modeling, including working with Microsoft Fabric. • Experienced in coordinating with infrastructure teams on firewall configurations and enabling secure data connectivity. • Collaborated closely with data engineering teams to ensure efficient data pipelines, connectivity, and performance optimization for Power BI solutions. • Skilled in optimizing Power BI reports and dashboards to improve user experience and performance for end users. Must-Have Skills : • Proven experience as a Power BI Developer, with up-to-date knowledge of the latest Power BI features and enhancements. • Strong proficiency in SQL and DAX for data transformation, querying, and advanced calculations. • Solid expertise in data modeling, including designing efficient and scalable semantic models. • Skilled in data analysis, with the ability to derive actionable insights from complex datasets. • Experience implementing and managing controls within Power BI, including governance, security, and performance optimization. Nice-to-Have Skills : • Domain experience in the insurance industry is an asset. • Familiarity with insurance core systems such as: • Guidewire (PolicyCenter, ClaimCenter, Reinsurance Management) • Life/Health Policy Administration Systems (e.g., ALIP, Ingenium, OIPA) • Underwriting workbenches or rating engines • Experience with data visualization tools such as Power BI and Tableau. Years of Experience : • 5+ years of experience Education & Certifications : • Bachelor’s degree in Information Technology, Business Administration, Insurance, Risk Management, or related field. • Nice to have: • Professional certifications in Agile, Business Analysis (CBAP/PMI-PBA), Insurance (CIP/LOMA), or Risk Management (CRM/FRM). • Power BI certification (Microsoft Certifications). Candidate Requirements : • Must have strong, hands-on expertise in Power BI, including thorough knowledge of the latest features and updates. • Candidates with only basic or limited Power BI experience will not be considered. • Requires deep expertise in advanced data modeling and building efficient, scalable semantic models. • Must be a Power BI and data modeling specialist, capable of designing optimized, high-performance reporting solutions. The expected base salary range for this position is $50 – $60 per hour, depending on experience, skills, and internal equity. The Company offers a total rewards package in accordance with all applicable federal, provincial, and local laws and requirements. Benefit eligibility and offerings vary based on role, employment status, and work location. For contractor positions, benefits are limited to those entitlements and protections required by applicable law, which may include (as applicable) vacation pay, public holidays, leaves of absence, and other legally mandated benefits or payments. We may use AI-enabled and/or automated tools to support parts of our recruitment process, including application screening, interview scheduling, and candidate communications. These tools are used to enhance consistency and efficiency. All hiring decisions involve human review and are not based solely on automated processing.

Want to see how well you match this job?