Lead Data Engineer Technology

LEAD DATA ENGINEER TECHNOLOGY

WHAT IS THE OPPORTUNITY?

The Data Engineer Lead works with department and lines of business subject matter expert (SMEs) across the enterprise to meet departmental and organizational objectives. The engineer will help establish end-to-end process standards and guidelines that 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 and that of peers

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 design and deliverables

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

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

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

Identify development and data quality issues and work on resolutions to mitigate

Conduct team review sessions

Develop standards, templates and procedures for the department

Contribute to the design of the data structure/data model and data flow

Manage team execution of large programs & projects of significant complexity and risk

Participate and contribute to data pipeline architecture

Maintain an enterprise level view across department data landscape

Conduct on-going analysis and make recommended improvement of the development process and practices

Actively mentor and coach other colleagues

Must-Have

Bachelor's Degree or equivalent

7 years Full software development life cycle frameworks

7 years Database technologies including traditional RDBMS such as Oracle and SQL Server.

7 years Advanced SQL coding with an emphasis on data transformation functions

7 years Transformation tools such as Informatica PowerCenter, Microsoft SSIS, IBM Data Stage, etc.

3 years experience in a lead role overseeing and directing day-to-day tasks

Skills and Knowledge

Demonstrates professional standards surrounding data access, data security, data sensitivity, and data confidentiality.

Advanced verbal and written communication skills

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

Able to navigate a large organization, including managing political sensitivities, in order to accomplish results

Ability to initiate and follow through on projects of varying complexity and duration

Highly developed organizational and time management skills.

Highly developed analytical, critical thinking, and problem solving skills

Able to work with a high degree of independence, assumes responsibility for job development and training, researches and resolves questions and problems, requests manager input and keeps manager informed

Completes projects of substantial depth and complexity

Demonstrated ability to work with all levels in the organization

Demonstrated attention to detail

Demonstrated ability to manage multiple tasks and meet deadlines

Strong demonstrated learning aptitude and orientation

Ability to teach, mentor and consult with others

Demonstrated fluency with SQL

Excellent skills and experience in 5 or more data/analytics competencies in domains including subject matter expertise, analytic methods and tools, business intelligence, data management, data architecture, analysis and critical thinking skills, data governance, analytics education / learning, ontology, and metadata.

Experience in financial industry (banking preferred)

Compensation

Starting base salary: $111,408 - $189,738 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.

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.