BI Analyst

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 a