Analysis & Consulting - Data Engineer

Nexus Systems Group Inc.; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading data solutions provider in Toronto is seeking a skilled professional to manage database governance and build data pipelines. The ideal candidate has over 4 years of experience with SQL, Python, and data cloud platforms like Snowflake, AWS, or Azure. Strong communication skills are essential for explaining technical concepts to non-technical stakeholders. This role offers a collaborative environment with opportunities for professional growth.

Qualifications

• Experience in building solutions in data cloud platforms.
• Knowledge of SQL, Python, R, and GIT is essential.
• Proficient in data documentation and version control.

Responsibilities

• Database governance and maintenance.
• Building data pipelines across the client's data ecosystem.
• Communicating technical concepts in non-technical terms.

Skills

SQL

Python

R

GIT

Data-driven decision-making

Education

Relevant experience and education (4+ yrs)

Tools

Snowflake

AWS

Azure

Job description

Role Responsibilities

• Database governance and maintenance, including schema structure, table creation, and ensuring database best practices and naming conventions.
• Building data pipelines to source across the client's data ecosystem.
• Working in different data platforms, including on-premises and cloud-based infrastructures.
• Communicating technical concepts in on-technical terms.
• Fostering strong internal and external networks and works across multiple teams to achieve business objectives.
• Collaborating with other team members to deliver analytics solutions.
• Collaborating with broader technology and cybersecurity teams to source data and keep in compliance with data security guidelines.
• Autonomously running data tests and identifying solutions. Escalating solutions to leadership as needed for approvals.
• Broader work or accountabilities may be assigned as needed.

Must-Have Skills

• 4+ yrs of relevant experience and education
• SQL/Python/R/GIT experience
• Knowledge and experience in building solutions in data cloud platforms, including Snowflake, AWS, and/or Azure is essential.
• Experience in building and automating datasets and reports.
• Experience in proper data documentation and version control is essential.
• Experience in scheduling and automating advanced analytics solutions (e.g. machine-learning or generative AI) is strongly preferred.
• Proficient in data-driven decision-making and using insights to guide strategic actions.
• Ideal candidates will be personable with strong written/verbal communication skills in addition to technical skills.
• Investment industry knowledge is an asset, including basic knowledge of sales and portfolio management.
• Previous banking experience a nice to have.
• Previous experience with Vermillion an asset.