Data Analyst

We are looking for a Data Analyst! Reach out if you are interested and feel free to refer friends/colleagues!

Type of Employment: Contract
Title: Data Analyst
Term: 12 months contract with extension
Location: Toronto – Hybrid once or twice a week on-site
Job ID number: C1259

Brief Description of Duties:

• Work directly with data engineers, business data analysts, data scientists and clients in Canadian Operations throughout the entire engagement life cycle including technical analysis, design, development, implementation and consulting efforts
• Maintain best practice standards for analysis and reporting at all levels including data governance, documentation, testing and visualization techniques
• Lead and drive projects and assignments to completion, including project planning and estimates
• Lead consultants in the team on various analytics projects
• Facilitate group meetings of various sizes for solution design, decision making, problem-solving and solution implementation.
• Turn complex data into easy to understand visual insights that are aligned to business objectives
• Enable visual storytelling through Tableau and visual analytics tools
• Perform quality assurance and testing according to risk assessment guidelines to minimize operational, reputation, and legal risk.
• Act as principal designer and reviewer for new data models, make data architectural decision, and provide coaching on data modeling and process design
• Expand and grow data existing platform capabilities to solve new data problems and challenges
• Ensure all automated processes preserve data integrity by managing the alignment of data availability and integration processes
• Support quantitative analysts and data scientists with data discovery and rapid assembly of large data sets from disparate sources
• Act as Tier-2/3 support to troubleshoot and resolve technical issues with production data models and services

Education and Experience:

• Minimum undergraduate degree in Mathematics, Computer Science, Engineering or equivalent

5+ years of experience in:

• SQL and other languages used in data manipulation
• Tableau or other BI development experience and designing dashboards / decision enablement tools
• Data warehousing principles and experience in design and/or development using dimensional modeling principles
• Developing rich portfolio of design uses cases demonstrating excellent user experience
• Experience leading analytics projects with stakeholders
• Good Understanding of ELT/ETL processes and Microsoft SQL Server Analysis Services or equivalent technologies
• Strong oral and written communication skills with experience in relating complex concepts to non-technical users, including presentation and storytelling with data
• Visual design expertise with a solid understand of the best practices around dashboard and visual perception.
• End-to-End development experience and ability to create complex calculations including Level of Detail (LOD) expressions, action filters, user filters and implement advanced dashboard practices in Tableau
• Solid understanding of how to consolidate and transform data to meaningful and actionable information
• Ability to draw out meaningful business insights by synthesizing information from multiple sources
• Demonstrated experience in development of analytics applications or data analysis, including insights development and communication to senior leadership
• Must be eligible to obtain “Reliability status” security clearance

Good to Have: 

• Experience with AWS Data Lake
• Experience with Amazon Connect data
• Experience with R, Python, AWS Sage Maker
• Experience with Agile or design-driven development of analytics applications
• PMP and/or Scrum Master certification
• Experience with optimization and tuning of large data extracts for Tableau
• Tableau desktop and server certification
• Knowledge of Insurance or Financial Services industry

Main Responsibilities: 

• Consult with WFM experts to build tools to automate/streamline their work
• Work with data engineers to test new data sources and ensure accuracy
• Investigate issues/data discrepancies and work with a wide variety of stakeholders to fix
• SQL
• Tableau
• Excel including VBA

Nice to Have: 

• Amazon Connect
• NICE IEX