DATA ENGINEER - DATA FLOWS & RECONCILIATIONS (HYBRID 2-3 DAYS IN OFFICE)

WHAT IS THE OPPORTUNITY?

The Data Engineer works with Banking & Investment Services subject matter experts (SMEs) to meet departmental and organizational objectives. The engineer will follow end-to-end process standards and guidelines to ensure accurate and efficient build out of data pipeline architecture within project timeframes.

What you will do

• Function in accordance with the Software Development Life Cycle (SDLC) framework and governance processes

• Participate in development of test plans and perform quality assurance and testing of own work

• Function in accordance with the Software Development Life Cycle (SDLC) framework and governance processes

• Ensure work includes necessary audit controls such as Audit, Balance and Control (ABC) Framework and security controls within all deliverables

• Document data workflows including but not limited to: functional specs, technical specs, mapping / workflow diagram, testing plans, production “run books”, etc.

• Accurately execute transformations, aggregations and other data manipulations to meet requirements

• Participate in development of test plans and perform quality assurance testing of own work

• Identify development and data quality issues and work with senior team members and management to mitigate

• Conduct peer review sessions

• Design and develop data workflows and mappings to extract, transform, and load data for purposes of analytics , reporting and integration

Must-Have*

• Bachelor's Degree or equivalent

• Four (4) years of data or analytics experience

• Four (4) years of development experience (preferably in a data-intensive financial company)

Skills and Knowledge

• An experienced, fully proficient professional with full understanding and in-depth knowledge of data engineering

• Resolves a wide range of issues in creative ways

• Strong Data Warehousing and ETL skills

• Strong verbal and written communication skills

• Strong interpersonal relations skills, ability to effectively collaborate with others and work as part of a team

• Strong organizational and time management skills.

• Strong analytical, critical thinking, and problem solving skills

• Knowledgeable in data collection, transformation, and aggregation solutions

• Strong initiative and decision-making skills

• Ability to develop clear, concise documentation

• Exposure to various database systems along with proven SQL skills

Compensation

Starting base salary: $92,114 - $156,880 per year. Exact compensation may vary based on skills, experience, and location. This job is eligible for bonus and/or commissions.

*To be considered for this position you must meet at least these basic qualifications

The preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.

Benefits and Perks

At City National, we strive to be the best at whatever we do, including the benefits and perks we offer our colleagues. Get an inside look at our Benefits and Perks (https://image.emails.cnb.com/lib/fe5e15707c640c78771c/m/10/cbedd856-c2fc-491b-a625-3ab7a0fd9a65.pdf) .

INCLUSION AND EQUAL OPPORTUNITY EMPLOYMENT

City National Bank is an equal opportunity employer committed to diversity and inclusion. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status or any other basis protected by law.'

ABOUT CITY NATIONAL

We start with a basic premise: Business is personal. Since day one we've always gone further than the competition to help our clients, colleagues and community flourish. City National Bank was founded in 1954 by entrepreneurs for entrepreneurs and that legacy of integrity, community and unparalleled client relationships continues to drive phenomenal growth today. City National is a subsidiary of Royal Bank of Canada, one of North America’s leading diversified financial services companies.