BI Analyst / Data Analyst

Toronto, Canada

Fractal

Fractal is a strategic analytics partner to global Fortune 500 companies & powers every human decision in the enterprise with AI, engineering & design.

View all jobs at Fractal

Apply now Apply later

It's fun to work in a company where people truly BELIEVE in what they are doing!

We're committed to bringing passion and customer focus to the business.

Business Intelligence Analyst – Marketplace Analytics

Location: Canada

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: Intermediate proficiency 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.

If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!

Not the right fit?  Let us know you're interested in a future opportunity by clicking Introduce Yourself in the top-right corner of the page or create an account to set up email alerts as new job postings become available that meet your interest!

Apply now Apply later

* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰

Job stats:  0  0  0

Tags: Business Intelligence Computer Science Consulting Data analysis Data Warehousing Engineering ETL Excel KPIs Looker MySQL Oracle PostgreSQL Power BI Python Qlik RDBMS Snowflake SQL Statistics Tableau

Perks/benefits: Career development Health care Insurance Parental leave Team events

Region: North America
Country: Canada

More jobs like this