Data Senior Engineer Jobs

DATA SENIOR ENGINEER - TECHNOLOGY (LA/NY/NJ-Hybrid)

WHAT IS THE OPPORTUNITY?

The Data Engineer Senior works with department and lines of business subject matter expert (SMEs) across the enterprise 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.

Technology and Innovation Division

As a member of City National's Technology & Innovation group, you will drive, develop, and maintain solutions for clients and colleagues. This is an exciting time of technology advancement and innovation across the bank, particularly within our technology teams.

WHAT WILL YOU DO?

• Function in accordance with the Software Development Life Cycle (SDLC) framework and governance processes
• Identify development and data quality issues and work with senior team members and management to mitigate
• Contribute to the design of the data structure/data model and data flow
• Participate in development of test plans and perform quality assurance and testing of own work and that of peers
• Ensure work includes necessary audit controls such as Audit, Balance and Control (ABC) Framework and security controls within all design and deliverables
• Participate in development of test plans and perform quality assurance testing of own work and that of peers
• Function in accordance with the Software Development Life Cycle (SDLC) framework and governance processes
• Conduct peer and team review sessions
• Document data workflows including but not limited to: functional specs, technical specs, mapping / workflow diagram, testing plans, production “run books”, training materials, etc.
• Assist in the creation of standards, templates and procedures for the department
• Design and develop data workflows and mappings to extract, transform, and load data for purposes of analytics , reporting and integration
• Accurately define and execute transformations, aggregations and other data manipulations to meet requirements

What Do You Need To Succeed

Must-Have*

• -Database technologies including traditional RDBMS such as Oracle and SQL Server.
• 6+ years of relevant experience in the following:
• -Full software development life cycle frameworks
• Bachelor's Degree or equivalent experience
• -Transformation tools such as Informatica PowerCenter, Microsoft SSIS, IBM Data Stage, etc.
• -Advanced SQL coding with an emphasis on data transformation functions

Skills And Knowledge

• Requires specialized depth and or breadth of expertise
• Proficient Data Warehousing and ETL skills
• Knowledge of Data Architecture and Pipelining"
• Able to work with a high degree of independence, researches and resolves questions and problems, requests manager input and keeps manager informed
• Highly developed analytical, critical thinking, and problem solving skills
• Ability to exercise initiative, problem-solving and decision-making skills
• Perform various tasks to design and deliver data pipeline solutions with accuracy, reliability, and quality.
• Advanced senior professional with wide ranging experience uses professional concepts and to resolve complex issues in creative and effective ways
• Highly developed organizational and time management skills.
• Demonstrated fluency with SQL
• Proficient in data collection, transformation, and aggregation solutions
• Demonstrated ability to manage multiple tasks and meet deadlines
• Must have 4+ years of Information Cloud specific experience
• Advanced interpersonal relations skills, ability to effectively collaborate with others and work as part of a team
• Advanced verbal and written communication skills
• Ability to initiate and follow through on projects of varying complexity and duration
• Demonstrated attention to detail
• Demonstrated ability to work with all levels in the organization

Compensation

Starting base salary: $101,231 - $172,355 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.

#GD-DM

#CA-DM