Business Intelligence, Senior Developer at City National Bank Los Angeles, CA 90189
WHAT IS THE OPPORTUNITY?The Senior Business Intelligence Developer is responsible for the development activities of various BI initiatives, which include ETL, ELT, PL/SQL, Python, and APIs, scripts, reports and dashboards.
The Senior BI Developer will support project initiatives within the Operational Data Store (ODS), Enterprise Data Warehouse (EDW), various Data Marts, Master Data Management and BI Reporting.
The position will perform in-depth development, data analysis, data quality, and design for quality engineering across various databases and methodologies specific to Business Intelligence.
This role will provide input and oversight on development design decisions, best practices, and processes to a team of BI Developers.
Technology & Innovation DivisionAs a member of City Nationals 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?Perform in-depth development by writing complex ETL/ELT jobs, PL/SQL queries, APIs on various source systems, data marts and data warehouse support of the requirements for various strategic and/or tactical projectsWork with a team of developers to provide input and oversight on ETL/ELT development designs and processes.
Serve as Subject Matter Expert on Operational Data Stores, Data Warehouse, and Data Marts development; guide the development design activities with input and data dependencies.
Identify development and data quality issues and work with leads and management to mitigateConduct on-going analysis of the development process and practices within and between various systems and applications.
Ability to multi-task various projects and tasks with tight deliverables while keeping informed of existing and evolving development best practice, industry standards and technologies.
Fosters and maintains good relationships with colleagues to meet expected customer service levels.
Maintain all appropriate training and continuing education requirements for both internal programs and external licenses and certifications.
Develop and maintain positive, productive, and professional relationships with key business users to meet expected customer service levels.
Complies fully with all Bank Operational policies and procedures as well as all regulatory requirements (e.
g.
Bank Secrecy Act, Know Your Client, Community Reinvestment Act, Fair Lending Practices, Code of Conduct, etc.
).
BasicWHAT DO YOU NEED TO SUCCEEDMust-Have Minimum of 5 years of experience as a Developer, preferably in a data-intensive financial company.
Minimum of 5 years of experience in advanced ETL/ELT, PL/SQL, Oracle, and Reporting Minimum of 5 years of experience working with Business Intelligence technologiesSkills and KnowledgeBachelors degree in computer science, engineering or equivalentMS in Computer Science or a related technical field preferred.
Knowledge of SAP and Informatica products:
SAP Data Services and Business Objects (development, migration, access, installation and upgrades); Informatica PowerCenter, Data Quality, Data ValidationKnowledge of Business Intelligence and Data Warehousing concepts and principlesExperience in Oracle databases, PL/SQL is strongly preferredExcellent analytical and problem solving skills.
Excellent oral and written communication and interpersonal skills.
Strong organizational, multi-tasking, and time-management skills preferred.
Ability to work independently or within a team for problem resolutionMust demonstrate ability to multi-task and be flexible.
Ability to interface effectively with all levels of the organization.
.
Estimated Salary: $20 to $28 per hour based on qualifications.
The Senior BI Developer will support project initiatives within the Operational Data Store (ODS), Enterprise Data Warehouse (EDW), various Data Marts, Master Data Management and BI Reporting.
The position will perform in-depth development, data analysis, data quality, and design for quality engineering across various databases and methodologies specific to Business Intelligence.
This role will provide input and oversight on development design decisions, best practices, and processes to a team of BI Developers.
Technology & Innovation DivisionAs a member of City Nationals 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?Perform in-depth development by writing complex ETL/ELT jobs, PL/SQL queries, APIs on various source systems, data marts and data warehouse support of the requirements for various strategic and/or tactical projectsWork with a team of developers to provide input and oversight on ETL/ELT development designs and processes.
Serve as Subject Matter Expert on Operational Data Stores, Data Warehouse, and Data Marts development; guide the development design activities with input and data dependencies.
Identify development and data quality issues and work with leads and management to mitigateConduct on-going analysis of the development process and practices within and between various systems and applications.
Ability to multi-task various projects and tasks with tight deliverables while keeping informed of existing and evolving development best practice, industry standards and technologies.
Fosters and maintains good relationships with colleagues to meet expected customer service levels.
Maintain all appropriate training and continuing education requirements for both internal programs and external licenses and certifications.
Develop and maintain positive, productive, and professional relationships with key business users to meet expected customer service levels.
Complies fully with all Bank Operational policies and procedures as well as all regulatory requirements (e.
g.
Bank Secrecy Act, Know Your Client, Community Reinvestment Act, Fair Lending Practices, Code of Conduct, etc.
).
BasicWHAT DO YOU NEED TO SUCCEEDMust-Have Minimum of 5 years of experience as a Developer, preferably in a data-intensive financial company.
Minimum of 5 years of experience in advanced ETL/ELT, PL/SQL, Oracle, and Reporting Minimum of 5 years of experience working with Business Intelligence technologiesSkills and KnowledgeBachelors degree in computer science, engineering or equivalentMS in Computer Science or a related technical field preferred.
Knowledge of SAP and Informatica products:
SAP Data Services and Business Objects (development, migration, access, installation and upgrades); Informatica PowerCenter, Data Quality, Data ValidationKnowledge of Business Intelligence and Data Warehousing concepts and principlesExperience in Oracle databases, PL/SQL is strongly preferredExcellent analytical and problem solving skills.
Excellent oral and written communication and interpersonal skills.
Strong organizational, multi-tasking, and time-management skills preferred.
Ability to work independently or within a team for problem resolutionMust demonstrate ability to multi-task and be flexible.
Ability to interface effectively with all levels of the organization.
.
Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
