City National Bank
City National Bank proudly offers services, tools and technology that put our people and communities first.

Informatica Data Quality Engineer

By clicking Apply Now you agree to share your profile information with the hiring company.
Employer Provided Salary: 101,231-172,355 Annually
Salary data is provided by the employer. Please note this is not a guarantee of compensation.

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.
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 with senior team members and management to mitigate
  • Conduct peer and team review sessions
  • Assist in the creation of standards, templates and procedures for the department
  • Contribute to the design of the data structure/data model and data flow
  • Design and develop data workflows and mappings to extract, transform, and load data for purposes of analytics , reporting and integration


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

Skills and Knowledge

  • Advanced senior professional with wide ranging experience uses professional concepts and to resolve complex issues in creative and effective ways
  • Perform various tasks to design and deliver data pipeline solutions with accuracy, reliability, and quality.
  • Requires specialized depth and or breadth of expertise
  • Proficient Data Warehousing and ETL skills
  • Advanced verbal and written communication skills
  • Advanced interpersonal relations skills, ability to effectively collaborate with others and work as part of a team
  • 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, researches and resolves questions and problems, requests manager input and keeps manager informed
  • Demonstrated ability to work with all levels in the organization
  • Demonstrated attention to detail
  • Demonstrated ability to manage multiple tasks and meet deadlines
  • Ability to exercise initiative, problem-solving and decision-making skills
  • Demonstrated fluency with SQL
  • Proficient in data collection, transformation, and aggregation solutions
  • Knowledge of Data Architecture and Pipelining"

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 .
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.'
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.

See More
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

What are City National Bank Perks + Benefits

City National Bank Benefits Overview

We strive to be the best at whatever we do, and that includes the benefits and perks we offer our colleagues.

We understand that colleagues have different needs. As a result, we look to offer a holistic program to support and address physical, emotional, financial and social needs.

Volunteer in local community
Partners with nonprofits
Open door policy
OKR operational model
Team based strategic planning
Open office floor plan
Employee resource groups
Remote work program
Mandated unconscious bias training
Diversity employee resource groups
Our 11 Colleague Resource Groups (CRGs) help colleagues deepen their relationships and knowledge at work, encouraging more people to connect, learn and celebrate with each other.
Hiring practices that promote diversity
Health Insurance + Wellness
Flexible Spending Account (FSA)
Disability insurance
Dental insurance
Vision insurance
Health insurance
Coverage generally begins on the first day of the month following employment, and colleagues are able to cover spouses, domestic partners and/or dependent children.
Life insurance
Wellness programs
Mental health benefits
Abortion travel benefits
Financial & Retirement
401(K) matching
Pretax and Roth 401(k) - the company matches 75% of the first six percent of eligible pay a colleague contributes each pay period. Match dollars are immediately vested.
Performance bonus
Some positions may be eligible for bonus and/or commissions
Child Care & Parental Leave
Generous parental leave
Family medical leave
Adoption Assistance
Fertility benefits
Vacation + Time Off
Paid volunteer time
Paid holidays
Paid sick days
Floating holidays
Bereavement leave benefits
Office Perks
Commuter benefits
Mother's room
Professional Development
Job training & conferences
Tuition reimbursement
Lunch and learns
Promote from within
Mentorship program
Continuing education available during work hours

More Jobs at City National Bank

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about City National BankFind similar jobs like this