Data Engineer - 5

Staffmax Staffing & Recruiting; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A prominent staffing and recruiting company is seeking a Data Product Owner to lead a data analytics transformation within its International Wealth Management group. The role involves managing complex data projects, developing solutions, and collaborating with diverse teams. Candidates should have extensive experience in big data analysis, data architecture, and strong proficiency in SQL. This position offers opportunities for professional growth and international collaboration, contributing to impactful projects in the financial sector.

Qualifications

• 10+ years of experience in big data analysis and data architecture.
• 3-5 years in a managerial role with proven leadership.
• Hands-on experience in complex SQL queries and data visualization.

Responsibilities

• Support the definition of the data hub strategy for wealth applications.
• Collaborate with teams to translate business requirements into technical specifications.
• Manage communications and status reporting of ongoing data initiatives.

Skills

Big Data Analysis

Data Engineering

Data Architecture

SQL

Data Governance

Data Quality

Data Security

Analytical Skills

Critical Thinking

Communication

Education

Post-Secondary Education

Advanced Degree in Data Analytics

Tools

Power BI

Google Cloud Platform

Job description

Hiring Manager : Director, Business Platforms & Experience

Location Address : 40 Temperance Street 14th Floor – hybrid – onsite 2-3 / week

Required within GTA – Yes

Contract Duration : 6 months

Possibility of extension : Yes

Number of Positions : 1

Max BNS rate : $140 / hr

Reason : New Project : Data Analytics Solution project

Story Behind the Need

Business group : IWM Advisor & Client Solutions

The Data Product Owner – Business Platforms & Experience contributes to the overall success of International Wealth Management organization (IWM) strategy, by enabling a common data platform for all wealth applications, and International Wealth Management in resolving complex business and data issues.

Project :

This is a demanding hands-on role which requires the incumbent to be knowledgeable of the data architecture, managing highly complex projects, specific to data, and has in-depth experience collaborating with multi-jurisdictional teams. The incumbent should have the ability to develop recommendations, propose solutions, and define functional requirements, in collaboration with business, tech, and various other partners. Additionally, should be highly analytical and have a good understanding of databases, technical architecture, and query tools, with previous experience in wealth management or capital markets or related domains.

This role will be focused on acceleration of IWM’s data & analytics transformation, particularly on implementing a Wealth Data Hub; build a data platform that consolidates information structured by relevant domains such as clients, portfolio, and performance, enabling Advisor and Client experience across IWM.

Candidate Value Proposition :

• The successful candidate will have the opportunity to work in a growing business with exposure to various stakeholders including leadership to enhance their network and skills within the bank. The successful candidate will be a part of transformation in a strategic part of the bank such as International Wealth Management, to help accelerate growth and get to do high impact work. Candidate will be working with the international team and will get to travel internationally along with the exposure to learn big data cloud technologies.

Typical Day in Role :

• Support the definition of the International Wealth Management data hub strategy and roadmap to drive specific operational data capabilities.
• Work collectively with the Business Platforms and Experience team to articulate business requirements into system requirements for new enhancements or projects.
• Responsible and accountable for the business requirements / specifications to be complete, correct, consistent, concise, and achievable.
• Collaborate with head office and in-country business partners to Document, analyze, research, and define user and system requirements and features relating to strategic data projects / initiatives. Develop and deliver Business Requirements Documents, source-to-target data mapping, data specifications, User stories, as required.
• Document data transformation and cleansing rules for data migration. Previous expertise with Data warehousing projects.
• Provide expertise on systems gap analysis and potential risks / issues on projects, enhancements, and initiatives.
• Acts as a liaison between business and IT to provide technical solutions to meet user needs. Present recommendations with technology teams, collaborating on system design, and understanding process, database structures, and Data Model.
• Responsible for reviewing and analyzing end-to-end testing results for data projects.
• Manage communications and status reporting of ongoing initiatives, including summarizing project risks and options and facilitating prompt decisions when needed.
• Provide expertise on relational and dimensional data modelling.
• Provide the team expertise on data models such as star and snowflake schemas.
• Proficiency in SQL is a must have.

Candidate Requirements / Must Have Skills :

• 10+ years of experience in big data analysis, data engineering, or data architecture field
• 3-5 years in a managerial or leadership role - Experience in leading and coaching teams, with track record of attracting and developing talent.
• 8-10 years in experience in relational databases and SQL; ability to run complex queries independently.
• Hands on experience in big data tools and technologies, as well as data visualization and reporting tools such as PowerBI.
• Strong knowledge of data governance, data quality, and data security best practices.
• Experience in working with cloud-based data platforms, preferably Google Cloud Platform.
• Proven ability to translate business requirements into technical specifications and deliver working results.

Soft Skills Required :

• Critical thinking skills : using logic and reasoning to evaluate alternative solutions, summarize conclusions and approaches to mitigate risks. Excellent analytical, problem-solving, and communication skills.
• Ability to develop strong working relationships with business and technology partners globally.

Nice-To-Have Skills :

• Full proficiency in Spanish, nice to have, an asset.
• Relevant working experience in the financial sector, Wealth Management, or capital markets experience, in data projects, an asset.

Education :

• post-Secondary education and Advanced degree preferred but not mandatory in data analytics.

Best VS. Average Candidate :

The ideal candidate would have previous bank experience or wealth management initiatives experience. Has led / managed a team of Data analysts / Data engineers in his recent position.

Create a job alert for this search

Data Engineer • Toronto

We Care About Your Privacy

We and our 1 partners store and access personal data, like browsing data or unique identifiers, on your device. Selecting I Accept enables tracking technologies to support the purposes shown under we and our partners process data to provide. Selecting Reject All or withdrawing your consent will disable them. If trackers are disabled, some content and ads you see may not be as relevant to you. You can resurface this menu to change your choices or withdraw consent at any time by clicking the Show Purposes link on the bottom of the webpage [or the floating icon on the bottom-left of the webpage, if applicable]. Your choices will have effect within our Website. For more details, refer to our Privacy Policy.

We and our partners process data to provide:

Use precise geolocation data. Actively scan device characteristics for identification. Store and/or access information on a device. Personalised advertising and content, advertising and content measurement, audience research and services development.