Business Intelligence Developer, Health and Benefits Canada

• Perform data mining including predictive analytics and trends analysis
• Design, develop, and visualize reports and online dashboards
• Assist on creating a database that will store relevant data and/or a standalone data source
• Work directly with stakeholders and business analyst to understand and document requirements
• Create DAX scripts that will be used to calculate required metrics presented in dashboards
• Work closely with the database administrator, quality analyst, and stakeholders to ensure timely and accurate delivery of development work
• Support data collection, integration, testing, and troubleshooting of issues uncovered
• Create required project documentation and ensure that it is clear, concise, and accurate
• Participate in the development of a project roadmap and provide work estimate
• Comply with standards, best practices, and policies defined for the team

• Bachelor’s degree and 3+ years of related business intelligence and reports development experience and preferably held in the insurance industry.
• Intermediate proficiency with Microsoft Power BI
• 2+ years direct work experience with any of the BI tools: Tableau, Spotfire, PowerPivot or Microsoft SQL Server Reporting Services (SSRS).
• Experience in Microsoft SQL Server and Visual Studio
• Demonstrated proficiency with SQL and ability to develop queries
• Experience in data analysis, data modelling, and visualization.
• Experience with production support and troubleshooting common report / data process issues
• Experience developing reports, business requirement documentation, process flow diagrams, use cases and testing plans
• Ability to create presentation-ready visuals, mock-ups, charts, graphs and summary reports in tight timeframes and demonstrate effective presentation skill
• Knowledge of Microsoft productivity tools such as Excel, PowerPoint, as well as willingness to learn
• Microsoft Power Platform with Power Apps and Power Automate to create reporting solutions.
• Adapt to shifting priorities, multiple competing demands, ambiguity, and frequent change
• Display a willingness to learn new technologies and adapt to new business requirements
• Ability to learn and apply new information, skills, and processes quickly and build upon existing knowledge and skills
• Ability to organize time to meet project timelines and effectively find solutions to common business intelligence problems with minimal guidance
• Experience at working both independently and in a team-oriented, collaborative environment is essential, as well as having strong interpersonal skills
• Good communication skills and ability to collaborate with a global team
• Creative and critical thinking, having strong attention to detail
• Ability to effectively work on multiple projects simultaneously

WTW is an Equal Opportunity Employer