Business Intelligence Analyst

3 weeks ago

Ottawa, Ontario, Canada ROYAL OTTAWA HEALTH CARE GROUP Full time
Job Title: Business Intelligence Developer

This position contributes to The Royal Ottawa Health Care Group with its technical expertise in moving and transforming data. The successful candidate will contribute to the data team's environment and processes, enabling the creation of reports through the set-up of data models, collaborating with users to understand and document their requirements, and helping to support the technology infrastructure in the data environment.

Key Responsibilities:
  • Develop and maintain data models and data dictionaries, data maps, and other artifacts, including the conceptual and physical models, as well as a metadata repository.
  • Contribute to and support activities to ensure the integrity and performance of the data environment, including investigation and issue resolution as required.
  • Generate reports and other data and analytics services within the Azure data and analytics environment.
  • Ensure reports and other data and analytics solutions are optimized for efficiency and performance in the production environment.
  • Collaborate with data team members and partners, such as IT, to help ensure internal control and integrity of systems.
  • Actively participate and support activities as part of various Data Working Groups.
  • Perform system and platform performance monitoring and tuning, and SQL code review as requested and assigned.
  • Support and follow information governance and data standardization procedures established by the organization and partnerships.
Requirements:
  • Bachelor's Degree in Computer Science, Software Engineering, or Information Technology, or equivalent.
  • Minimum 3 years of work experience with SQL server, Business Intelligence, reporting, and data modeling.
  • Expert working knowledge of relational databases, data model development, data warehousing, and business intelligence.
  • Expert in database design, relational integrity constraints, OLAP, OLTP, cubes, and normalization.
  • Experience with cloud-based BI, data virtualization, including Azure platform and Power BI Services.
  • Demonstrated experience in creating medium to large-scale enterprise logical data models using normalization, star, and snowflake schema techniques.
  • Demonstrated experience with ETL and MS SQL Server performance tuning (Profiler, Tracing, Execution Plan Analysis).
  • Expert experience in generating custom reports using SQL Server and Microsoft reporting tools such as SSRS, SSMS, Azure Data Studio, and Power BI Desktop, including advanced functions, scheduling, and publishing reports on Report Server or Power BI Service.
  • Azure Data Factory; Demonstrated experience in responding to and troubleshooting issues related to data quality and performance, with the ability to resolve them in a timely manner.
  • Demonstrated experience in building data analytics and reporting.
  • Experience with Object-Oriented Programming language, including but not limited to, C#/VB/Java is an asset.
  • Experience in working on multiple projects at the same time.
  • Knowledge of the basics of Machine Learning and ability to write/read Python/R code.
  • Strong and effective communication skills to engage with all stakeholders to gather and document business requirements.
  • English level A- is mandatory in oral expression, comprehension, reading, and writing. Bilingual (French/English) is considered an asset.

  • Business Intelligence Analyst

    7 days ago

    Ottawa, Ontario, Canada BGIS Full time

    **Job Summary**The Business Intelligence Analyst plays a crucial role in enabling informed business decisions by preparing comprehensive reports. **Key Responsibilities Include:**Data integrity within information management systems is a top priority.Compiling and maintaining large volumes of real estate portfolio data is essential to meet reporting,...

  • Senior Business Intelligence Analyst

    1 month ago

    Ottawa, Ontario, Canada NAV CANADA Full time

    About the RoleNAV CANADA is seeking a highly skilled Senior Analyst, Strategy and Business Intelligence to join our team. As a key member of our Strategy Realization department, you will play a critical role in driving business growth and decision-making through data-driven insights.Key ResponsibilitiesLead efforts to integrate data from multiple sources and...

  • Senior Business Intelligence Analyst

    3 weeks ago

    Ottawa, Ontario, Canada NAV CANADA Full time

    About the RoleWe are seeking a highly skilled Senior Business Intelligence Analyst to join our team at NAV CANADA. As a key member of our Strategy Realization department, you will play a critical role in driving business success through data-driven insights.Key ResponsibilitiesLead efforts to integrate data from multiple sources and implement data quality...

  • Senior Business Intelligence Analyst

    1 month ago

    Ottawa, Ontario, Canada NAV CANADA Full time

    About the RoleNAV CANADA is seeking a highly skilled Senior Analyst, Strategy and Business Intelligence to join our team. As a key member of our Strategy Realization department, you will play a critical role in driving business growth and decision-making through data-driven insights.Key ResponsibilitiesLead efforts to integrate data from multiple sources and...

  • Senior Business Intelligence Analyst

    4 weeks ago

    Ottawa, Ontario, Canada Farm Credit Canada Full time

    Senior Business Intelligence AnalystAt Farm Credit Canada, we're seeking a highly skilled Senior Business Intelligence Analyst to join our team. As a key member of our organization, you'll play a critical role in driving business decisions through data-driven insights.Key Responsibilities:Develop and maintain advanced analytics and reporting capabilities to...

  • Senior Business Intelligence Analyst

    4 weeks ago

    Ottawa, Ontario, Canada Farm Credit Canada Full time

    Senior Business Intelligence AnalystAt Farm Credit Canada, we're seeking a highly skilled Senior Business Intelligence Analyst to join our team. As a key member of our organization, you'll play a critical role in driving business decisions through data-driven insights.Key Responsibilities:Develop and maintain advanced analytics and reporting capabilities to...

  • Business Intelligence Analyst

    3 weeks ago

    Ottawa, Ontario, Canada CMHC Full time

    Temporary Full-Time OpportunityWe are seeking a highly skilled Business Intelligence Analyst to join our team in a temporary full-time capacity. As a key member of our Business Optimization and Systems team, you will play a critical role in transforming the way we do business at CMHC.About the RoleThis is a temporary position until December 2025. As a Senior...

  • Business Intelligence Analyst

    3 weeks ago

    Ottawa, Ontario, Canada CMHC Full time

    Temporary Full-Time OpportunityWe are seeking a highly skilled Business Intelligence Analyst to join our team in a temporary full-time capacity. As a key member of our Business Optimization and Systems team, you will play a critical role in transforming the way we do business at CMHC.About the RoleThis is a temporary position until December 2025. As a Senior...

  • Business Intelligence Analyst

    3 weeks ago

    Ottawa, Ontario, Canada Aviva Full time

    About UsAt Aviva, we believe that together, we can achieve great things. Our values of Care, Commitment, Community, and Confidence guide everything we do.Job DescriptionWe are seeking a highly motivated and experienced Business Intelligence Analyst to join our Major Case Unit. As a key member of our team, you will be responsible for handling complex claims...

  • Business Intelligence Analyst Intern H/F

    2 weeks ago

    Ottawa, Ontario, Canada TD Place Full time

    TD Place is seeking a highly motivated and detail-oriented Business Intelligence Analyst Intern H/F to join our team. About the Role As a Business Intelligence Analyst Intern, you will provide essential support to our business intelligence team in data-driven reporting and decision making. You will be responsible for generating key reports, conducting data...

  • Private Investigator

    2 weeks ago

    Ottawa, Ontario, Canada AFIMAC Canada Full time

    AFIMAC Canada is seeking a skilled Private Investigator to join its team in Ontario. The ideal candidate will have a strong background in open-source intelligence, investigations, and intelligence analysis.Key Responsibilities:Conduct thorough open-source intelligence inquiries on individuals and corporations to support due diligence, litigation, and...

  • Intelligence Analyst Position

    2 weeks ago

    Ottawa, Ontario, Canada Calian Group Ltd. Full time

    Job OverviewCalian Group Ltd. is seeking an experienced All-Source Intelligence Analyst to support our customer, Command Joint Operations Command (CJOC), located in Ottawa. This is a full-time position (37.5 hours per week) working on-site in Ottawa.Key ResponsibilitiesReview and analyze current intelligence reports and returnsConduct research within...

  • Business Intelligence Manager

    2 weeks ago

    Ottawa, Ontario, Canada Nav Canada Full time

    Job SummaryThe Manager, Business Intelligence and Visualization Center of Excellence is responsible for leading a team of Business Analysts, Developers, and Data modellers to deliver reporting, analytics, visualization, and associated data management capabilities to the organization. Specific data management capabilities include master data management, data...

  • Business Intelligence Professor

    4 weeks ago

    Ottawa, Ontario, Canada University of Ottawa Full time

    Job Title: Business Intelligence ProfessorJob Summary:We are seeking a highly qualified Business Intelligence Professor to join our faculty at the University of Ottawa. The successful candidate will have a strong background in competitive intelligence and market insight, with experience in teaching and research in this field.Key Responsibilities:Teach...

  • Business Intelligence Professor

    4 weeks ago

    Ottawa, Ontario, Canada University of Ottawa Full time

    Job Title: Business Intelligence ProfessorJob Summary:We are seeking a highly qualified Business Intelligence Professor to join our faculty at the University of Ottawa. The successful candidate will have a strong background in competitive intelligence and market insight, with experience in teaching and research in this field.Key Responsibilities:Teach...

  • Business Intelligence Developer

    4 weeks ago

    Ottawa, Ontario, Canada ROYAL OTTAWA HEALTH CARE GROUP Full time

    Job Title: Business Intelligence DeveloperThe Royal Ottawa Health Care Group is seeking a highly skilled Business Intelligence Developer to join its team. As a Business Intelligence Developer, you will play a key role in designing, developing, and implementing business intelligence solutions to support the organization's strategic objectives.Key...

  • Business Intelligence Developer

    3 weeks ago

    Ottawa, Ontario, Canada ROYAL OTTAWA HEALTH CARE GROUP Full time

    Job Title: Business Intelligence DeveloperThe Royal Ottawa Health Care Group is seeking a highly skilled Business Intelligence Developer to join its team. As a Business Intelligence Developer, you will play a key role in designing, developing, and implementing business intelligence solutions to support the organization's strategic objectives.Key...

  • Business Intelligence Developer

    1 month ago

    Ottawa, Ontario, Canada ROYAL OTTAWA HEALTH CARE GROUP Full time

    Job Title: Business Intelligence DeveloperWe are seeking a highly skilled Business Intelligence Developer to join our team at the Royal Ottawa Health Care Group. As a Business Intelligence Developer, you will play a key role in contributing to the development of our data environment and enabling the creation of reports through the set-up of data models.Key...

  • Business Intelligence Developer

    1 month ago

    Ottawa, Ontario, Canada ROYAL OTTAWA HEALTH CARE GROUP Full time

    Job Title: Business Intelligence DeveloperWe are seeking a highly skilled Business Intelligence Developer to join our team at the Royal Ottawa Health Care Group. As a Business Intelligence Developer, you will play a key role in contributing to the development of our data environment and enabling the creation of reports through the set-up of data models.Key...

  • Business Intelligence Professor

    3 weeks ago

    Ottawa, Ontario, Canada University of Ottawa Full time

    Job Title: APTPUO - Fall 2024 - ADM3316ADescription:The University of Ottawa is seeking a highly qualified Business Intelligence Professor to join our faculty. As a key member of our team, you will be responsible for teaching and developing courses in competitive intelligence, market insight, and analytics.Key Responsibilities:Develop and deliver...