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
  •  ...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
    9 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
    7 days 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... 
    Suggested
    Long term contract
    Temporary work
    Flexible hours

    Alberta Securities Commission

    Winnipeg, MB
    7 days ago
  •  ...Shape CATC’s Azure SQL data warehouse using advanced SQL, relational modelling, and dbt. This...  ...permanent, full-time role connects critical business systems. The Data Engineering &...  ...Support Power BI developers and business analysts with warehouse datasets Document sources... 
    Business intelligence
    Permanent employment
    Full time

    Canadian-Addiction-Treatment-Centres

    Winnipeg, MB
    7 days ago
  •  ...principles of Price have never changed – business integrity, first-class service, innovation...  ...part of that. Job Summary A Business Analyst (BA) acts as the connector between business...  ...requirements, user stories, basic data requirements, and business rules • Conduct... 
    Suggested
    Work at office

    Price Industries Limited

    Winnipeg, MB
    7 days ago
  •  ...Paradigm has opportunities for Data Analyst to employ their knowledge, skills and techniques to deliver and implement initiatives and enable our customers to maximize their investments in their business processes and information technology . The role will be based onsite... 
    Contract work
    Remote work

    paradigmconsulting

    Winnipeg, MB
    4 days ago
  •  ...support a critical operational reporting and data initiative within a university...  ...migrate reports to new data sources (Data Warehouse/Data Lake) Build and enhance PHP applications...  ...Collaborate with stakeholders to validate business requirements Perform data validation... 
    Contract work

    Sapsol Technologies Inc

    Winnipeg, MB
    more than 2 months ago
  •  ...Paradigm has opportunities for Business Analysts (Intermediate or Senior) to employ their knowledge, skills and techniques to deliver and implement initiatives and enable our customers to maximize their investments in their business processes and information technology.... 
    Full time
    Contract work
    Remote work

    paradigmconsulting

    Winnipeg, MB
    4 days ago
  •  ...monitors Engineering reports through PowerBi, ensuring that it is modeled by a common data structure that satisfies the functional requirements of the area, and supports overall business objectives. Supports the optimization of business systems internal to Engineering and... 
    Full time
    Internship
    Immediate start

    New Flyer

    Winnipeg, MB
    6 days ago
  •  ...products ( The founding principles of Price have never changed – business integrity, first-class service, innovation and a commitment to...  ...for an experienced and solution-oriented Intermediate Business Analyst to join our team in supporting cross-functional initiatives that... 
    Work at office

    Price Industries Limited

    Winnipeg, MB
    3 days ago
  •  ...Join a highly visible Finance Business Systems team that sits at the...  ...automation, process improvement, data governance, and strategic...  ...two Finance Business Systems Analyst positions. Both roles partner...  ...~ Experience with Business Intelligence, analytics, automation and AI... 
    Business intelligence
    Permanent employment
    Full time
    Work at office
    Immediate start
    Monday to friday

    NFI Group Inc.

    Winnipeg, MB
    a month ago
  •  ...Canada Lottery Corporation (WCLC) is looking to add a Senior Business Systems Analyst to our Application Delivery team. You'll play a crucial role...  ...requirements, system design specifications, workflow designs, data mapping, system specifications, and other documentation as required... 
    Full time

    Western Canada Lottery Corporation

    Winnipeg, MB
    6 days ago
  •  ...RTLS Business Analyst  Winnipeg, Canada (Hybrid) 3 days in office Description  We’re Civica and we make software that helps deliver critical services for citizens all around the world. From local to state government, to education, to health and care, over 5,000 public... 
    Daily paid
    Long term contract
    Permanent employment
    Full time
    Part time
    For contractors
    Work at office
    Local area
    Flexible hours

    Civica

    Winnipeg, MB
    a month ago
  • $75.5k - $125k per year

     ...Permanent Full Time  - We are hiring a Senior IT Business Systems Analyst. This is a hybrid role located in London, Toronto or Winnipeg. Reporting...  ..., including front-end experiences, APIs and integrations, data, mainframe and systems of record, identity and security, and... 
    Permanent employment
    Full time
    Part time
    Internship
    Flexible hours

    Canada Life

    Winnipeg, MB
    7 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
  • 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
  •  ...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
  • 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
  • Overview Reporting to the Supervisor, Data Warehouse, the Data Warehouse Programmer develops and...  .... The position works closely with business users to meet query and/or report requests...  ...over a maximum 24-month period to progress to the Programmer/Analyst classification. ...
    Full time

    Manitoba Public Insurance

    Winnipeg, MB
    a month ago
  •  ...US. As a key member of the Purchasing Team, the Supply Chain Business Analyst will support key supply chain activities for the company. This...  ...insights to leadership teams. Provided accurate, timely forecast data to long-lead-time suppliers to ensure continuity of supply.... 
    Full time
    Internship
    Work at office
    Immediate start

    New Flyer

    Winnipeg, MB
    more than 2 months ago
  • Payments data sits at the center of this Business Intelligence Analyst opportunity, with responsibility for dependable models and sales reporting. Accuracy is essential throughout.Our client is seeking a Business Intelligence Analyst to support a growing client business review... 
    Business intelligence

    Insight Global (United States)

    Winnipeg, MB
    2 hours ago
  •  ...As our Business Systems Analyst, you'll be the bridge between business needs and practical technology solutions. You'll translate requirements into...  ...software development, you'll connect systems, support reliable data processing and delivery, and make everyday work more... 

    Smartrend Manufacturing Group

    Winnipeg, MB
    16 days ago
  • $75k - $90k per year

     ...Job Description Develop and execute data testing plans to ensure data integrity and quality. Identify, document, and track data...  ...applicants The Successful Applicant A successful Data QA Analyst should have: Experience in data testing, quality assurance, or... 
    Permanent employment
    Full time

    Michael Page

    Winnipeg, MB
    a month ago
  •  ...TAX ANALYST – BUSINESS INCENTIVES Winnipeg, Manitoba Full-Time, Onsite NFI is a leading global bus manufacturer of mass mobility solutions under the brands New Flyer® (heavy-duty transit buses), MCI® (motor coaches), Alexander Dennis Limited (single and double-deck... 
    Full time
    Internship
    Immediate start

    NFI Group Inc.

    Winnipeg, MB
    a month 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
    1 hour 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
    1 hour 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
    1 hour 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
  •  ...services in the Aviation industry. Reporting Structure The Warehouse Generalist reports directly to the Engine Shop Manager. Core...  ...inventory of shipping materials and supplies. Assist in oversight of data management of inventory visibility and accuracy within Tracking... 
    Long term contract
    Permanent employment
    Full time
    Temporary work
    Internship
    Worldwide

    Avmax Careers - Canada

    Winnipeg, MB
    11 days 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!