Assist in intermediate level engineering tasks and fieldwork within Ottawa's municipal services. Involving data management and conducting surveys for various engineering projects.
About the role
- Senior DB/BI Developer at EveryMatrix developing data processing solutions with focus on real-time aggregations and data warehouse enhancements. Collaborating with engineering teams to support data integrations and reporting.
Responsibilities
- Develop real time data processing and aggregations;
- Create and modify data marts (enhance our data warehouse);
- Take care of internal and external integrations;
- Forge various types of reports.
Requirements
- Bachelor’s/Master’s degree in S.T.E.M.;
- Understanding of Computer Science, Software Engineering, Algorithms, Operating Systems, Networking, etc.;
- Good knowledge of at least one RDBMS (PostgreSQL, MSSQL, Oracle, MySQL) - understanding how db works - query optimisation - indexes - parttitioning.
- Practical experience with ETL/ELT porcess.
- Experience in Data Warehouse creation or supporting;
- Practical experience with at least ONE of enterprise business intelligence platforms;
- English — intermediate + (reading/writing/speaking).
Benefits
- Start with 22 days of annual leave, with 2 additional days added each year, up to 32 days by your fifth year with us.
- Stay Healthy : 10 sick leave days per year, no doctor's note required;
- 30 medical leave days with medical allowance
- Support for New Parents: 21 weeks of paid maternity leave, with the flexibility to work from home full-time until your child turns 1 year old.
- 4 weeks of paternity leave, plus the flexibility to work from home full-time until your child is 13 weeks old.
- Our office perks include on-site massages and frequent team-building activities in various locations.
- Daily catered lunch or monthly lunch allowance.
- Private Medical Subscription.
- Access online learning platforms like Udemy for Business, LinkedIn Learning or O’Reilly, and a budget for external training.
- Gym allowance
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
VP, Head of Digital Engineering overseeing IT development for Zurich Edge Platform in the APAC region. Driving technical excellence and strategic leadership for digital business growth.
Analysing, designing, and implementing Network and IT business requirements at Vodafone. Operate and support systems with a focus on operational excellence and customer experience.
AS400 Developer developing and maintaining AS400 systems, collaborating on production issues and projects using Agile methodology.
eLearning Developer creating engaging instructional content primarily through eLearning for MERS Goodwill, focusing on various training methodologies and technologies.
Facilities Engineering Specialist overseeing installation and maintenance of electrical equipment in automotive manufacturing. Supports Utilities/Operations department with technical guidance and project management.
Senior Architect leading AI - driven development architecture for Elsevier's Engineering platforms. Designing scalable systems and providing technical consultancy across various technology areas.
Senior Manager leading technical aspects of product development strategies at Coca - Cola. Collaborating with teams to enhance product and packaging innovation.
Power Platform Consultant delivering Microsoft services and solutions including PowerApps and Power Automate. Collaborating with teams and conducting training while developing low code applications.
Photonics Technician supporting customer projects by building, integrating, and testing photonic components. Involves precision lab work and collaboration with management in Chantilly, VA.