Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Business Analyst - Data Warehouse & Business Intelligence

$111k - $129k per year

Fidelity Canada

Job DescriptionBusiness Analyst - Data Warehouse & BI ReportingJob SummaryThe Business Analyst - Data Warehouse & BI Reporting serves as a key member of the scrum team responsible for delivering data-driven solutions within the Wealth Management Data Warehouse. This role bridges business needs with technical design by translating reporting and analytics requirements into clear user stories, data specifications, and acceptance criteria. The BA collaborates closely with the Product Owner, Data Architect, Data Analyst, DW Developers, BI Developers, and business stakeholders to shape data marts, ETL pipelines, and dashboards using Business Objects and Tableau. This role requires strong analytical capability, a solid grasp of data warehousing concepts, and experience supporting business intelligence and reporting initiatives.
Key Responsibilities
Requirements Gathering, Analysis & Stakeholder Engagement
Lead the discovery, articulation, and clarification of business requirements for data warehouse, ETL, and BI reporting solutions.
Translate business needs into user stories, data definitions, data and integration specifications, and acceptance criteria.
Act as a liaison between business stakeholders, Product Owner, data architecture, and development teams.
Success Measures
Clear, accurate, complete requirements that reduce rework and streamline delivery/testing
Strong alignment between business expectations and delivered outcomes
High stakeholder satisfaction and effective communication across teams
Data Analysis, Source-to-Target Mapping & Data Modelling Support
Perform data analysis including source data validation, data profiling, and data quality assessment.
Create source-to-target mappings, document transformation logic, and define metric calculations.
Collaborate with Data Architect, Data Governance, and developers to shape data models aligned to business rules and reporting needs.
Success Measures
Accurate data definitions, mappings, and business logic
Reduced data-related defects during testing and report validation
Scalable data structures supporting operational and reporting performance
BI Solution Design, Testing Support & Documentation
Produce high-quality documentation for reporting logic, metric definitions, and data flows.
Translate business needs into BI reporting specifications including metrics, aggregation rules, layout, filters, and visuals.
Ensure report logic supports business usability, consistency, and compliance requirements including role-based access.
Support data validation and functional testing during QA/UAT phases.
Success Measures
Accurate, user-friendly BI deliverables that meet business objectives
Complete and up-to-date documentation
High UAT pass rates and low production defects
Skills & KnowledgeMust Have
Strong understanding of data warehousing concepts and data mart design
Solid knowledge of ETL processes and data flows from operational systems to analytics environments
Experience with BI tools such as Business Objects and Tableau
Proficiency in SQL (highly preferred)
Working knowledge of metadata, lineage, data quality frameworks, and data governance
Proficiency with Confluence, Jira, Visio, and data modelling tools
ExperienceMinimum Requirement
5+ years of Business Analyst experience in data, reporting, or analytics environments
Must Have
Experience working closely with data architects, ETL developers, BI developers, finance teams, and business stakeholders
Nice to Have
Experience in Wealth Management or Financial Services
EducationMinimum Requirement
University degree or equivalent work experience
Must Have
Degree in Information Technology, Computer Science, Data/Analytics, or related fields
Total Rewards That Reflect Your ImpactWe believe exceptional work deserves exceptional recognition. That’s why we offer a competitive compensation package designed to support your success today and your financial well-being tomorrow.
For this role, your total rewards include
Base Salary and Discretionary Performance Bonus A competitive annual range of $111,000 to $129,000, based on your experience and qualifications.
RRSP Contribution After 6 months of employment, we invest in your future with an RRSP contribution-no employee matching required.
We're proud to offer a compensation package that aligns with provincial pay transparency requirements.
This posting represents an existing vacancy within our organization - an opportunity to step into a role where your talents will make a meaningful difference.
Some of the ways we'll help you feel valued and supported as part of our team
Flexible working arrangements - 100% remote, hybrid, and in office options
#J-18808-Ljbffr
Vacancy posted 2 hours ago
Similar jobs that could be interesting for youBased on the Business Analyst - Data Warehouse & Business Intelligence in Winnipeg, MB vacancy
  • $111k - $129k per year

    Job Description Business Analyst – Data Warehouse & BI Reporting Job Summary The Business Analyst – Data Warehouse & BI Reporting serves as a key member of the scrum team responsible for delivering data‑driven solutions within the Wealth Management Data Warehouse. This role... 
    Business intelligence
    Work at office
    Remote work
    Home office
    Flexible hours

    080 Fidelity Investments Canada ULC

    Winnipeg, MB
    2 hours ago
  •  ...Business Intelligence Analyst Location: Winnipeg, MB (Onsite) Turning Information into Business Intelligence. Driving Better Decisions. ODRA...  ...uses information. This is not a traditional research or data-entry position. Success in this role requires curiosity, critical... 
    Business intelligence
    Full time
    For contractors

    ODRA Road Sweepers

    Winnipeg, MB
    10 days ago
  •  ...embrace innovation in all areas as we continue to grow our business into the future. Working with us means you’ll be part...  ...How You’ll Make an Impact As a Senior Technical Analyst, Data Engineering and Business Intelligence, at Fidelity Investments Canada, you will focus on... 
    Business intelligence
    Work at office
    Flexible hours

    Fidelity International

    Winnipeg, MB
    8 days ago
  • Join Bombardier as a Data Analyst focused on Business Intelligence, where you will manipulate data into insightful reports that support innovative decisions in aerospace. This Analyst role is open at Bombardier’s Marcel-Laurin Plant, emphasizing your expertise in data structuring... 
    Business intelligence

    Bombardier

    Winnipeg, MB
    2 hours ago
  •  ...MAIN RESPONSIBILITIES As part of the Corporate Effectiveness team, you will act as a Business Analyst in a context focused on data value creation, the evolution of business intelligence, and the deployment of artificial intelligence. You will contribute to structuring and... 
    Business intelligence
    Long term contract
    Permanent employment
    Full time
    Fixed term contract
    Internship
    Remote work
    Work visa
    Flexible hours

    GIRO Inc.

    Winnipeg, MB
    2 hours ago
  • Business Intelligence and reporting lead this Data Analyst role at Tata Consultancy Services, with EDH, SQL, and Informatica supporting trusted insights. The work connects data with business needs.In this Data Analyst position, you will create dashboards, reports, and visualizations... 
    Business intelligence

    Tata Consultancy Services Limited

    Winnipeg, MB
    2 hours ago
  • Shape business decisions through Power BI dashboards, SQL or SAS data mining, and clear data storytelling for BMO. Work independently across complex analytical tasks.As a Data Analyst, you will articulate business cases, estimate delivered value, and design analyses around... 
    Business intelligence

    Insight Global (United States)

    Winnipeg, MB
    2 hours ago
  •  ...-Time Requisition #: DATAB001051 DescriptionTitle: Data & Business Intelligence (BI) AnalystEmployment Type: Full-TimeLocation: Calgary...  ...business decisions. As our Data & Business Intelligence Analyst, you'll play a key role in strengthening how we manage, understand... 
    Business intelligence
    Full time

    Hopewell Residential

    Winnipeg, MB
    2 hours ago
  • Turn complex scientific data into actionable intelligence as a Senior Business Intelligence Data Analyst with Sutherland Healthcare Solutions. Work across data, analytics, and business operations.This senior role sits within Sutherland Healthcare Solutions’ Enterprise Data and... 
    Business intelligence

    Sutherland

    Winnipeg, MB
    2 hours ago
  • Gather and analyze business requirements from stakeholders. Collect, extract, and analyze data from multiple sources. Develop interactive...  ...: Basic knowledge of data warehouses. Fact and dimension tables. Star...  ...Services). Business Intelligence Skills Understanding business... 
    Business intelligence

    Spait Infotech

    Winnipeg, MB
    2 hours ago
  •  ...requirement workshops/meetings and ensure business requirements are adequately captured in...  ...with BI Developer, support development of data solutions, including data models, data lifecycle...  ...of experience working with databases and warehouses, with hands-on expertise in SQL-Server (... 
    Business intelligence
    Work at office
    Work from home

    CAA Club Group

    Winnipeg, MB
    2 hours ago
  • $88k per year

     ...provide operational analysis to allow for optimal business decisions in Distribution Centers. In a fast-paced environment, they find data-driven solutions under tight deadlines while...  ..., Data Lakes, Hadoop, and Enterprise Data Warehouses (EDW).Exceptional analytical skills with the... 
    Business intelligence
    Permanent employment
    Work at office
    Remote work
    Monday to friday

    Altis Technology

    Winnipeg, MB
    2 hours ago
  • $135.2k - $202.8k per year

     ...essential to running a payments business, and given our transaction...  ...accuracy and trust.As a Senior Analyst on the team, you will independently...  ...and equivalents), along with data from acquirers, processors,...  ...automation.Experience with cloud data warehouses (e.G., Snowflake, BigQuery)... 
    Business intelligence
    Work at office
    Remote work
    Worldwide
    Flexible hours

    Unchain Data

    Winnipeg, MB
    2 hours ago
  • The Business Intelligence Analyst is a role within the Analytics and Optimization team reporting to the Manager, BI Analytics. The individual will...  ...end on all stages of reporting projects — from solution and data design, data preparation and investigation, to designing, building... 
    Business intelligence
    Internship

    Exchange Solutions

    Winnipeg, MB
    2 hours ago
  •  ...Reporting to the Associate Director, Enforcement, the Enforcement Intelligence Analyst identifies and assesses emerging, cross-cutting, and systemic...  .... Working alongside other Intelligence Analysts, Data Analysts, and Investigators, the successful candidate will bring... 
    Long term contract
    Temporary work
    Flexible hours

    Alberta Securities Commission

    Winnipeg, MB
    8 days ago
  •  ...-performing aircraft for the world’s most discerning people and businesses, governments and militaries. We have been successful in setting...  ...appropriate project plans.Extract, import, process and document source data.Implement data sets for Power BI visibilities.Be responsible for... 
    Business intelligence
    Flexible hours

    Bombardier

    Winnipeg, MB
    2 hours ago
  •  ...in having a real impact. As a BI Analyst , you will serve as a trusted business partner, translating business needs into meaningful, data-driven solutions. You will design and...  ...volumes of data into actionable Business Intelligence (BI) solutions. Work within an... 
    Business intelligence
    Flexible hours

    Agropur

    Winnipeg, MB
    2 hours ago
  •  ...Leading the Way to Better Living™. We are searching for a Business Intelligence Analyst to join our Analytics and Innovation Team in...  ...excellence and safety About The Opportunity Transforms raw data into meaningful information for the organization.... 
    Business intelligence
    Immediate start

    Shannex Incorporated

    Winnipeg, MB
    2 hours ago
  •  ...limited to: Communicating and Presenting Effectively: The Business Intelligence Analyst must be an expert communicator, capable of presenting...  ...that support the clients digital transformation goals.Applying Data Architectural Methodologies: Experience with data architectural... 
    Business intelligence
    Contract work

    Dasro Consulting Inc.

    Winnipeg, MB
    2 hours ago
  • Job Description Our client is looking for a Business Intelligence Analyst to help scale their client business reviews. You will build and manage reporting that brings payments data together and give the sales team accurate, polished outputs. You will be the first line of... 
    Business intelligence
    Work at office

    Insight Global (United States)

    Winnipeg, MB
    2 hours ago
  •  ...DESCRIPTION Reporting to the Director of Business Intelligence and Innovation, the incumbent...  ...to the exploitation and enhancement of data from various internal and external sources...  ...and loading (ETL) processes into data warehouses. Ensure the reliability of information... 
    Business intelligence

    Dayforce

    Winnipeg, MB
    2 hours ago
  • A consulting firm is seeking a Business Intelligence Analyst in Regina, Canada. The ideal candidate will have at least 10 years of experience in data management, effective communication skills, and a strong background in SQL and Power BI. Responsibilities include guiding business... 
    Business intelligence
    Contract work

    Dasro Consulting Inc.

    Winnipeg, MB
    2 hours ago
  •  ...do their best work.We're looking for a Product Owner - Data & Business Intelligence to help shape how data drives decisions across our business...  ...outcomes.Work closely with BI architects, data engineers, analysts, application owners, and subject-matter experts to deliver... 
    Business intelligence
    Work from home

    Trail Appliances Ltd.

    Winnipeg, MB
    2 hours ago
  • $85k - $100k per year

     ...coast, the company works in a dynamic environment where HR data and metrics play a strategic role in decision-making. As...  ...management practices, the organization is seeking an HR Analyst & Business Intelligence Analyst who will actively contribute to transforming data... 
    Business intelligence

    Jump! recruiters

    Winnipeg, MB
    2 hours ago
  • $73.5k - $116.85k per year

    ## Senior Analyst, Business IntelligenceApply: Hybrid: Canadian Head Office: Full time: Posted Today: R36167At Allstate, great things...  ...will partner with business stakeholders to transform complex data into actionable insights that drive customer-focused and data-... 
    Business intelligence
    Full time
    Internship
    Work at office
    Flexible hours

    Allstate Northern Ireland Limited

    Winnipeg, MB
    2 hours ago
  • $8236 - $9896 per month

     ...enterprise BI solutions and products to support end-users on business planning and decision making. Maintains BI technology,...  ...three (3) years of recent related experience in data warehousing, business intelligence, information management or analytics. Must have the client... 
    Business intelligence
    Full time
    Temporary work
    Remote work

    TransLink

    Winnipeg, MB
    2 hours ago
  • Build scalable business intelligence solutions at Konrad using dashboards, data models, and advanced visualization. Partner with clients across custom digital experiences.As a Senior Data Analyst, you design and deliver analytics and reporting solutions that support operational... 
    Business intelligence

    Konrad

    Winnipeg, MB
    2 hours ago
  • Business Analyst – Business Intelligence (BI) Business Analyst – Business Intelligence (BI) DetailInformationContract Duration 12 MonthsLocation Remote...  ...in patient care delivery and responsible health data management.Implementation of the CIS will modernize how care... 
    Business intelligence
    Remote work

    emergiTEL Inc.

    Winnipeg, MB
    2 hours ago
  • $76.8k - $115.2k per year

    Line Of Business Analytics, Insights, & Artificial IntelligenceWork Location Montréal, Quebec, CanadaHours 37.5Pay Details $76,800...  ...portfolio. If you are driven by helping stakeholders understand data, love when the latest direct-to-consumer marketing campaign results... 
    Business intelligence
    Work from home

    TD

    Winnipeg, MB
    2 hours ago
  • Become a Senior Analyst at Viral Nation, focusing on enhancing marketing strategies through advanced analytics...  ...insights. In this critical role within the Business Intelligence team, you will drive marketing strategies using data analysis and insights generation. Candidates... 
    Business intelligence

    Viral Nation

    Winnipeg, MB
    2 hours ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Business Analyst - Data Warehouse & Business Intelligence. Be the first to apply!