Job Search and Career Advice Platform

Enable job alerts via email!

data engineer

Government of Canada

Dieppe

On-site

CAD 70,000 - 90,000

Full time

Yesterday
Be an early applicant

Generate a tailored resume in minutes

Land an interview and earn more. Learn more

Job summary

A governmental organization in Canada is looking for an IT professional with a Bachelor's degree and certifications in Microsoft SQL and Oracle. Responsibilities include coordinating client projects, developing information systems, and ensuring data integration and security. Candidates should have at least 3 years of relevant experience and be proficient in various programming languages and IT tools. The position is on-site with no remote option, providing a collaborative work environment.

Benefits

Free parking available

Qualifications

  • 3 years to less than 5 years of experience in IT roles.
  • Microsoft SQL Certification and Oracle Certification are necessary.
  • Knowledge of data processing, data analysis tools, and IT service delivery.

Responsibilities

  • Confer with clients to identify requirements.
  • Coordinate the development and operation of computer-based systems.
  • Design and develop information systems business solutions.

Skills

Data analysis
Cloud computing
Project management
Business intelligence
DevOps
Database management

Education

Bachelor's degree

Tools

Microsoft SQL
Oracle
Amazon Web Services (AWS)
MS SQL Server
HTML
JavaScript
Excel VBA
Data visualization software
Job description
Overview Languages

English

Education
  • Bachelor's degree
Experience

3 years to less than 5 years

On site

Work must be completed at the physical location. There is no option to work remotely.

Work setting
  • Consulting firm
  • Information technology (IT) infrastructure
  • Service company
  • Software company
  • Information technology (IT) service provider
  • Data processing and computers
Responsibilities Tasks
  • Confer with clients to identify requirements
  • Coordinate the development, installation, integration and operation of computer-based systems
  • Data Science
  • Design methods of collecting and processing data to answer specific research questions
  • Develop data mapping methods
  • Develop process and network models to optimize architecture
  • Develop queries and logic to generate reports
  • Document technical requirements to ensure that products, processes and solutions meet business requirements
  • Extract information from unstructured sets of data
  • Highlight key data sources and the methodology to be used on a specific project
  • Prepare plan to maintain software
  • Provide advice on the selection of automated anomaly detection systems
  • Research data collection and administration policy
  • Synthesize technical information through creation of data visualization
  • Upgrade and maintain software
  • Design and develop database
  • Design, develop and implement information systems business solutions
  • Assess physical and technical security risks to data, software and hardware
  • Operate database management systems to analyze data
  • Develop and implement data administration policy, standards and models
  • Research and document data requirements, data collection and administration policy, and data access rules
  • Conduct reviews to assess quality assurance practices, software products and information systems
  • Write scripts related to stored procedures and triggers
  • Resolve conflict situations
  • JavaScript Object Notation (JSON)
  • Conduct tests and perform security and quality controls
Credentials Certificates, licences, memberships, and courses
  • Microsoft SQL Certification
  • Oracle Certification
Experience and specialization Computer and technology knowledge
  • Automatic data processing (ADP)
  • Business intelligence
  • Cloud
  • Development and operations (DevOps)
  • Excel Visual Basic for Applications (VBA)
  • Informatica
  • PowerBuilder
  • Data Warehouse
  • MS Access
  • MS SQL Server
  • HTML
  • XML Technology (XSL,XSD,DTD)
  • Servers
  • Desktop applications
  • JavaScript
  • CSS
  • MySQL
  • Oracle
  • PHP
  • VB Script
  • Project management software
  • HTML editing software
  • Website creation and management software
  • Business diagram software
  • SQL
  • Mapping and data visualization software
  • Database software
  • Programming languages
  • Software development
  • Development of computer applications
  • Data analysis software
  • MS Office
  • Spreadsheet
  • Enterprise resource planning (ERP) software
  • Amazon Web Services (AWS)
  • Hadoop
  • Scala
  • Big data
  • MS Outlook
  • Database
Area of work experience
  • Project implementation
  • Information technology (IT) service delivery
  • Design
  • Quality assurance or control
Additional information Security and safety
  • Criminal record check
Work conditions and physical capabilities
  • Ability to work independently
  • Sitting
Personal suitability
  • Accurate
  • Client focus
  • Initiative
  • Judgement
  • Organized
  • Adaptability
  • Accountability
  • Dedication
  • Innovation
  • Analytical
  • Proactive
  • Quick learner
Benefits Other benefits
  • Free parking available
Get your free, confidential resume review.
or drag and drop a PDF, DOC, DOCX, ODT, or PAGES file up to 5MB.