Database Developer
at Canadian Bank Note Company Limited
Ottawa, ON, Canada -
Start Date | Expiry Date | Salary | Posted On | Experience | Skills | Telecommute | Sponsor Visa |
---|---|---|---|---|---|---|---|
Immediate | 17 Dec, 2024 | Not Specified | 24 Sep, 2024 | 3 year(s) or above | Etl,Rdbms,Linux,Data Science,Time Management,Soft Skills,English,Computer Science,Sql,Python,Bash,Languages | No | No |
Required Visa Status:
Citizen | GC |
US Citizen | Student Visa |
H1B | CPT |
OPT | H4 Spouse of H1B |
GC Green Card |
Employment Type:
Full Time | Part Time |
Permanent | Independent - 1099 |
Contract – W2 | C2H Independent |
C2H W2 | Contract – Corp 2 Corp |
Contract to Hire – Corp 2 Corp |
Description:
Internal Job Title: Database Developer
Job Type: Permanent, Full-Time
Location: 18 Auriga Dr., Ottawa ON
Work Model: Hybrid
POSITION SUMMARY
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.
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 designing database structures.
- Experience in data preprocessing and dealing with missing or inconsistent data.
Technical Skills
- Languages: SQL, Bash, Python.
- O/S: Linux.
- RDBMS: PostgreSQL
- Processes: ETL, ELT, and streaming.
- Ability to monitor and debug database systems.
Soft Skills and Characteristics
- Self-directed.
- Time management.
- Teamwork/collaboration.
- Attention to detail.
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 www.cbnco.com.
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 contacted regarding this competition, please advise the interview coordinator of any accommodation measures you may require
Responsibilities:
- 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.
REQUIREMENT SUMMARY
Min:3.0Max:8.0 year(s)
Information Technology/IT
IT Software - DBA / Datawarehousing
Software Engineering
Graduate
Computer science software engineering or data science or an equivalent combination of education and years of relevant work experience
Proficient
1
Ottawa, ON, Canada