Data Analyst – Power BI & SQL

Job Description

Location:

Toronto

Role:
Data Analyst with strong technical and communication skills.

This role involves working closely with business leads and executives to translate data into actionable insights. The ideal candidate will have a solid foundation in SQL, relational databases, and experience with Business Intelligence tools, preferably Power BI.

________________________________________

Key Responsibilities

• Design, develop, and maintain dashboards and reports using BI tools (Power BI preferred).

• Write and optimize complex SQL queries for data extraction and analysis.

• Collaborate with business stakeholders to understand requirements and deliver data-driven solutions.

• Present findings and insights clearly to non-technical audiences, including executives.

• Ensure data accuracy, integrity, and compliance with organizational standards.

________________________________________

Ideal Candidate Traits

• Strong SQL capabilities with at least 5 years of experience (query writing, optimization, troubleshooting).

• Strong understanding of relational databases and data warehouses.

• Excellent communication skills for stakeholder engagement and executive presentations.

• Experience as a BI Developer, ideally with Power BI.

________________________________________

Nice-to-Have

• Background in insurance or related industry.

• Exposure to Cloud

SQL or Big Query environments

Requirements
Experience (Years): 4-6 Essential

Skills:

• Work with project teams throughout the organization to design, implement, and manage CDN infrastructure using Akamai, to ensure high availability, performance, and scalability for customer facing applications and business processes.
• Handle multiple priorities and assignments with excellence and precision.
• Be a part of a 24/7/365 organization (some after hours support is expected as part of normal on-call rotation).
• Directly support line of business development teams, provide guidance to them on implementation and changes for customer facing applications
• Develop and maintain security protocols and measures to protect CDN infrastructure from cyber threats.
• Monitor and analyze network performance, identifying and resolving issues to optimize content delivery of critical applications.
• Collaborate with cross-functional teams to integrate Akamai CDN solutions with existing systems and applications.
• Collaborate with information security teams to implement DDoS protection strategies and other security measures in the CDN.
• Provide technical support and guidance to clients and internal teams regarding CDN and security best practices.
• Work closely with vendor and professional service teams on delivery related activities and strategy.

Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field. OR similar work experience.
• Strong understanding of network protocols (HTTP/HTTPS, DNS, TCP/IP).
• Proven experience as a CDN Engineer or similar role, with a strong focus on cybersecurity.
• In-depth knowledge of Content Delivery Network technologies, including caching, load balancing, and content optimization.
• Excellent problem-solving skills and attention to detail.
• Strong communication and teamwork abilities.
• Experience supporting 24/7/365 customer facing applications at enterprise scale.
• Awareness and experience with cybersecurity tools and practices, such as firewalls, intrusion detection/prevention systems, and encryption.
• Proficiency in scripting and automation (e.g., Python, Bash) a plus.
• Relevant certifications (e.g., CISSP, CEH) are a plus but not required.