data engineer

Data Intuition Inc; Brampton; Vor Ort; CAD 53.000 - 76.000; Vollzeit

Benefits dieser Stelle

Paid time off (volunteering orpersonal

Zusammenfassung

Data Intuition Inc. in Brampton, ON is seeking a data professional with 2–3 years of experience to design and maintain data models, warehouses and databases.

The role involves building predictive models, and communicating insights to business and technical teams within a fast-paced IT environment. The position requires hands-on work at the client site, with a fixed hourly rate and standard 35-hour work week.

Qualifikationen

• 2 years to less than 3 years experience in IT.
• Experience working on data modelling, warehousing and databases.
• Ability to communicate technical concepts to non-technical stakeholders.

Aufgaben

• Assess and troubleshoot applications software
• Build predictive models
• Communicate business and technical benefits of analytic solutions to audiences
• Conduct studies to aid decisions on system implementation
• Data collection and processing research
• Coordinate development, installation, integration of computer-based systems
• Develop queries and logic to generate reports
• Discover trends in large data sets
• Document technical requirements to meet business needs
• Extract information from unstructured data
• Prepare plans to maintain software
• Upgrade and maintain software
• Design and develop database
• Lead and coordinate teams in software and information systems projects
• Develop data policies, standards and models
• Write scripts for stored procedures and triggers
• Perform security and quality controls
• Test software applications and information systems

Kenntnisse

Data modelling

Data warehousing

Database administration

SQL

Python

ETL

Big data

Cloud

Tools

Jira

Excel

AWS

Teradata

Informatica

SQL Server

Oracle

Jobbeschreibung

Job details

• Location Brampton , ON L6T 5B6
• Salary 47.00 hourly / 35 hours per week
• Terms of employment Permanent employment Full time
• Data modelling/warehousing and database administration
• Computer technology/computer systems technology

Experience

2 years to less than 3 years

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

Work setting

• Information technology (IT) infrastructure
• Information technology (IT) service provider
• Fast moving consumer goods (FMCG)

Responsibilities

Tasks

• Assess and troubleshoot applications software
• Build predictive models
• Communicate the business and technical benefits of the analytic solution to both business and technical audiences
• Conduct business and technical studies to aid in decisions on system implementation or migration
• Conduct research regarding availability and suitability of data
• 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 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
• 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
• Use ensemble modelling to combine multiple algorithms to obtain better predictive performance
• Design and develop database
• Design, develop and implement information systems business solutions
• Provide advice on information systems strategy, policy, management and service delivery
• 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
• Develop policies, procedures and contingency plans to minimize the effects of security breaches
• 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
• Develop and implement policies and procedures throughout the software development life cycle
• 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
• Develop policies and procedures for network access and usage and for the backup and recovery of data
• 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
• Resolve conflict situations
• Usability testing
• Operate automatic or other testing equipment to ensure product quality
• Conduct tests and perform security and quality controls
• Execute and document results of software application tests and information and telecommunication systems tests

Experience and specialization

Computer and technology knowledge

• Advanced Business Application Programming (ABAP)
• Agile
• Cloud
• Development and operations (DevOps)
• Excel Visual Basic for Applications (VBA)
• IBM DataStage
• Informatica
• Information Technology Infrastructure Library (ITIL)
• Internet of things (IoT)
• Jira
• Mainframe
• Matrix Laboratory (MATLAB)
• Microsoft Visual Studio
• Shell script
• TERADATA
• Data Warehouse
• DB2
• C
• Unix
• C++
• Erwin
• COBOL
• JavaOS
• MS Access
• MS SQL Server
• Networking software
• Networking hardware
• HTML
• MS Windows
• Networking security
• Servers
• Java
• Security software
• MySQL
• Oracle
• Object-Oriented programming languages
• Visual Basic
• Project management software
• Programming software
• HTML editing software
• Visual C++ / MFC
• Website creation and management software
• .NET
• SQL
• Mapping and data visualization software
• Database software
• Programming languages
• Development of computer applications
• Data analysis software
• MS Office
• Spreadsheet
• Enterprise resource planning (ERP) software
• Amazon Web Services (AWS)
• Git
• React.js
• Scala
• Python
• Soap
• XML
• Atlassian Confluence
• SAP BI BusinessObjects
• Firewall
• GitHub
• Hibernate
• IntelliJ IDEA
• Manual Testing
• Microservices
• MS Active Directory
• Oracle Aconex
• Performance testing
• Postman
• Software quality assurance
• TypeScript
• Ubuntu
• Unix Shell Scripting
• Virtual Storage Access Method (VSAM)
• Visualforce
• Vue.js
• Electronic mail
• MS Excel
• MS Outlook

Area of work experience

• Design
• Quality assurance or control

Area of specialization

• System integration
• Technical support
• Testing
• Business methods analysis

Additional information

Security and safety

• Criminal record check

Work conditions and physical capabilities

• Ability to work independently
• Fast-paced environment
• Work under pressure

Personal suitability

• Accurate
• Client focus
• Efficient interpersonal skills
• Initiative
• Judgement
• Organized
• Team player
• Flexibility
• Accountability
• Dedication
• Analytical
• Proactive
• Quick learner
• Group insurance benefits

Other benefits

• Paid time off (volunteering or personal days)

Who can apply for this job?

You can apply if you are:

• a permanent resident of Canada
• a temporary resident of Canada with a valid work permit

Do not apply if you are not authorized to work in Canada. The employer will not respond to your application.

Important notice: This job posting was posted directly by the employer on Job Bank. The Government of Canada has taken steps to make sure it is accurate and reliable but cannot guarantee its authenticity.

Data Intuition Inc

• Professional, scientific and technical services
• 1job posting advertised
• Medium-sized business(between 5 and 100 employees)