Senior Analyst Business Intelligence

Allstate —Markham, ON3.6 

Ability to Lead multiple project streams and provide technical direction to BI Analyst on designing solution and automating complex batch processing.

Skills:

• Microsoft Powerpoint
• Microsoft Word
• Power BI
• Microsoft Excel
• SAS
• Relational databases
• Engineering
• Microsoft SQL Server
• Mathematics
• SSRS
• Finance
• SQL
• Analysis skills
• Math
• Bachelor’s

Accountabilities:

Design and develop solutions that will help you generate insights to be summarized and shared with our partners so they can better manage their business.

Create Power Bi reports and dashboards to identify, analyze, and interpret trends or patterns in complex data sets and provide Insights back to our Partners

Develop and implement databases, data collection systems, data analytics and other strategies that optimize overall efficiency and improve quality

Exceptional ability to visually present and communicate data, analyses, and findings

Ability to Lead multiple project streams and provide technical direction to BI Analyst on designing solution and automating complex batch processing.

Develop and Optimize SAS/SQL programs to create efficiency on run time.

Extensive knowledge and use of Microsoft SQL Server and all Microsoft services associated with SQL Server (SSIS, SSRS, and SSAS) is a plus but not required.

Qualifications & Experience:

University Degree (Math/Stats/Finance/engineering or similar) preferred

3-5 years of relevant experience is recommended (Marketing, Actuarial or Analytics)

At least 3 years of experience using Base SAS/EG, SAS Macro, SQL, Power Bi

Strong knowledge of Power Bi suite of Products and other visual analytics tools is a must

Sound knowledge of relational database structure

Collaborate with stakeholders to identify needs and opportunities to provide insights on how to better manage their business

Proficient in MS Word, Excel, and PowerPoint Experience with insurance/actuarial data will be considered a plus

申请链接： https://www.workopolis.com/search?q=sas&l=canada&s=d&job=POcj4a0QFFCJSSdPQ3bBwdUQsknD90wWOewmpejxMZB2LLTbESqCFLHOe84R-9L7