data engineer

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 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
• 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)
• Cloud
• Development and operations (DevOps)
• Excel Visual Basic for Applications (VBA)
• Informatica
• PowerBuilder
• Data Warehouse
• MS Access
• MS SQL Server
• HTML
• Servers
• Desktop applications
• 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
• Development of computer applications
• Data analysis software
• MS Office
• Spreadsheet
• Enterprise resource planning (ERP) software
• Amazon Web Services (AWS)
• Hadoop
• Scala
• MS Outlook
• Database

Area of work experience

• Design
• Quality assurance or control

Security and safety

• Criminal record check

Work conditions and physical capabilities

#J-18808-Ljbffr