Sr. Data Warehouse / ETL Architect
5 - 7 years experience • Financial Services
A Leading Investment Management/Private Bank in Jersey City, NJ is seeking a full time, permanent, Data Warehouse Architect: THE CLIENT DOES NOT TRANSFER H-1 VISAS:
We are looking for Data Warehouse Architect who has the solid understanding and experience in the underlying technologies. The Data Warehouse Architect should have a strong development background and will work closely with the IT architects and our engineering team to not only maintain and improve our existing data warehouse product, but also design and build our next generation data warehouse to accommodate ever growing needs for historical and real-time data for analysis and reporting from our business user community. The Data Warehouse Architect will be responsible for working with business users and system analysts to translate requirements into a complete data warehouse and business intelligence environment. Our next generation data warehouse environment will consolidate multiple disparate source systems from both mainframe and distributed computing platforms into an enterprise wide, robust, scalable data repository system able to meet high performance and high-quality standards.
Additionally, you will be expected to:
¥ Responsible for the development and ongoing maintenance of the data warehousing and business intelligence environment as well as the Architecture of the BI environment, its design, performance, availability, and success
¥ Responsible for designing the logical/physical 3NF and dimensional data models, defining the ETL and metadata repository approach and laying out both a short-term roadmap and long-term warehouse strategy.
¥ Working with business users and technical staff to translate business needs for information into solid solutions
¥ Identifies performance bottlenecks and implements the solutions
¥ Writes comprehensive concise and clear technical documents.
¥ Bachelor’s Degree in Computer Science
¥ Minimum 5years’ experience with database design and architecture, data modeling,
security, performance tuning, and mainstream business intelligence applications
¥ Minimum 5years’ experience developing enterprise Data Warehouse solutions
¥ Minimum 7years’ experience with Oracle databasetechnologies, SQL, PL/SQL, Stored
Procedures, Triggers, etc.
¥ Experience with design and implementation of the dimensional database model
¥ Experience with Oracle RAC and Oracle ExaData is a strong plus
¥ Experience with banking and financial industry reporting is a plus
¥ Possessing good analytical and problem solving abilities
¥ Ability to work with many different technical tools
¥ Ability to design, model, build, and deploy BI solutions
¥ Ability to architect data warehouse environments
¥ Strong understanding of how data schemas/structures satisfy and relate to business
¥ Excellent verbal, written and interpersonal communication skills
¥ A good team player – one who appreciate the value of a good team player to the success of the organization.
¥ Expert knowledge and ability to work with Oracle databasetechnologies
¥ Ability to optimize SQL, PL/SQL stored procedures, triggers
¥ Ability to keep up-to-date the technology developments for potential use of in house
¥ Experience in Big Data and NoSQL technologies and architecture is a strong plus
¥ Experience in DB2 is a plus
¥ A good team player – one who appreciate the value of a good team player to the success of