Power BI Developer
Take part in strategic insurance projects where data drives business decisions. Leverage your expertise in analytics, data modeling, Power BI, SQL, and Microsoft Fabric to support underwriting, reinsurance, claims, and risk reporting initiatives within a modern, collaborative, and fast-paced environment.
What is in it for you:
- Salaried: $46-56 per hour.
- Incorporated Business Rate: $55-65 per hour.
- 6-month contract with the potential for permanent employment.
- Day schedule, 37.50 hours per week.
- Hybrid work, with 3 days per week in the office.
Responsibilities:
- Analyze and document business processes related to insurance product development, underwriting assessments, risk scoring, reinsurance allocations, and claims adjudication workflows.
- Collaborate with actuarial, underwriting, risk, and claims teams to gather functional and non-functional requirements.
- Translate insurance risk rules into business requirements documents, functional specifications, 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.
- Support the development and enhancement of product and insurance risk frameworks aligned with regulatory expectations and internal governance requirements.
- Assist in mapping reinsurance treaties, ceded and assumed reinsurance rules, and integration touchpoints across policy administration, underwriting, and claims systems.
- Document reinsurance business processes, bordereaux reporting requirements, and quality assurance checkpoints.
- Develop source-to-target mappings for underwriting, reinsurance, and claims datasets across multiple systems.
- Support data quality validation, lineage documentation, and risk metric definitions.
- Perform SQL-based data analysis to support underwriting rules, reserving calculations, risk exposure reporting, and claims trend analysis.
- Work with Agile teams to design workflows, integrations, and platform enhancements supporting underwriting, reinsurance, and claims modernization initiatives.
- Participate in sprint planning, backlog refinement, and product grooming activities.
- Collaborate with architects and developers to validate technical feasibility and alignment with architectural standards.
- Act as a liaison between business stakeholders and technology delivery teams.
- Coordinate with third-party vendors to support integrations and system configuration activities.
- Facilitate workshops, requirements reviews, and user acceptance testing activities.
- Design and develop enterprise-scale Power BI solutions, including semantic models, dimensional models, complex DAX measures, calculation groups, and performance-optimized datasets.
- Manage Power BI Premium capacity and workspace architecture, including capacity planning, deployment pipelines, row-level security, and object-level security.
- Design and implement Microsoft Fabric analytics solutions, including Lakehouse and Warehouse modeling, Delta tables, medallion architecture, and semantic model integration.
- Optimize datasets for large-scale and near real-time analytics across insurance risk domains.
What you will need to succeed:
- Bachelor’s degree in Information Technology, Business Administration, Insurance, Risk Management, or a related field.
- Power BI certification from Microsoft is considered an asset.
- Professional certifications in Agile, Business Analysis, Insurance, or Risk Management are considered assets.
- Minimum of 5 years of relevant experience.
- Proven experience in Power BI development with current knowledge of the latest Power BI features and enhancements.
- Hands-on experience in business analysis activities and Power BI development.
- Strong expertise in SQL and DAX for data transformation, querying, and advanced calculations.
- Advanced knowledge of data modeling and the design of efficient, scalable semantic models.
- Strong data analysis skills with the ability to derive actionable insights from complex datasets.
- Experience implementing governance, security, controls, and performance optimization within Power BI environments.
- Experience with Microsoft Fabric and modern data modeling solutions.
- Experience coordinating with infrastructure teams on firewall configurations and secure data connectivity.
- Experience collaborating with data engineering teams to support data pipelines, connectivity, and performance optimization.
- Experience optimizing Power BI reports and dashboards to enhance performance and user experience.
- Experience working on multiple projects simultaneously.
- Experience working within cross-functional Agile teams.
- Knowledge of the insurance industry is considered an asset.
- Familiarity with insurance core systems, including Guidewire, Life and Health Policy Administration Systems, underwriting workbenches, or rating engines is considered an asset.
- Experience with data visualization tools such as Power BI and Tableau is considered an asset.
Why Recruit Action?
Recruit Action (agency permit: AP-2504511) provides recruitment services through quality support and a personalized approach. As part of the screening process, some applications may be reviewed using artificial intelligence tools. Only candidates who meet the hiring criteria will be contacted.
Pay: $46.00-$65.00 per hour
Benefits:
Application question(s):
- Do you hold a Bachelor's degree in Information Technology, Business Administration, Insurance, Risk Management, or a related field? If yes, please specify your degree and field of study.
- Are you comfortable working from the office 3 days per week?
- Do you hold any professional certifications in Agile, Business Analysis (CBAP, PMI-PBA), Insurance (CIP, LOMA), Risk Management (CRM, FRM), or Microsoft Power BI? If yes, please specify.
Education:
- Bachelor's Degree (preferred)
Experience:
- Power BI Developer: 5 years (required)
- Strong skills in SQL and DAX: 1 year (required)
- Expertise in data modeling and semantic models: 1 year (required)
- Strong data analysis capabilities: 1 year (required)
- Power BI governance, security, and performance optimization: 1 year (required)
- Insurance industry: 1 year (preferred)
- Guidewire (PolicyCenter, ClaimCenter, Reinsurance): 1 year (preferred)
- Policy Administration Systems (ALIP, Ingenium, OIPA): 1 year (preferred)
- Underwriting workbenches or rating engines: 1 year (preferred)
- Data visualization tools such as Power BI and Tableau: 1 year (preferred)
Work Location: Hybrid remote in Toronto, ON M4W 1E5
