Business Intelligence Analyst

Fractal; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading company in AI analytics is seeking a Business Intelligence Analyst to deliver data-driven solutions for enterprise clients. The role requires strong technical expertise and excellent communication skills to translate business needs into actionable insights. You will work closely with clients to develop BI solutions, manage project timelines, and ensure the successful implementation of data-driven strategies. This position offers opportunities for continuous improvement and innovation in a collaborative environment.

Benefits

Health Insurance

Dental Insurance

Vision Insurance

Life Insurance

Disability Plans

401(k) Plan

Paid Holidays

Parental Leave

Flexible PTO Policy

Qualifications

• 5-6 years of experience in Business Intelligence.
• Strong proficiency in BI tools and advanced SQL skills.
• Ability to communicate complex concepts clearly.

Responsibilities

• Collaborate with clients to understand business objectives and requirements.
• Develop and maintain data models to support BI reporting.
• Design and deploy interactive dashboards and reports.

Skills

Analytical and Critical Thinking

Problem-Solving

Communication

Client-Facing & Interpersonal Skills

Adaptability and Proactiveness

Education

Bachelor's/Master’s degree in Data Science

Bachelor's/Master’s degree in Computer Science

Bachelor's/Master’s degree in Information Systems

Bachelor's/Master’s degree in Statistics

Bachelor's/Master’s degree in Engineering

Tools

Tableau

Microsoft Power BI

SQL

Python

Advanced Excel

Job description

Business Intelligence Analyst – Marketplace Analytics

Fractal Analytics is a strategic AI partner to Fortune 500 companies with a vision to power every human decision in the enterprise. Fractal is building a world where individual choices, freedom, and diversity are the greatest assets. An ecosystem where human imagination is at the heart of every decision. Where no possibility is written off, only challenged to get better. We believe that a true Fractalite is one who empowers imagination with intelligence. Fractal has been featured as a Great Place to Work by The Economic Times in partnership with the Great Place to Work Institute and recognized as a ‘Cool Vendor’ and a ‘Vendor to Watch’ by Gartner.

Please visit Fractal | Intelligence for Imagination for more information about Fractal.

Role Overview:

As a Business Intelligence Analyst with 5-6 years of experience, you will play a crucial role in delivering data-driven solutions for our enterprise technology client focused on Marketplace Analytics and Application ecosystems. You will be responsible for understanding client business needs, translating them into analytical requirements, and developing insightful BI solutions, including reports, dashboards, and data visualizations. This role requires a strong blend of technical expertise, business acumen, analytical prowess, and excellent client-facing communication skills. You will work collaboratively with client stakeholders and internal consulting teams to drive impactful outcomes.

Responsibilities:

Client Engagement & Requirements Gathering:

• Collaborate directly with clients to understand their business objectives, challenges, and key performance indicators (KPIs).
• Elicit and document detailed business and data requirements for BI solutions.
• Translate business requirements into technical specifications for data models, reports, and dashboards.

Data Analysis & Modeling:

• Collect, clean, transform, and validate data from various sources to ensure accuracy and reliability.
• Perform in-depth data analysis to identify trends, patterns, anomalies, and opportunities for clients.
• Develop and maintain data models to support BI reporting and analytics.

BI Solution Development & Implementation:

• Design, develop, and deploy interactive and user-friendly dashboards, reports, and data visualizations using BI tools.
• Develop and optimize SQL queries for data extraction, manipulation, and analysis.
• Ensure BI solutions are scalable, efficient, and aligned with client needs and industry best practices.

Insight Generation & Presentation:

• Analyze and interpret complex datasets to generate actionable insights and strategic recommendations for clients.
• Clearly and effectively communicate findings, insights, and recommendations to both technical and non-technical client stakeholders through compelling presentations and written reports.
• Identify the right problem statements and build dashboards with data to answer them.

Project & Stakeholder Management:

• Manage BI-focused project components, including timelines, deliverables, and client expectations.
• Collaborate effectively with internal consulting teams, data engineers, and client personnel.
• Provide training and support to clients and new team members on BI tools and solutions.

Continuous Improvement & Innovation:

• Stay current with the latest BI technologies, tools, and industry trends.
• Identify opportunities to improve existing BI processes, methodologies, and client solutions.

Technical Qualifications:

• BI Platforms: Strong proficiency in at least one leading BI tool (e.g., Tableau, Microsoft Power BI, Qlik Sense/View, *experience with Looker is a plus) with proven experience in developing complex dashboards and reports.
• SQL: Advanced SQL skills for complex data querying, manipulation, transformation, and extraction from various relational databases (e.g., SQL Server, Oracle, MySQL, PostgreSQL).
• Python: Intermediateproficiency for data extraction and analysis.
• Data Modeling: Solid understanding and practical experience with data modeling concepts (e.g., star schema, snowflake schema) to support BI solutions.
• Data Warehousing Concepts: Good understanding of data warehousing fundamentals and ETL (Extract, Transform, Load) processes.
• Advanced Excel: Proficiency in Microsoft Excel for data analysis, including pivot tables, advanced formulas, and data manipulation.

Non-technical Qualifications:

• Analytical and Critical Thinking: Strong ability to collect, organize, analyze, and interpret significant amounts of information with attention to detail and accuracy;1 ability to identify patterns, trends, and anomalies.
• Problem-Solving: Proven ability to understand complex business problems and devise effective, data-driven solutions and recommendations.
• Communication (Verbal and Written): Exceptional ability to articulate complex technical concepts clearly and concisely to both technical and non-technical audiences, including client stakeholders at various levels. Experience in presenting findings and recommendations.
• Client-Facing & Interpersonal Skills: Demonstrated ability to build and maintain strong client relationships, manage expectations, and work effectively in a team-oriented, collaborative consulting environment.
• Requirements Elicitation: Skill in gathering, documenting, and translating business needs into technical BI requirements.
• Adaptability and Proactiveness: Ability to adapt to changing project requirements, technologies, and client environments; proactive in identifying issues and opportunities.
• Time Management and Organization: Strong organizational skills with the ability to manage multiple tasks, prioritize effectively, and meet deadlines in a fast-paced2 environment.
• Business Acumen: Good understanding of general business operations and the ability to quickly learn and apply industry-specific knowledge relevant to client engagements.

Education:

• Bachelor's/Master’s degree in Data Science, Computer Science, Information Systems, Statistics, Engineering, or a related field.

Pay:

The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions, including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At Fractal, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case.

Benefits:

As a full-time employee of the company or as an hourly employee working more than 30 hours per week, you will be eligible to participate in the health, dental, vision, life insurance, and disability plans in accordance with the plan documents, which may be amended from time to time. You will be eligible for benefits on the first day of employment with the Company. In addition, you are eligible to participate in the Company 401(k) Plan after 30 days of employment, in accordance with the applicable plan terms. The Company provides for 11 paid holidays and 12 weeks of Parental Leave. We also follow a “free time” PTO policy, allowing you the flexibility to take the time needed for either sick time or vacation.

Fractal provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.