Business Analyst - Data Warehouse & Business Intelligence
$111k - $129k per yearFidelity 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
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 intelligenceFull timeFor contractors
- ...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 intelligenceWork at officeFlexible hours
- ...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...SuggestedLong term contractTemporary workFlexible hours
- ...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 intelligencePermanent employmentFull time
- ...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...SuggestedWork at office
- ...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 workRemote work
- ...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
- ...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 timeContract workRemote work
- ...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 timeInternshipImmediate start
- ...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
- ...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 intelligencePermanent employmentFull timeWork at officeImmediate startMonday to friday
- ...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
- ...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 paidLong term contractPermanent employmentFull timePart timeFor contractorsWork at officeLocal areaFlexible hours
$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 employmentFull timePart timeInternshipFlexible hours- 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
- 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
- ...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 intelligenceLong term contractPermanent employmentFull timeFixed term contractInternshipRemote workWork visaFlexible hours
- 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
- ...-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 intelligenceFull time
- 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
- ...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 timeInternshipWork at officeImmediate start
- 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
- ...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...
$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 employmentFull time- ...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 timeInternshipImmediate start
- ...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 intelligenceWork at officeWork from home
$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 intelligenceWork at officeRemote workWorldwideFlexible hours$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 intelligencePermanent employmentWork at officeRemote workMonday to friday- 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
- ...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 contractPermanent employmentFull timeTemporary workInternshipWorldwide
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Business Analyst - Data Warehouse & Business Intelligence. Be the first to apply!
Related searches
- business analyst intern Winnipeg, MB
- conseiller en gestion des ressources humaines Winnipeg, MB
- business analyst contract Winnipeg, MB
- entry level business analyst Winnipeg, MB
- business analyst co-op Winnipeg, MB
- junior business analyst Winnipeg, MB
- business data analyst Winnipeg, MB
- business analyst Winnipeg, MB
- business analyst utilities Winnipeg, MB
- knowledge management analyst Winnipeg, MB


