Skip to main content

Or use LinkedIn Job Matching to find an opening that matches your experience.

Start Matching

IT Production Support Lead

Apply Now
Job ID TI-12891 City Los Angeles State California Exempt/Non Exempt Exempt Shift Day Work Schedule M-F, 8-5
Job Details:

As a part of the Business Intelligence team, the Production Support Lead is responsible for the maintenance, implementation and administration of back-end dataflows supporting the ODS (Operational Data Store), EDW (Enterprise Data Warehouse), M/RDM (Master/Reference Data Management), and downstream systems.

Technology & 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.

  • Lead Production Support activities by troubleshooting critical issues, addressing ETL application service interruptions and vendor outages while identifying process improvements
  • Lead ETL application upgrade projects by applying hot fixes and version releases on a regular basis
  • Lead process development and oversight of code migrations between Dev, QA and Production ETL environments ensuring code and job scheduling is sound and complete
  • Define and establish processes for performing routine system health checks to ensure optimization and stability of ETL application and code
  • Provide technical direction and mentoring to team members related to implementations, job scheduling, and troubleshooting
  • Develop and maintain thorough business knowledge of source data in the enterprise data warehouse environment
  • Create, enhance, and maintain ETL support processes and technical documentation
  • Execute and/or escalate problem management procedures as necessary
  • Perform operational fixes related to ETL code
  • Perform ETL code reviews to ensure technology, exception handling, company best practices and processes are followed
  • Participate in Disaster Recovery exercises pertaining to ETL processes
  • Ability to be on call and provide off hours support for the enterprise data warehouse batch processes to ensure they achieve SLAs
  • Work with management to define and create methods for collecting and reporting on metrics related to SLAs, data reconciliation, load statistics, etc.



  • Minimum 5 years of experience in an ETL production support role

Skills and Knowledge

  • Knowledge of Business Intelligence and Data Warehousing concepts and principles
  • Excellent analytical and problem solving skills.
  • Excellent oral and written communication and interpersonal skills.
  • Ability to work independently or within a team for problem resolution
  • Ability to interface effectively with all levels of the organization.
  • Thorough understanding of SDLC
  • Minimum 3 years working experience in banking or financial services environment preferred
  • BS or MS in Computer Science or a related technical field preferred.
  • Experience in Oracle databases, PL/SQL is strongly preferred
  • Strong organizational, multi-tasking, adaptability, and time-management skills preferred.

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

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.




Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled
Apply Now

Sign up for job alerts.

We will email you when relevant jobs are posted.

Interested InSelect a job category from the list of options. Select a location from the list of options. Finally, click “Add” to create your job alert.

  • Information Technology, Los Angeles, California, United StatesRemove

"By submitting your information, you acknowledge that you have read and consent to City National Bank’s privacy policy and California Employee Privacy Statement and further consent to receive email communication from City National Bank relating to your application.