Data Engineer

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

Job summary

A leading advisory firm in Ontario is seeking a Data Engineer to maintain and improve data repositories using various ETL tools. The role involves data cleansing, reporting, and collaborating with departments to ensure data integrity. The ideal candidate has strong skills in data management, Microsoft Excel, and ETL processes. This position encourages diversity and inclusion, welcoming applicants from various backgrounds.

Qualifications

• 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.
• Good interpersonal, written, and oral communication skills.

Responsibilities

• Maintain and report on data.
• Provide data cleansing and quality control support.
• Extract, transform, and load data.
• Analyze user requirements for reports and data extraction.
• Ensure data quality across the organization.

Skills

Data cleansing

Data analysis

Microsoft Excel

ETL processes

SQL

Power BI

Tools

Python

SSMS

SSIS

Alteryx

Job description

With offices in Toronto and New York, Kingsdale Advisors is the leading shareholder services and advisory firm, having acted on the largest and most high-profile proxy fights and transactions. Since 2003, public companies across North America have looked to the expertise of Kingsdale Advisors to help them reach out to shareholders and secure the success of transactions or resolutions driven by shareholder votes. Kingsdale Advisors’ multidisciplinary team offers an array of specialized services focused on strategic and defensive advisory, governance advisory and proxy analytics, strategic communications, and voting analytics.

Your Role and How You Will Contribute

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.

Requirements

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).