Data Engineer

Kingsdale Advisors; Toronto; On-site; CAD 70,000 - 100,000; Full time

Job summary

Kingsdale Advisors seeks a Data Engineer responsible for maintaining data repositories and ensuring data quality within the organization. The role requires strong analytical skills and expertise in data management tools to support various departments in data-related tasks, offering an opportunity to thrive in a collaborative environment.

Qualifications

• Ability to translate functional needs to technical documents.
• Knowledge of Business Intelligence environments.
• Experience with SQL Server and data management tools is a plus.

Responsibilities

• Maintain the data repositories using ETL tools.
• Create and report on data.
• Provide analytical support and custom reports.

Skills

Attention to detail

Data management

ETL knowledge

Analytical skills

Interpersonal skills

Tools

Python

SQL

Power BI

Excel

Microsoft Power Platform

Job description

Get AI-powered advice on this job and more exclusive features.

Reporting to VP of Operations, the Data Engineer is responsible for updating and maintaining the data repositories of the organization using various ETL related tools to cleanse raw data into client ready format as well as within the organization. They will be required to communicate with the various departments to gather user requirements and execute standard operational procedures. Attention to detail is a must as data integrity and accuracy is extremely important.

Responsibilities & Key Duties will include:

• Identify, create, maintain and report on data
• Provide support for data cleansing, mapping/transformation and quality control
• Data mining and research
• Extract, transform and load both structured and unstructured data in multiple environments to unlock the ability to self-serve across the business thus having the technical expertise to turn our different sets of data into meaningful results
• Provide analytical support to company by providing custom reports using various formats (Excel, Google Analytics, Power BI, etc.) Create value-added reports, metrics and analysis across multiple dimensions
• Analyze user requirements for reports, forms, queries, and data extraction
• Develop and deploy end-user practices and tools for data extraction, queries, and data manipulation in accordance with business processes
• Import and/or export data between different kinds of software
• Tracking, managing, and validating data across systems
• Ensure the stability and reliability of data access and data quality across the organization via ongoing database support and maintenance
• Willing to be flexible with shift start and end time including evenings and weekends
• Perform other duties as required

Qualifications & Attributes

• Ability to translate functional needs to technical documents
• Knowledge of ETL and Business Intelligence environments
• High attention to detail
• Ability to quickly learn new technology
• Intermediate to advanced Microsoft Excel knowledge
• Knowledge of data management tools (Python, Power BI tools, SQL, SSMS, SSIS)
• Experience with VBA, RegEx, Microsoft Power Platform, and SharePoint is an asset
• Experience with building tables and queries using MS SQL
• Familiarity with Alteryx or experience in process automation is advantageous
• Understanding of software development and methodologies
• Ability to communicate ideas effectively
• Experience working in a fast-paced, team-oriented, collaborative environment
• Good interpersonal, written, and oral communication skills
• Demonstrates a rapid learning capability

Equity Statement

Kingsdale Advisors is a proud advocate for diversity and inclusion. We welcome applications from members of the BIPOC community, women, people with disabilities, the LGBTQ+ community, and individuals with diverse intersectional identities. Accommodation is available throughout the recruitment and employment processes, in accordance with the Accessibility for Ontarians with Disabilities Act (AODA).

Seniority level

• Seniority level

  Entry level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

Referrals increase your chances of interviewing at Kingsdale Advisors by 2x

Get notified about new Data Engineer jobs in Toronto, Ontario, Canada.

Software Engineer, Backend (All Levels / All Teams)

Software Engineer I, Entry Level (Fall 2024-Spring 2025) - Toronto

Toronto, Ontario, Canada CA$65.00-CA$85.00 3 weeks ago

Toronto, Ontario, Canada CA$120,000.00-CA$190,000.00 3 weeks ago

Toronto, Ontario, Canada CA$100,000.00-CA$150,000.00 3 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.