Data Engineer - North Bay, ON, Canada - Ontario Northland

Ontario Northland North Bay, ON, Canada

2 weeks ago

Description

Data Developer, Engineer

REPORTS TO:
Manager, IT Development

DEPARTMENT:
Information Technology Services (ITS)

Ontario Northland Transportation Commission (ONTC) is an Agency of the Province of Ontario that provides efficient and vital transportation services.

We employ over 900 skilled professionals and are over 120 years old and proud of our heritage and connection to the communities we serve.

We are focused on moving forward with the goal of being a valued leader in transportation.

We offer competitive salary, excellent benefits, a defined benefit pension plan, paid vacation, 3 paid personal leave days along with discounted transportation on our bus and passenger rail services.

The Data Developer, Engineer role is to design, plan, implement, coordinate, architect, monitor, and maintain our robust data architecture to support the organization's data needs.

This role is responsible for developing and maintaining a data architecture blueprint for the organization.

This individual will oversee testing of the interoperability of data modules under development in-house, commercial off-the-shelf software, and external third party software.

Design and implement scalable and efficient data architectures to support business requirements
Develop and maintain data models, schemas, and structures for optimal performance
Manage and optimize databases to ensure high performance and reliability
Implement data security measures and enforce data privacy policies
Orchestrate integration projects and corresponding strategies between business units and development teams
Design and implement Extract, Transform, Load (ETL) processes to move and transform data between systems
Ensure that integration projects meet business requirements and goals, fulfill end-user requirements, and identify and resolve data synchronization issues
Integrate data from various sources to provide a unified and accurate view of the organization's data
Collaborate with teams to understand data integration requirements and implement effective solutions
Collaborate with project resources and stakeholders in the testing of newly integrated software programs and applications
Liaise with internal and 3rd party software developers and engineers to address issues with data integrations or bridges
Create and maintain comprehensive documentation for data architecture, databases, and data processes
Troubleshoot and resolve issues related to data processing and storage
Collaborate with stakeholders to understand and address data quality issues
Ensure the collection and coherent interpretation of the various business processes affected by integration efforts
Evaluate results of integration projects, then report and make recommendations based on findings
Where necessary, provide guidance to junior members of the team
Other duties as assigned by the Manager, IT Development
College diploma or University degree in Computer Science, Information Technology, or a related field
~Extensive experience with at least two different computing platforms, operating systems, database technologies, programming languages and communication protocols
~ Proven experience as a Data Developer, Database Developer, or a similar role
~ Strong proficiency in SQL and database management systems
~ Experience with data modeling, API's (Application Programming Interface) and ETL (Extract, Transform, Load) tools
~ Experience with reporting tools such as SQL Server Reporting Service, Power BI
~ Experience with big data technologies (e.g., Familiarity with data governance, compliance, data security and privacy best practices
~ Knowledge of cloud-based data solutions (e.g., Programming skills in languages like JavaScript, .NET, CSS, AWS, RPG, Perl

Qualified individuals are invited to apply in writing with a current covering letter and resume (provided in one document), stating reference name and number.

Accommodation is available for applicants with
disabilities throughout the recruitment process. Les offres d'emploi sont également disponibles en français. Visitez notre site Web sur les carrières ou appelez le , poste 394 pour plus de renseignements. #

Data Developer, Engineer

3 weeks ago

Ontario Northland North Bay, Canada Full time

POSITION: Data Developer, Engineer · REPORTS TO: Manager, IT Development · DEPARTMENT: Information Technology Services (ITS) · LOCATION: North Bay · REFERENCE: · SALARY: $80,730- $94,990 · WHO WE ARE: · Ontario Northland Transportation Commission (ONTC) is an Agency of the ...
Pole Line Surveyor

1 week ago

Mainline Construction North Bay, Canada

**Responsibilities** · - performs site surveys to collect, analyze, and organize basic engineering data,**pole survey and measurement of various attachment heights, span distances, angles, etc...** to assist the engineering team in developing design layouts and preparing all engi ...
Traffic Analyst

1 week ago

Ministry of Transportation Thunder Bay, Canada

Are you looking for an opportunity to develop your traffic analysis career in an exciting environment with opportunities for growth? Do you have strong technical analysis skills and the energy and enthusiasm to be part of a team delivering highway design and construction projects ...
Ontario Land Surveyor

2 days ago

TBT Engineering Thunder Bay, Canada

Join our team of experts and work in beautiful Northwestern Ontario with TBT Engineering's Legal Surveys & Geomatics division. · **Full Description**: · - Completing and coordinating land surveys involving: · - Retracement of original township boundaries and water boundaries · - ...
Surveyor

1 week ago

exp North Bay, Canada

Are you ready to design your future? · Be our next **Surveyor** · **Your work environment at EXP · In this role, you will join the **infrastructure **group, based in our North Bay office. · **What a day at EXP has in store for you** · - Set up and use GPS equipment for topographi ...
Field Coordinator

2 days ago

PME Inc. Thunder Bay, Canada

**Connect with us **LinkedIn**, **Instagram**, **Facebook**, **Twitter** · **Thinking about a change?** · We recognize that the construction industry is changing at a rapid pace and we continually strive to be at the forefront. Our core** values** empower people to deliver great ...
Materials Coordinator

1 week ago

Redpath Mining Contractors and Engineers North Bay, Canada

**Application Deadline: March 30, 2023** · **This position is located in North Bay, Ontario. This is not a remote position and the successful applicant will be required to work out of our North Bay location.** · The Materials Coordinator is responsible to coordinate, facilitate a ...
Mining Construction Technician

1 hour ago

TULLOCH North Bay, Canada

**Come Join Us** · **_ "We want to build an organization where everyone loves their job and their leaders care for them"_** · Over the last 30 years, TULLOCH has built a robust multi-disciplinary consulting engineering firm recognized Canada-wide for its strengths in the diverse ...
Mining Construction Technician

1 hour ago

TULLOCH Thunder Bay, Canada

**Come Join Us** · **_ "We want to build an organization where everyone loves their job and their leaders care for them"_** · Over the last 30 years, TULLOCH has built a robust multi-disciplinary consulting engineering firm recognized Canada-wide for its strengths in the diverse ...
Infrastructure Co-op Student

1 hour ago

exp North Bay, Canada

Are you ready to design your future? · Be our next **Infrastructure Co-op student · **Your work environment at EXP** · In this role, you will be a part of the **infrastructure **team, based in the North Bay office · **What a day at EXP has in store for you** · - Assisting with th ...
Manager, Data Centre Operations

2 days ago

Hut 8 Corp North Bay, Canada

**ABOUT HUT 8** · Imagine the ultimate destination for those who want to work at the cutting edge of technology, energy, and infrastructure. An industry leader in bitcoin mining, Hut 8 builds and operates some of the world's largest data centers for next-generation computing work ...
Geomatics Project Manager

1 hour ago

TULLOCH Thunder Bay, Canada

**Come Join Us** · **_ "We want to build an organization where everyone loves their job and their leaders care for them"_** · Over the last 30 years, TULLOCH has built a robust multi-disciplinary consulting engineering firm recognized Canada-wide for its strengths in the diverse ...
Operations Technician

2 days ago

Tbaytel Thunder Bay, Canada

Company Biography · Tbaytel is a leading regional provider of telecommunications products and services. We are a dynamic, growth-oriented company committed to investing in the people and organizations that help build strong and healthy communities throughout the entire region we ...
Project Controller

6 days ago

Redpath Mining Contractors and Engineers North Bay, Canada

The Project Controller is responsible for the planning and performance monitoring of assigned projects, including providing guidance to operational managers through the implementation of project controls processes, procedures and contracts. The incumbent will track performance da ...
Project Controls Specialist

1 day ago

Redpath Mining North Bay, Canada

The Project Controls Specialist is responsible for the planning and performance monitoring of a group of assigned projects, including providing guidance to operational managers through the implementation of project controls processes, procedures and contracts. The incumbent must ...
Operations Technician

1 week ago

Tbaytel Thunder Bay, Canada

Company Biography · Tbaytel is a leading regional provider of telecommunications products and services. We are a dynamic, growth-oriented company committed to investing in the people and organizations that help build strong and healthy communities throughout the entire region we ...
Construction Inspector

1 hour ago

ASF Associates Inc. Thunder Bay, Canada

Requirement: EIT or RCSI / RCJI (OACETT) · ASF is currently looking for a Construction Inspector for our Transportation group in the Ontario market. As a dynamic and growing engineering consulting firm, ASF, is full of opportunities for career development. · **Responsibilities**: ...
Field Data Collector

1 week ago

MOBIA Technology Innovations Thunder Bay, Canada

Thunder Bay ON, Kenora ON, Fort Frances ON. · MOBIA Technology Innovations is a Systems Integration company with multiple business unit areas: Broadband & Wireless Services, Managed Services, Infrastructure Solutions, Cybersecurity and Application & Data Services. Working with Se ...
Geomatics Project Manager

1 week ago

TULLOCH North Bay, Canada

**Come Join Us** · **_"We want to build an organization where everyone loves their job and their leaders care for them"_** · Over the last 30 years, TULLOCH has built a robust multi-disciplinary consulting engineering firm recognized Canada-wide for its strengths in the diverse s ...
Survey/quality Control Field Technician

4 days ago

AD Technical Services Thunder Bay, Canada

AD Technical Services is a professional engineering firm focused on providing project management and quality control support to heavy civil construction projects in Northwestern Ontario. Our staff are trained to assist our clients from project planning, through construction, and ...