Business Intelligence Technical Lead

Business Intelligence Technical Lead
Shape impactful business intelligence solutions in a fast-paced insurance environment where data, innovation, and collaboration drive decision-making. This hybrid opportunity offers exposure to enterprise analytics initiatives, modern BI technologies, dashboard development, automation projects, and close collaboration with cross-functional and leadership teams.
What is in it for you:
•Salaried: $50-65 per hour.
• Incorporated Business Rate: $65-80 per hour.
• 7-month contract.
• Full-time position: hours per week.
• Schedule from 9 am to 5 pm.
• Hybrid: 3 days/week in Toronto office.
Responsibilities:
• Develop and maintain BI reports, dashboards, data pipelines, and automations using Power Platforms.
• Attend to the complex design and development of business intelligence tools based on specifications.
• Mentor, train, and provide technical guidance on dashboarding and business intelligence requirements.
• Work closely with project teams to understand solutions, define estimates, and recommend solution approaches.
• Present insights and recommendations to leadership teams to support decision-making.
• Conduct code reviews, script analysis, optimization, and testing of reporting automations and business intelligence solutions.
• Manage BI platforms, including system updates, troubleshooting, and performance optimization.
• Stay updated on business intelligence trends and incorporate design and development best practices.
• Enforce data quality and consistency by implementing business standards and audit checks.
• Research and develop process and technical improvements for existing solutions and emerging technologies.
• Collaborate with COEs and cross-functional teams, including business analysts, developers, and stakeholders, to understand reporting requirements.
• Monitor tasks of the solutioning team and ensure timely completion of deliverables.
• Gather data from various sources, including databases, spreadsheets, logs, and external datasets.
• Develop and maintain data pipelines, automations, and reporting solutions, including Power Platforms.
• Convert raw data into formats suitable for analysis through data cleansing, normalization, transformation, and modeling.
• Develop apps and automated workflows as part of reporting solutions.
• Develop reports and dashboards to present data in a visually understandable manner and provide actionable insights.
• Track and report key performance indicators (KPIs) to measure business success.
• Conduct team performance reviews and knowledge check-ins.
• Create project estimates and business solutioning proposals.
• Review existing processes and documentation consistently.
• Create and execute business process improvements.
What you will need to succeed:
• SQL proficiency, including complex queries, joins, CTEs, window functions, aggregations, performance tuning, and familiarity with stored procedures/views.
• Experience connecting to SQL Server, Azure SQL/Databricks, JIRA (via REST APIs, OData, or connectors like Atlassian/JIRA content packs), Excel/CSV, SharePoint, SAP, etc.
• Understanding of ETL/ELT fundamentals, including designing reliable pipelines, incremental refresh, handling late-arriving data, and data quality checks.
• Experience with Power Query (M), including transformations, custom functions, parameterized queries, merging/appending tables, and error handling.
• Knowledge of dimensional modeling, including Star/Snowflake schemas, fact/dimension tables, surrogate keys, SCD handling, and conformed dimensions.
• Experience with Power BI data modeling, including relationships, cardinality, bidirectional filters, role-playing dimensions, and calculation groups.
• DAX expertise, including measures vs calculated columns, time intelligence (YTD/MTD/QTD, rolling periods), filter context vs row context, CALCULATE/KEEPFILTERS, virtual tables (SUMMARIZE/ADDCOLUMNS), iterators (X functions), segmentation, and KPI logic.
• Experience with performance optimization techniques, including VertiPaq storage concepts, minimizing model size, using variables, optimizing DAX, avoiding high-cardinality columns, and using aggregations.
• Financial and JIRA domain knowledge considered an asset.
• Understanding of KPIs and metrics, including revenue, expense, margin, run-rate, cash flow, ROI, NPV, cohort analysis, and trend analysis.
• Experience working with JIRA data, including issue fields, workflows, sprints/boards, epics/stories, custom fields, velocity, burn-down/up, lead/cycle time, and throughput metrics.
• Visualization and UX skills within Power BI environments.
• Experience designing reports with clear layouts, consistent theming, bookmarks, drill-through/drill-down functionality, tooltips, and small multiples.
• Data storytelling skills, including selecting appropriate visuals and presenting actionable insights.
• Knowledge of accessibility and usability best practices, including color contrast, keyboard navigation, alt text, and clutter reduction.
• Experience with Power BI administration, including gateway configuration, refresh schedules, capacity management (Pro vs Premium), usage monitoring, and endorsements.
• Experience with APIs and scripting, including Power BI REST API, JIRA REST API, PowerShell, or Python for orchestration and automation.
• Experience with Power Platform tools, including Power Automate workflows and integrations with Teams and SharePoint.
• Experience with Dataflows & Fabr.