data engineer Montreal
Job description
Position: Data Engineer
Location: Montreal, QC (2-3 days/week in office is must)
Duration: 12 Months
Position Description:
The ideal candidate should have the skills listed below but in addition should be a self-driven, dedicated individual who works well in a team and thinks and acts strategically. In addition, the candidate should respond well to change and quickly pick up new concepts in an ever-moving regulatory landscape. When faced with a problem, the candidate should be able to ask questions and leverage the skill set of those around him/her. Daily responsibilities include, architecting, designing, modeling and supporting databases & applications, attending scrum meetings, reporting on project status, and learning our in-house frameworks and database development best practices. The work environment comprises of an energetic team of highly intellectual and creative developers who work on bleeding edge projects using a variety of different technologies.
The applicant will work as part of an agile development team in providing database architecture to support functions in maintaining and continuously enhancing a set of OLTP and DWH applications. The applicant should be a solid database architect with expertise in working with business in understanding requirements, architecting, designing and modeling high performing database structures and objects using industry standard relational databases. The candidate will also have proven hand-on expertise in SQL and database procedural languages like SQL/PL and PL/SQL towards building, guiding and supporting DB and BI Developers in meeting their data access needs, helping them in troubleshooting their day to day issues and optimizing queries. The applicant will closely work with the team and perform SDLC management tasks learning and adopting to firm established standards and perform production deployment as when needed. As needed, will raise to occasions in attending to and resolving production incidents in a timely manner.
Skills Required:
- 5 to 7 years of hands-on experience in relational database development using SQL and SQL/PL in IBM DB2 UDB (10+) and Oracle(12C+) environments. Should be able to understand requirements and write high performing SQL queries and SQL/PL. PL/SQL procedures and packages optimized for OLTP, BI reporting and analytics.
- 3 to 4 years of expertise in relational database architecture, modeling, and database design principles.
- Expertise in using one or more industry standard relational database modeling tools
- Strong hands-on experience in the associated systems and software components including but not limited to Linux, Unix, shell scripting, version management with git and batch job schedulers with practical experiencing of leveraging the same during development.
- Strong analytical and problem-solving skills. Should be able to troubleshoot and optimize queries.
- Self-starter, take ownership and accountability in handling end-to-end DB SDLC requirements
- Team player with strong attitude and work ethics.
- Strong oral and written communication skills. Candidate is expected to work with global teams and hence should be clear in both verbal and written communication.
- Write unit tests that exercise all database components of the deliverables.
Skill Desired:
- Oracle and IBM certifications in Relational Database Modeling and Development
- Hands-on experience in MS SQL Server
- Application level DBA skills on Oracle and IBM DB2 UDB
- Database Modeling using SAP Power Designer
- Meta data modeling for BI tools like SAP Business Objects, Cognos
- Optimize DB Structures and Objects for Analytics and Dashboarding using SAP BOXI, Tableau & Power BI
- Exposure to design and development principles using NOSQL and XML-based technologies
- SPARQL knowledge and familiarity with graph databases
Job Types: Full-time, Fixed term contract
Contract length: 12 months
Salary: Up to $60.00 per hour
Ability to commute/relocate:
- Montréal, QC H3C 0A1: reliably commute or plan to relocate before starting work (required)
Work Location: Hybrid remote in Montréal, QC H3C 0A1
