Sr. Business Intelligence Developer

U.S. Bank is looking for a seasoned Sr Business Intelligence Developer with strong SQL programming skills, database development, business intelligence systems experience, and data mining and statistical analysis experience. The position will support a database solution that merges account level data with our financial system in order to enhance profitability analysis and forecasting. The developer will create processes to merge data into a single server environment, develop data models, write advanced SQL queries/stored procedures, deploy data to users, and implement reporting solutions. Designs and codes complex queries, reports, cubes; performs testing and revises as necessary. Installs, configures, customizes, and troubleshoots business intelligence tools and applications. Monitors operating efficiency of existing business intelligence systems.

Responsibilities

* Develop and manage processes to collect source data from various sources and merge it into a single Oracle data environment

* Maintain data in the Oracle environment, ensuring data integrity, security, and organization

* Learn and understand the existing database architecture and make recommendations to improve and optimize it

* Support data analysis by conducting data mining, statistical analysis, and forecasting

* Develops basic and detailed program specifications

* Proactively identifies opportunities for improvement and recommends technical solutions

* Performs and/or leads design, coding, testing, implementation, and documentation of solution

* Write and develop complex PL/SQL programs to allocate expense and other financial data elements across millions of customer accounts

* Creates unit test plans and identifies opportunities to improve testing process

* Maintain allocation matrices and process flows to clear demonstrate allocation methods and database functionality

* Deploy large data sets to users via excel/access or other BI software and ensure expected performance levels are achieved

* Lead the migration of the database solution from an Oracle environment into a Netezza environment

Successful applicants will exemplify US Bank's ethical principles of uncompromising integrity, respect for others, accountability for decisions and actions, and good citizenship.

Basic Qualifications

* Bachelor's degree or equivalent work experience

* At least 7 years experience within a total information technology (IT) environment

* At least 5 years experience with BI applications; decision support systems, query and reporting, online analytical processing, statistical analysis, forecasting, and data mining

* At least 4 years experience with tools, facilities and techniques for managing and administering data

Preferred Skills/Experience

* Masters degree in related field

* Design and develop database objects, tables, stored procedures, views and triggers in an Oracle database and MS SQL environment

* Deploy large database to users with expected performance

* Oracle Database, Oracle 11g, writing complex PL/SQL

* Data mining, statistical analysis, and forecasting experience

* Experience building and maintaining a complex database environment with multiple source data tables and dimension tables

* Strong knowledge of database design principles

* Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc

* Proven track record of working in a fast-paced, time-sensitive project that requires clear and timely communication, balancing priorities, and going above and beyond the requirement of the role

* Strong experience with various Business Intelligence software applications

* Credit card business knowledge and experience

* Demonstrate excellent communication skills including the ability to effectively communicate with internal and external customers

* Strong work ethic and ability to work with diverse teams across the department and bank

Similar jobs you might like