Help make financial lives better through the power of every connection at Bank of America
Requirements
- Master's degree or equivalent in Computer Science, Information Technology, Computer Information Systems, Management Information Systems, Information Technology Management, Engineering (any), or related
- 3 years of experience in the job offered or a related IT occupation
- 3 years of experience in designing, automating, and maintaining large scale, enterprise-wide data warehouse applications using Oracle Exa Data, PL/SQL and data extract, transform and load tools like Informatica
- 3 years of experience in utilizing Business Intelligence tools, Tableau, Cognos and MicroStrategy to analyze data, find patterns and generate data visualizations
- 3 years of experience in translating complex business requirements into data model to support advanced analytics, define data modeling standards, naming conventions and prepare data dictionaries
- 3 years of experience in writing relational data manipulation packages using procedural SQL and data queries
- 3 years of experience in improving data processing time by optimizing queries, creating indexes and normalizing the data model
Responsibilities
- Maintain responsibility for designing and developing complex requirements to accomplish business goals
- Ensure that software is developed to meet functional, non-functional, and compliance requirements
- Design, automate, and maintain large scale, enterprise-wide data warehouse applications using Oracle Exa Data, PL/SQL and data extract, transform and load tools like Informatica
- Utilize Business Intelligence tools, Tableau, Cognos and MicroStrategy to analyze data, find patterns and generate data visualizations
- Translate complex business requirements into data model to support advanced analytics, define data modeling standards, naming conventions and prepare data dictionaries
- Write relational data manipulation packages using procedural SQL and data queries
- Improve data processing time by optimizing queries, creating indexes and normalizing the data model
Other
- Remote work may be permitted within a commutable distance from the worksite
- Must include 3 years of experience in the job offered or a related IT occupation