Icon hamburger
Briefcase

Create Job Alert.

Enter your email below to save this search and receive job recommendations for similar positions.
Thank you. We'll send jobs matching these to
You already suscribed to this job alert.
No Thanks
CA
What job do you want?

Create Job Alert.

Get similar jobs sent to your email

Apply to this job.
Think you're the perfect candidate?
Apply Now
Thumsup

You’re being taken to an external site to apply.

Job Requirements

Requirements 


• BS or MS in Computer Science, Information Management, or related field 

• 5+ years of experience as a Data Engineer. 

• Candidate must have a deep understanding of logical and physical data modeling for OLTP and OLAP systems. 

• Ability to translate a logical data model into a relational or non-relational solution as appropriate 

• Familiar with multiple relational platforms, recent MSSQL Server experience is required. 

• Hands-on expertise in database development using views, T-SQL, MSSQL and/or SQL scripts and SSIS packages and transformations. Experience building and troubleshooting SSAS cubes. 

• Fluent in using tools like SQL Server Management Studio or similar. 

• Recent experience in SQL tuning, indexing, partitioning, data access patterns and scaling strategies 

• Programming/Scripting experience in Windows (C#, PowerShell) as well as Unix/Linux environments (Python, Bash) 

Do you have these requirements?

Enter your email below to receive job recommendations for similar positions.
Data Engineer at Impressico Business Solutions

Data Engineer

Impressico Business Solutions Toronto, Ontario Contractor
Apply Now

Create Job Alert.

Get similar jobs sent to your email

*Data Engineer, Impressico Business Solutions, Canada*


Impressico Business Solutions, a leader in providing result-driven digital transformation consulting is looking for an experienced, innovative, and highly motivated Data Engineer for expanding and optimizing data and data pipeline architecture, as well as optimizing data flow. This is contract role based out in North York, Ontario. This is a 3 to 6 months contract role.


Primary Responsibilities 

• Design, build and launch extremely efficient & reliable data pipelines to move data to our Data Warehouse/Data Mart. 

• Own end-to-end data quality for the data pipelines you build 

• Develop ETL routines to populate databases from multiple disparate data sources and create aggregates 

• Create and run data migrations across different servers and different databases including Enterprise CRM and ERP applications. 

• Perform complex data transformations, create/update stored procedures/functions, and optimize existing stored procedures/functions using indexing, temp tables, views, logic changes, etc. 

• Design/develop new systems and tools to enable stakeholders to consume and understand data faster 

• Data cleansing and manipulation using your expert SQL & programming skills 

• Troubleshoot data issues and present solutions to the issues 

• Prepare activity and progress reports regarding database & data health and status 

• Design and improve agile development processes as it applies to data and data structure design 

• Design, code and automate data quality checks, metrics, standards and guidelines 

• Work across multiple teams in high visibility roles and own the solution end-to-end 



Requirements 


• BS or MS in Computer Science, Information Management, or related field 

• 5+ years of experience as a Data Engineer. 

• Candidate must have a deep understanding of logical and physical data modeling for OLTP and OLAP systems. 

• Ability to translate a logical data model into a relational or non-relational solution as appropriate 

• Familiar with multiple relational platforms, recent MSSQL Server experience is required. 

• Hands-on expertise in database development using views, T-SQL, MSSQL and/or SQL scripts and SSIS packages and transformations. Experience building and troubleshooting SSAS cubes. 

• Fluent in using tools like SQL Server Management Studio or similar. 

• Recent experience in SQL tuning, indexing, partitioning, data access patterns and scaling strategies 

• Programming/Scripting experience in Windows (C#, PowerShell) as well as Unix/Linux environments (Python, Bash) 

Recommended skills

Bash
C#
Data Modeling
Microsoft Olap Services
Mssql
Oltp
Apply to this job.
Think you're the perfect candidate?
Apply Now

Help us improve by providing feedback about this job: Report this job

Report this Job

Once a job has been reported, we will investigate it further. If you require a response, submit your question or concern to our Trust and Site Security Team

TIP

For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using you are agreeing to comply with and be subject to the Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.