This job board retrieves part of its jobs from: Emploi Étudiant | Toronto Jobs | Work From Home

Tech jobs every day in Canada!

To post a job, login or create an account |  Post a Job

   Canadian Tech jobs   

Website updated every day with fresh jobs in the IT industry

Slide 1
Slide 2
Slide 3
previous arrow
next arrow

Data Engineer

Dogico Information Inc.

This is a Contract position in Greater Vancouver Metropolitan Area, BC posted October 2, 2021.

Who are we?

Dogico is a small Canadian Software and Data Pipeline Development company in operations since 1998.

Over the years, Dogico has taken responsibility for the planning, development, maintenance, and evolution of groups of Applications and Data Pipelines.

Our mission is to seize opportunities to use our competencies, processes, and creativity to continuously create value for our clients.

We are a creative and focused team that values work-life balance and teamwork.

What is the project?

We are building the Data Warehouse / BI / Analytics infrastructure for a major Canadian mining company.

The infrastructure collects and integrates data from hundred of internal and external Data Sources.

This includes 8 divisional DataMarts, a Corporate Data Warehouse, and a Data Science platform.

It also includes reports, dashboards, and self-service tools.

Number of Position: One Opening
– Full time Permanent.

Location: This is not a remote position.

Our employees work from our office located Downtown Toronto (Spadina & Queen).

The company is currently following all the required Covid guidelines.

Work Conditions : General weekday business hours, with some overtime as required.

Occasional travel may be required Hours: 37.5 hours per week Benefits: Employer paid dental care and extended health care Employee Perks Employee assistance program Casual dress Flexible schedule Tuition reimbursement Company events Dogico is committed to a fair and inclusive work environment.

We will endeavor to accommodate the needs of qualified applicants in all parts of the hiring process.

All resume information is received in confidence.

While we appreciate all applications received, we can only contact directly those candidates selected for interview.

Reports to : President-CEO General Roles and Responsibilities Data and visualization engineering
– Specifically: Creating / modifying data extractions and transformations modules.

SSIS Packages on-premises.

ADF Pipelines on Azure.

Writing data manipulation stored procedures (SQL Server).

Data Visualization and reporting using Power BI.

Creating Dashboards, Datasets, and paginated reports.

Evolving simple websites to support the Data Warehouse (ASP.NET, C#, JavaScript).

Understanding and adapting to new Data Sources.

Evolving Data Models to integrate Data Requirements at Departmental, Divisional and Corporate levels.

Creating Database design.

Analysis Services cubes on-premises and on Azure.

Using Power BI Data Models.

Working on Azure SQL functions in C#.

Python scripting in a Data Science environment (Databricks, py-spark).

Diagnostic and debugging problems with production environment.

Quality Assurance of Releases.

System documentation and Release Management.

Supporting other members of the Team and Business Analysts.

Gather business and functional requirements and translate these requirements into robust, scalable, operable solutions with a flexible and adaptable data architecture.

Help continually improve ongoing reporting and analysis processes, automating or simplifying self-service modeling and production support for customers.

Maintain and enhance database views, functions and stored procedures used in our enterprise data warehouse and other reporting databases.

Troubleshoot issues with database views and query performance, and reports.

Provide experienced guidance and recommendations on data modelling, integration, and analysis best practices.

Qualification and Education requirements Language experience: SQL Server / SQL Server Managed Instance / Azure Data Warehouse / T-SQL, SSIS / Azure Data Factory, SSAS / Azure Analysis Services, Power BI, C# / Power Shell, ASP.NET, Python / PySpark, Excel / Power Query / VBA .

Education: Master’s or bachelor’s Degree in Software Engineering, Computer Engineering, Computer Science, Information Technology, or related technical field.

Work experience: At least 4 years of experience in Software Development.

Demonstrated strong logical and technical problem-solving skills.

Excellent written and oral English communication skills.

Experience with Agile development practices.

Additional Qualifications Curiosity (willingness to challenge the status quo) coupled with creativity (use data to discover how things can be operated differently to generate more value).

Detail oriented, professional, motivated, and positive work attitude is essential.

Ability to prioritize and execute tasks with minimal supervision.

French speaking and writing are an asset.