Business Analyst - Data Warehouse & Business Intelligence
$111k - $129k per year080 Fidelity Investments Canada ULC
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 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 teamsData 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 performanceBI 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 defectsSkills & Knowledge
Must Have: Strong understanding of data warehousing concepts and data mart designMust Have: Solid knowledge of ETL processes and data flows from operational systems to analytics environmentsMust Have: Experience with BI tools such as Business Objects and TableauMust Have: Proficiency in SQL (highly preferred)Must Have: Working knowledge of metadata, lineage, data quality frameworks, and data governanceMust Have: Proficiency with Confluence, Jira, Visio, and data modelling toolsMust Have: Experience working closely with data architects, ETL developers, BI developers, finance teams, and business stakeholdersExperience Minimum Requirement: 5+ years of Business Analyst experience in data, reporting, or analytics environmentsNice to Have: Experience in Wealth Management or Financial ServicesEducation Minimum Requirement: University degree or equivalent work experienceMust Have: Degree in Information Technology, Computer Science, Data/Analytics, or related fieldsTotal Rewards That Reflect Your Impact
We 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.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.Flexible working arrangements - 100% remote, hybrid, and in office optionsCompetitive total compensation, including company contributions to your group RRSP without a matching requirement from youComprehensive health benefits that start on your first day, with 100% employer-paid premiums, that include up to $5000 annually for mental health services and therapyParental leave top‑up to 100% of your salary for a period of 25 weeksUp to $650 for home office equipmentGenerous time off policy, including 2 paid days annually to volunteer at a charity of your choiceDiversity and inclusion programs, including an active network of Employee Resource GroupsExtensive professional development opportunities, including access to over 11,000 training and development courses, tuition reimbursement, and monetary rewards for completing a required designationWe care a lot about fostering a compassionate, people‑centric culture, and are proud to have been named one of Canada’s Top 100 employers for the last five years.Fidelity Canada is an equal opportunity employer Fidelity Canada is committed to fostering a diverse and inclusive workplace. We will consider all qualified applicants for employment regardless of race, color, religion, sex, sexual orientation, gender identity or expression, national or ethnic origin, age, disability, family status, protected veterans’ status, Aboriginal/Native American status or any other legally protected ground.Fidelity Canada is an equal opportunity employer Fidelity Canada is committed to fostering a diverse and inclusive workplace. We will consider all qualified applicants for employment regardless of race, color, religion, sex, sexual orientation, gender identity or expression, national or ethnic origin, age, disability, family status, protected veterans’ status, Aboriginal/Native American status or any other legally‑protected ground.Accommodation during the application process Fidelity Canada welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in the selection process. If you require an accommodation, please email us at View email address on ca.hrm.tc. No telephone inquiries or agencies please. We thank all applicants for their interest, please be advised that only those selected for an interview will be contacted.Why Work at Fidelity?
Canada’s Top 100 EmployersGreater Toronto's Top EmployersCanada’s Top Family-Friendly EmployersCanada’s Top Employers for Young PeopleGreat Place To Work CertifiedBest Workplaces for InclusionBest Workplaces for Mental WellnessBest Workplaces for Today's YouthBest Workplaces for WomenBest Workplaces in Financial Services & InsuranceBest Workplaces in OntarioBest Workplaces with Most Trusted Executive TeamsLinkedIn Top Companies in CanadaHuman Resource Director (HRD) - Best Place To WorkHRD - 5-Star Benefit ProgramHRD - 5-Star Diversity & Inclusion Employer DesignationsCanadian Compassionate Companies – CertifiedBenefits Canada's Workplace Benefits Award - Future of Work StrategyTalentEgg National Recruitment Excellence Award - Special Award for Diversity & Inclusion in RecruitingCanadian HR Reporter's Most Innovative HR TeamFidelity Canada has become an employer of choice for talented people seeking rewarding career opportunities in the financial services industry. We look to hire outstanding individuals who want to maximize their potential and be challenged in all aspects of their professional careers. To help our employees excel in their roles at Fidelity, we provide everyone here with the best training, resources and support possible throughout their careers. With our help, there’s no limit to what you can accomplish here. We’re excited you’re considering Fidelity for your career plans.Fidelity respects the privacy of your information.
#J-18808-Ljbffr
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 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 teamsData 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 performanceBI 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 defectsSkills & Knowledge
Must Have: Strong understanding of data warehousing concepts and data mart designMust Have: Solid knowledge of ETL processes and data flows from operational systems to analytics environmentsMust Have: Experience with BI tools such as Business Objects and TableauMust Have: Proficiency in SQL (highly preferred)Must Have: Working knowledge of metadata, lineage, data quality frameworks, and data governanceMust Have: Proficiency with Confluence, Jira, Visio, and data modelling toolsMust Have: Experience working closely with data architects, ETL developers, BI developers, finance teams, and business stakeholdersExperience Minimum Requirement: 5+ years of Business Analyst experience in data, reporting, or analytics environmentsNice to Have: Experience in Wealth Management or Financial ServicesEducation Minimum Requirement: University degree or equivalent work experienceMust Have: Degree in Information Technology, Computer Science, Data/Analytics, or related fieldsTotal Rewards That Reflect Your Impact
We 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.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.Flexible working arrangements - 100% remote, hybrid, and in office optionsCompetitive total compensation, including company contributions to your group RRSP without a matching requirement from youComprehensive health benefits that start on your first day, with 100% employer-paid premiums, that include up to $5000 annually for mental health services and therapyParental leave top‑up to 100% of your salary for a period of 25 weeksUp to $650 for home office equipmentGenerous time off policy, including 2 paid days annually to volunteer at a charity of your choiceDiversity and inclusion programs, including an active network of Employee Resource GroupsExtensive professional development opportunities, including access to over 11,000 training and development courses, tuition reimbursement, and monetary rewards for completing a required designationWe care a lot about fostering a compassionate, people‑centric culture, and are proud to have been named one of Canada’s Top 100 employers for the last five years.Fidelity Canada is an equal opportunity employer Fidelity Canada is committed to fostering a diverse and inclusive workplace. We will consider all qualified applicants for employment regardless of race, color, religion, sex, sexual orientation, gender identity or expression, national or ethnic origin, age, disability, family status, protected veterans’ status, Aboriginal/Native American status or any other legally protected ground.Fidelity Canada is an equal opportunity employer Fidelity Canada is committed to fostering a diverse and inclusive workplace. We will consider all qualified applicants for employment regardless of race, color, religion, sex, sexual orientation, gender identity or expression, national or ethnic origin, age, disability, family status, protected veterans’ status, Aboriginal/Native American status or any other legally‑protected ground.Accommodation during the application process Fidelity Canada welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in the selection process. If you require an accommodation, please email us at View email address on ca.hrm.tc. No telephone inquiries or agencies please. We thank all applicants for their interest, please be advised that only those selected for an interview will be contacted.Why Work at Fidelity?
Canada’s Top 100 EmployersGreater Toronto's Top EmployersCanada’s Top Family-Friendly EmployersCanada’s Top Employers for Young PeopleGreat Place To Work CertifiedBest Workplaces for InclusionBest Workplaces for Mental WellnessBest Workplaces for Today's YouthBest Workplaces for WomenBest Workplaces in Financial Services & InsuranceBest Workplaces in OntarioBest Workplaces with Most Trusted Executive TeamsLinkedIn Top Companies in CanadaHuman Resource Director (HRD) - Best Place To WorkHRD - 5-Star Benefit ProgramHRD - 5-Star Diversity & Inclusion Employer DesignationsCanadian Compassionate Companies – CertifiedBenefits Canada's Workplace Benefits Award - Future of Work StrategyTalentEgg National Recruitment Excellence Award - Special Award for Diversity & Inclusion in RecruitingCanadian HR Reporter's Most Innovative HR TeamFidelity Canada has become an employer of choice for talented people seeking rewarding career opportunities in the financial services industry. We look to hire outstanding individuals who want to maximize their potential and be challenged in all aspects of their professional careers. To help our employees excel in their roles at Fidelity, we provide everyone here with the best training, resources and support possible throughout their careers. With our help, there’s no limit to what you can accomplish here. We’re excited you’re considering Fidelity for your career plans.Fidelity respects the privacy of your information.
#J-18808-Ljbffr
Vacancy posted 1 hour 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
- 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
- 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
- ...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
- 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
- ...-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
- 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
- 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
- ...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- 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 intelligenceInternship
- ...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 contractTemporary workFlexible hours
- ...-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 intelligenceFlexible hours
- ...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 intelligenceFlexible hours
- ...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 intelligenceImmediate start
- ...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 intelligenceContract work
- ...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
- 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 intelligenceWork at office
- 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 intelligenceContract work
- ...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 intelligenceWork from home
$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$50 - $80 per hour
Role Summary: The IT Business Analyst is responsible for improving data quality, reporting, systems integration, and business processes across transportation... ...teams, this role leverages data analytics, business intelligence, and technology solutions to enhance operational...Business intelligenceHourly payTemporary workWork at officeMonday to friday$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 intelligenceFull timeInternshipWork at officeFlexible hours$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 intelligenceFull timeTemporary workRemote work- 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
- 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 intelligenceRemote work
$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 intelligenceWork from home- 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
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
- erp business analyst Winnipeg, MB
- business data analyst Winnipeg, MB
- conseiller en gestion des ressources humaines Winnipeg, MB
- risk management analyst Winnipeg, MB
- salesforce business analyst Winnipeg, MB
- incident management analyst Winnipeg, MB
- software asset management analyst Winnipeg, MB
- business analyst contract Winnipeg, MB
- senior business analyst Winnipeg, MB
- controleur de gestion Winnipeg, MB

