Business Intelligence Technical Lead
Job Location:
Monthly Salary:
Posted on:
21 days ago
Posted on:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
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: 37.50 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.
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.
Required Skills:
