Database Developer

Canadian Bank Note; Ottawa; Hybrid; CAD 70,000 - 100,000; Full time

Job summary

Join a leading organization as a Database Developer within our Lottery Systems R&D team, where you will design and maintain data pipelines, ensuring optimal performance and reliability. We offer a competitive total compensation package, extensive learning opportunities, and a culture grounded in equality and inclusivity.

Benefits

Defined contribution pension plan with company matching contributions

Best-in-class health, medical and life insurance benefits

Access to virtual and telehealth services

Progressive fertility, adoption and surrogacy benefits

Career development and learning opportunities

Inclusive and respectful work environment

Qualifications

• 3+ years of experience working in SQL, Bash or Python.
• Experience in building and maintaining data pipelines.
• Experience in data preprocessing and dealing with missing or inconsistent data.

Responsibilities

• Design, build, and maintain data pipelines using ETL, ELT, and streaming methodologies.
• Manage database systems for optimal performance.
• Monitor, debug, and fix performance issues.

Skills

SQL

Bash

Python

Education

University degree in Computer Science, Software Engineering, or Data Science

Job description

As a Database Developer in our Lottery Systems R&D team, you will design, build, and maintain data pipelines, manage database systems, and preprocess data for analysis. You will also monitor and resolve performance issues while collaborating with developers, data scientists, and analysts to meet their data needs. Your work will ensure the reliability and efficiency of our lottery systems, promoting trust and transparency for all of our users.

What We Can Offer You

• Compensation : We seek long term relationships with our employees and recognize and reward them with a competitive total compensation package that includes : An industry leading defined contribution pension plan with company matching contributions (up to 5%) and payment of service fees,Best-in-class health, medical and life insurance benefits;Access to virtual and telehealth services and apps; andVery progressive fertility, adoption and surrogacy benefits to support all definitions of family.
• Career : As a knowledge-based organization we will provide you with a wealth of learning opportunities and challenging work that will grow your knowledge, skills and abilities. At CBN, we encourage and empower our employees to chart their own career path, putting you in control of your future.
• Culture : Personal character is the foundation of our culture. CBN’s 7 Core Principles shape and guide our behaviours and underpin the sense of community you will experience at CBN. Equality, diversity and inclusivity are important to us as an organization, and we are committed to fostering and developing a work environment where every employee is treated with dignity and respect.

What You Will Do

• Design, build, and maintain data pipelines using ETL, ELT, and streaming methodologies from a variety of sources;
• Manage database systems to ensure they are optimal, performant, and able to effectively store and retrieve data;
• Monitor, debug, and fix performance issues in the database systems and data pipelines;
• Design database structures that support the needs of Developers, Data Analysts, and Data Scientists;
• Preprocess data to make it suitable for analysis, dealing with issues like missing or inconsistent data;
• Work closely with other team members, like Developers, Data Scientists and Analysts, to understand their data needs and ensure they have the right data in the right format; and
• Various other duties and responsibilities.

Qualifications

Knowledge and Experience

• University degree in Computer Science, Software Engineering, or Data Science, or an equivalent combination of education and years of relevant work experience.
• 3+ years experience working in SQL, and Bash or Python.
• Experience in building and maintaining data pipelines.
• Experience in data preprocessing and dealing with missing or inconsistent data.

Technical Skills

• Languages : SQL, Bash, Python.
• Processes : ETL, ELT, and streaming.
• Ability to monitor and debug database systems.

Soft Skills and Characteristics

• Self-directed.
• Time management.

Mandatory Requirements

• Fluency in English.
• Ability to work outside of normal business hours on occasion.

Security Clearance Requirements

• Ability to obtain and maintain Government of Canada Secret (Level II) personal security clearance.

About Us

CBN designs and develops industry leading solutions for the following domains : Border Security, Civil Identity, Driver Identification and Vehicle Information, Currency and Excise Control, and Lottery and Charitable Gaming. To learn more, visit .

As an Equal Opportunity Employer, Canadian Bank Note Company, Limited is committed to achieving a skilled workforce that reflects the diversity of the Canadian population. We encourage applications from women, visible minorities, people with disabilities and Aboriginal people. Canadian Bank Note Company Limited is committed to developing inclusive, barrier-free selection processes and work environments. If contactedregardingthis competition, pleaseadvisethe interview coordinator of any accommodation measures you mayrequire.

Create a job alert for this search