Business Intelligence Developer

2 months ago

Ottawa, Canada ROYAL OTTAWA HEALTH CARE GROUP Full time
div>

This position contributes to The Royal with its technical expertise in moving and transforming data. They contribute to the data team’s environment and processes and enable the creation of reports through the set-up of data models, collaborating with users to understand and document their requirements as well as helping to support the technology infrastructure in the data environment.

This team member will collaborate both with internal team members and external data partners in the shared data environment, contributing to collaborative planning and working in a supportive and positive manner.

Duties:Database/Data Model Design & Development:
  1. Documents business requirements in the form of specifications (functional and technical specifications), validates accuracy and obtains necessary input and approval.
  2. Following established standards and practices, develops and maintains data models and data dictionaries, data maps and other artifacts, including the conceptual and physical models, as well as a metadata repository.
  3. Contributes to and supports activities to ensure the integrity and performance of data environment, including investigation and issue resolution as required.
Report Design & Development:
  1. Contributes to and helps build data & analytic solutions (including database design) as assigned to support requests and business needs.
  2. Generates reports and other data and analytics services within the Azure data & analytics environment.
  3. Ensures reports and other data & analytics solutions are optimized for efficiency and performance in the production environment.
Partnerships & Collaboration:
  1. Collaborates with data team members and partners such as IT to help ensure internal control & integrity of systems.
  2. Actively participates and supports activities as part of various Data Working Groups.
Operational Support & Maintenance:
  1. As requested and assigned, performs system and platform performance monitoring and tuning, and SQL code review.
  2. Supports and follows information governance and data standardization procedures established by the organization and partnerships.
  3. Applies appropriate content and design details where appropriate.
  4. Collaborates closely with and provides coverage as needed for any BI Developer/Analyst.
Other:
  1. Work in a manner that is in compliance with staff and patient/client safety practices, policies and procedures of The Royal.
  2. Ensure a work environment that is conducive to The Royal’s Anti-Racism, Harassment, & Discrimination Free Workplace Policy.
Qualifications:
  1. Bachelor’s Degree in Computer Science, Software Engineering or Information Technology, or equivalent.
  2. Minimum 3 years of work experience with SQL server, Business Intelligence, reporting and data modelling.
  3. Expert working knowledge of relational databases, data model development, data warehousing, and business intelligence.
  4. Expert in database design, relational integrity constraints, OLAP, OLTP, cubes, and normalization.
  5. Experience with cloud-based BI, data virtualization including Azure platform and Power BI Services.
  6. Demonstrated experience in creating medium to large-scale enterprise logical data models using normalization, star and snowflake schema techniques.
  7. Demonstrated experience with ETL and MS SQL Server performance tuning (Profiler, Tracing, Execution Plan Analysis).
  8. 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.
  9. Demonstrated experience in responding to and troubleshooting issues related to data quality and performance, with the ability to resolve them in a timely manner.
  10. Demonstrated experience in building data analytics and reporting.
  11. Experience with Object-Oriented Programming language, including but not limited to, C#/VB/Java is an asset.
  12. Experience in working on multiple projects at the same time.
  13. Knowledge of the basics of Machine Learning and ability to write/read Python/R code.
  14. Strong and effective communication skills to engage with all stakeholders to gather and document business requirements.
  15. English level A- is mandatory in oral expression, comprehension, reading & writing. Bilingual (French/English) is considered an asset.

  • Business Intelligence Analyst

    7 months ago

    Ottawa, Canada NSERC Full time

    A written examination and an interview will be administered. If you are looking for a dynamic and challenging work environment with a fun, diverse and dedicated team, the Social Sciences and Humanities Research Council (SSHRC) and Natural Science and Engineering Research Council’s (NSERC) is the place for you! We are growing our team and looking for...

  • Business Intelligence Report Developer

    4 months ago

    Ottawa, Canada Thales Full time

    Location: Ottawa, CanadaIn fast changing markets, customers worldwide rely on Thales. Thales is a business where brilliant people from all over the world come together to share ideas and inspire each other. In aerospace, transportation, defence, security and space, our architects design innovative solutions that make our tomorrow's possible.For decades,...

  • Business Intelligence Lead

    6 months ago

    Ottawa, Canada Home and Community Care Support Services South East Full time

    Company Bio Home and Community Care Support Services South East is one of 14 Home and Community Care Support Services organizations in Ontario with a focused mandate to deliver local health care services such as home and community care and long-term care home placement. These organizations were previously known as Local Health Integration Networks (or...

  • Business Intelligence Specialist

    4 weeks ago

    Ottawa, Ontario, Canada CBCRadio-Canada Full time

    Job DescriptionWe are seeking a highly skilled Business Intelligence Specialist to join our team at CBC/Radio-Canada in Montreal, Quebec.About the RoleThis is a full-time position with a competitive salary range of $80,000 - $120,000 per year, depending on experience. As a Business Intelligence Specialist, you will play a key role in supporting our...

  • Business Intelligence Manager

    2 months 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...

  • Senior Business Intelligence Architect

    1 week ago

    Ottawa, Ontario, Canada ROSS Full time

    About ROSSROSS is a leading provider of business intelligence and analytics solutions. Our software enables clients to gain predictive power and drive change at every level.Job DescriptionWe are seeking a skilled Senior Business Intelligence Architect to join our team in Ottawa. As a key member of our sales/presales team, you will be responsible for...

  • Manager, Business Intelligence and Visualization

    2 months ago

    Ottawa, Canada NAV Canada Full time

    Job Posting Title Manager, Business Intelligence and Visualization Center of Excellence Job Category Business Intelligence Language Requirements English / Anglais Flexible Work Agreement Type Hybrid / Hybride Posting End Date 2024-11-13 Job Grade L1 Zone B Pay Range Commensurate with Experience / Selon l’expérience Job Summary The Manager,...

  • Business Intelligence Leader

    4 weeks ago

    Ottawa, Ontario, Canada Nav Canada Full time

    Job OverviewNav Canada is seeking a seasoned Business Intelligence Leader to lead our team in delivering reporting, analytics, and visualization capabilities. As a key member of our organization, you will be responsible for leading a team of experts to extract valuable insights from complex data, drive business outcomes, and improve decision-making.About the...

  • Business Intelligence and Information Technology Professor

    4 weeks ago

    Ottawa, Ontario, Canada University of Ottawa Full time

    Job Description:We are seeking a highly qualified professor to teach business intelligence and information technology courses at the University of Ottawa.About the PositionThe successful candidate will be responsible for teaching 3-credit business intelligence and information technology courses, including lectures and labs. The ideal candidate should have...

  • Business Intelligence Analyst Lead

    4 weeks ago

    Ottawa, Ontario, Canada ECF Data, LLC Full time

    About ECF Data, LLCWe are a dynamic and innovative company seeking a skilled Business Intelligence Analyst Lead to join our team. The ideal candidate will have expertise in data collection and analysis, with the ability to develop and implement databases, data collection systems, and data analytics strategies.

  • Business Intelligence Reporting Analyst

    7 months ago

    Ottawa, Canada Canadian Medical Protective Association Full time

    **BUSINESS INTELLIGENCE REPORTING ANALYST** **CONTRIBUTING TO THE CMPA** The Research, Analytics and Privacy group captures and manages corporate and medico-legal data, generates insights and translates knowledge to inform data-driven business decisions and evidence-informed safe medical care products. This group also leads support for the CMPA on privacy...

  • Research and Business Intelligence Officer

    6 months ago

    Ottawa, Canada The Royal Ottawa Mental Health Centre Full time

    **Position Information** **Posting Number**: - ROM23-414E**Title**: - Research and Business Intelligence Officer (TFT 1.0 FTE)**Position Status**: - Temporary Full-time**FTE**: - 1**Job Schedule**: - Days**Department**: - Foundation**Union**: - Non-union**Site**: - Royal Ottawa Mental Health Centre**About The Royal** We’re breaking down stigmas....

  • Business Intelligence Partner, Regular Full Time

    6 months ago

    Ottawa, Canada Home and Community Care Support Services Champlain Full time

    **Home and Community Care Support Services Champlain** is one of 14 Home and Community Care Support Services organizations in Ontario. We are dedicated to ensuring our more than 64,000 patients annually receive the highest-quality health care and services at home. Our patient-care coordination teams help develop care plans for people of most ages, focused on...

  • Technical Specialist

    1 week ago

    Ottawa, Ontario, Canada ROSS Full time

    Job OverviewWe are seeking an experienced Technical Consultant to join our team at ROSS, a leading provider of remote HR and recruitment solutions. The successful candidate will work with clients to design, develop, and deliver business intelligence applications.

  • Business Intelligence Analyst for Government Security

    4 weeks ago

    Ottawa, Ontario, Canada Abacus Service Corporation Full time

    Job Title: Business Intelligence Analyst for Government SecurityAbout the RoleAbacus Service Corporation is seeking a highly skilled Business Intelligence Analyst to support the development and execution of projects related to security operations and program management within the Parliamentary Protective Services environment.Key Responsibilities* Analyze...

  • Senior Business Intelligence and Data Visualization Manager

    4 weeks ago

    Ottawa, Ontario, Canada Nav Canada Full time

    About the RoleThe Senior Business Intelligence and Data Visualization Manager will lead a team of business analysts, developers, and data modelers to deliver reporting, analytics, visualization, and associated data management capabilities to the organization. This role requires a strong understanding of data governance, data quality, and data security best...

  • Enterprise Business Intelligence Solutions Developer

    3 days ago

    Ottawa, Ontario, Canada Total Power Ltd Full time

    Company Overview">Total Power Ltd is a leading provider of on-site power generating solutions nationwide, with a reputation for expertise, integrity, and innovation.We're proud to be a Canadian company, respected throughout the industry for our commitment to excellence.Salary: $95,000–$125,000 per yearThis role offers a competitive salary, reflecting the...

  • Senior Business Intelligence Analytics Professional

    4 weeks ago

    Ottawa, Ontario, Canada Ciena Corporation Full time

    Ciena Corporation is committed to prioritizing a personalized and flexible work environment that empowers an individual's passions, growth, wellbeing and belonging.As the Senior Business Intelligence Analytics Professional, your role will be pivotal in helping Ciena's business transition from descriptive and diagnostic analytics to predictive and...

  • Strategic Business Intelligence Consultant

    4 weeks ago

    Ottawa, Ontario, Canada Farm Credit Canada Full time

    At Farm Credit Canada, we are seeking a highly skilled Strategic Business Intelligence Consultant to join our team. We offer a competitive salary range of $103,331 - $139,803 per annum, plus eligibility for a performance-based incentive. The successful candidate will be responsible for providing expert insights and strategic recommendations to senior...

  • Specialist, Business Intelligence

    6 months ago

    Ottawa, Canada CMHC Full time

    **Job Requisition ID**: 10128 **Position Status**: Permanent Full Time **Position Type**:Hybrid **Office Location**:Ottawa (ON); Toronto (ON) **Travel Requirement**: Travel not required **Language Designation**: English Essential **Language Skill Levels (Read/Write/Speak)**: ZZZ **Salary**: Our salaries generally range from $ 83038.35 to $ 103797.93...