data engineer

Education

• Bachelor's degree

Work setting

• Information technology (IT) infrastructure
• Information technology (IT) service provider
• Information technology
• Information technology (IT) consulting

Tasks

• Assess and troubleshoot applications software
• Conduct business and technical studies to aid in decisions on system implementation or migration
• 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
• Discover trends and patterns within large amounts of information
• Document technical requirements to ensure that products, processes and solutions meet business requirements
• Extract information from unstructured sets of data
• Prepare plan to maintain software
• Upgrade and maintain software
• Design and develop database
• Operate database management systems to analyze data
• Lead and co-ordinate teams of information systems professionals in the development of software and integrated information systems, process control software and other embedded software control systems
• Research and document data requirements, data collection and administration policy, and data access rules
• Lead and co-ordinate teams of data administrators in the development and implementation of data policies, standards and models
• Write scripts related to stored procedures and triggers

Supervision

• 3-4 people

Certificates, licences, memberships, and courses

• Microsoft SQL Certification
• Microsoft certified professional (MCP)

Computer and technology knowledge

• Agile
• Automatic data processing (ADP)
• Business intelligence
• Cloud
• Development and operations (DevOps)
• Informatica
• Data Warehouse
• MS SQL Server
• Programming software
• SQL
• Mapping and data visualization software
• Database software
• Programming languages
• Data analysis software
• Git
• Hadoop
• Python
• Database
• Data analysis and interpretation
• Database management

Area of work experience

• Project implementation
• Information technology (IT) service delivery
• Design

Security and safety

• Criminal record check

Work conditions and physical capabilities

• Ability to work independently
• Fast-paced environment
• Work under pressure
• Tight deadlines
• Repetitive tasks
• Attention to detail
• Sitting

Personal suitability

• Accurate
• Client focus
• Efficient interpersonal skills
• Excellent oral communication
• Excellent written communication
• Initiative
• Organized
• Team player
• Flexibility
• Adaptability
• Accountability
• Dedication
• Innovation
• Analytical
• Proactive
• Quick learner

Screening questions

• Are you authorized to work in Canada?
• Are you available for shift or on-call work?
• Are you available to start on the date listed in the job posting?
• Are you willing to relocate for this position?
• Do you have the required certifications listed in the job posting?

Experience

• 5 years or more

Employment terms options

• On call
• Day
• Weekend
• Overtime required
• Overtime available

Health benefits

• Dental plan
• Health care plan
• Vision care benefits

Long term benefits

• Maternity and parental benefits

Other benefits

• Team building opportunities
• Parking available