data engineer

Education

• Bachelor's degree

Work setting

• Consulting firm
• Information technology (IT) infrastructure
• Service company
• Software company
• Information technology (IT) service provider
• Data processing and computers

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

Certificates, licences, memberships, and courses

• Microsoft SQL Certification
• Oracle Certification

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

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

Screening questions

• Are you authorized to work in Canada?
• Are you currently a student?

Experience

• 3 years to less than 5 years

Employment terms options

• Day

Other benefits

• Free parking available