Analyst - Systems II

Canadian Blood Services; Ottawa; Hybrid; CAD 80,000 - 95,000; Full time

Job summary

Join a leading organization as an Analyst - Systems II in Ottawa, Ontario, where you will focus on data engineering projects. This role involves creating data pipelines, collaborating on BI initiatives, and ensuring data quality. With a hybrid work environment, you will contribute to improving lives through effective IT services.

Benefits

4 weeks' vacation

Annual performance award up to 6%

Comprehensive health benefits

Defined benefit pension plan

Employee discounts and wellness program

Qualifications

• 3-5 years of experience in data integration and transformation.
• Proficient in SQL and T-SQL for data analysis.
• Experience with ETL pipelines and cloud-based data platforms.

Responsibilities

• Create and manage data pipelines for business insights.
• Collaborate on BI initiatives and support project lifecycle.
• Ensure accuracy and reliability of data collected.

Skills

Data Analysis

Data Integration

Collaboration

Data Quality

Source Code Management

Education

University Degree in Computer Science

Tools

Azure Synapse Analytics

Microsoft Fabric

Power BI

Python

Git

Job description

Join to apply for the Analyst - Systems II role at Canadian Blood Services

Join to apply for the Analyst - Systems II role at Canadian Blood Services

Please note this role will work in a hybrid environment. The successful candidate will be working a mixture of on-site and off-site work from our office at 2540 Lancaster Road, Ottawa, Ontario, based on the parameters for our operations to meet the needs of our donors, our staff and our communities. Currently, employees are expected to have an in-person presence for at least 40% of their work time. This requirement may vary depending upon circumstances.

Job category: Information technology

Job posting ID: 7255

Employment status: Regular full-time

Position's anticipated start date: 2025-06-30

Classification: PTS/MGT/IT B

Salary/Rate of pay: $80,078 - $94,028

Application deadline: 2025-05-23

• This external job posting may close earlier than the advertised deadline. We recommend applying as soon as possible.
  
  
  

Application requirements:

• Your up-to-date resume.
• We recommend you save a copy of the job posting for reference throughout the recruitment process.
  
  
  

Do you currently work for Canadian Blood Services? All employees must apply via the internal career page .

Together, we can make all the difference in the lives of others.

Be part of a dynamic, collaborative and caring organization committed to saving and improving lives. Thousands of patients depend on us every day for reliable access to safe blood, plasma, stem cells and organs and tissues.

If you are looking for a rewarding experience with a values and mission-driven team, join Canada’s Lifeline and make a meaningful difference.

We acknowledge that the work of Canadian Blood Services spans many Territories and Treaty areas across the country, and we are grateful for the Traditional Knowledge Keepers and Elders who have guided us in this important work. We recognize the land and waters that have inspired our work and offer gratitude to those Indigenous peoples on whose territory we work, live and play.

About The Role

Canadian Blood Services is looking for a Regular Full-Time Analyst - Systems II to join our dynamic IT Internal Customer Experience team in Ottawa, Ontario.

The IT Internal Customer Experience team is responsible for managing the delivery and operation of IT services related to employee experience and productivity, blood operations, data & analytics and optimization, making IT more effective, reliable and consistent.

In this role, you will be focused on data engineering projects using your knowledge of data extraction, transformation, and loading skills. You will apply systems thinking (i.e. the intersection of data, technology and people) to resolve or improve complex business challenges and opportunities.

Formula for success

• Deploying your proficiency in data acquisition and cleansing, you will create and manage data pipelines to drive business insights and efficiencies.
• Drawing upon your skills in data analysis and development, you will design and develop analytical models to deliver BI solutions according to customer requirements.
• Employing your collaborative abilities, you will collaborate with team members on multiple BI initiatives, providing support throughout the project lifecycle.
• Applying your commitment to data quality, you will ensure the accuracy, reliability, and quality of data collected and analyzed.
• Utilizing your expertise in source code management, you will complete source code deployments in all environments (Dev, QA, and Production).
• Exercising your monitoring and optimization skills, you will monitor published BI content and usage to ensure consistency, privacy, and performance.
• Harnessing your knowledge and expertise in user support, you will provide end user support by addressing queries and issues effectively.
  
  
  

Desired Education And Skills

• Degree in a relevant discipline from a recognized academic institution, preferably a University Degree in computer science, computer engineering or related field; an equivalent combination of education, training and experience may be considered.
• Three to five years of data integration, data transformation, and data pipelines. Experience working in an Analytics/Data Warehouse environment.
• Proven experience developing and optimizing ETL pipelines in Azure Synapse Analytics, Microsoft Fabric, or other cloud-based data platforms.
• Advanced knowledge of analytical data models including star and snowflake schemas. Advanced proficiency in SQL and T-SQL, including query optimization and complex transformations.
• Excellent working knowledge of Microsoft Fabric including Power BI, DAX, M Query, Direct Lake, Dataflows, and Dataset integration.
• Familiarity with automation tools such as PowerShell, Azure CLI, and Jenkins.
• Programming skills using Python, PySpark, R, SAS, SPSS, and background in developing APIs.
• Hands-on experience with GIT-based CI/CD pipelines for automating deployment and version control
• Experience with the following technologies is an asset: AI or machine learning, SAPBW, Google Analytics.
• Team player with experience collaborating with BI developers, data scientists, and IT or business stakeholders.
  
  
  

What We Offer You

• 4 weeks' vacation.
• Annual performance award up to 6%.
• Comprehensive group health, dental and vision benefits for you and your family.
• Defined benefitpension plan.
• Employee discounts, wellness program, professional resources.
  
  
  

What You Can Expect

• This role will work in a hybrid environment with requirements to be onsite at 2540 Lancaster Road, Ottawa, Ontario, at least 40% of the time/2 days of the week.
• You will work Monday to Friday, 37.5 hours per week, 7.5 hours per day.
  
  
  

Diversity and inclusion play a vital role in ensuring health equity for patients across Canada. We are committed to reflecting Canada’s population in our organization and fostering an environment where all employees can be their authentic selves, with equal opportunities to succeed and contribute.

If this role resonates with you, we encourage you to apply by providing your up-to-date resume. This could be your first step towards a meaningful and inspiring career. Come to work each day knowing that you save lives.

We thank all applicants for their interest. However, only those considered for an interview or those invited to participate in an assessment will be contacted. Emails are sent directly from our system, to ensure you receive them please add [e-mail] and [e-mail] to your safe senders list.

Applicants who require accommodation should discuss their needs with us.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Hospitals and Health Care, Non-profit Organizations, and Biotechnology Research

Referrals increase your chances of interviewing at Canadian Blood Services by 2x

Sign in to set job alerts for “System Analyst” roles.

Technical Analyst, Cyber Risk Management Reporting, Deloitte Global Technology

Senior Business Systems Analyst – Identity and Access Management (IAM)

Greater Ottawa Metropolitan Area 1 day ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.