Jersey City, NJ, USA
icrunchdata Network
Genesis10 is currently seeking a Data Warehouse/ BI Architect with our client in the financial industry in their Jersey City, NJ or Charlotte,NC l ocation. This is a 12 month contract position. Description: The role supports wholesale credit and treasury areas of the bank to provides liquidity management, payments and receipts, trade and supply chain finance, foreign exchange and commercial card services to three million small businesses, thousands of middle market companies, and to multinational corporations, financial institutions and governments around the world Working collaboratively with data sourcing, business analyst, and end users, you will be key a player in digital transformation of our organization, designing dynamic data environment for containing and aggregating multiple data sources in an efficient and optimized manner The design of the data environment must allow for creating of data-driven solutions using BI tools, machine learning, predicative analytics, other data science techniques, including AI Evaluates existing database set up in a business domain, redesign of logical and physical data models, thorough documentation Studies data sources by interviewing users; defining, analyzing, and validating data objects; identifying the relationship among data objects Plans data integration process by developing common definitions of sourced data Designing common keys in physical data structure Establishing data integration specifications Examining data applications Examining data models and data warehouse schema; determining best-fit data interchange methods; assessing middleware tools for data integration, transformation, and routing; developing project scope and specifications; identifying factors that negatively impact integration; forecasting resource requirements; establishing delivery timetables Collaborates with business teams and understand how data needs to be structured for consumption Oversight and partaking in the creation of the database using the ETL Architecture Standards Designs and builds relational and NoSQL databases Develops strategies for data acquisitions, archive recovery, and implementation of a database Responsible for making sure an organization’s strategic goals are optimized using enterprise data standards Helps drive data governance strategy, including metadata registry, lineage Understand database strength, weaknesses, tuning strategies Delivery driven, works well in a global matrix organization, builds relationships and gets things done Requirements: Must be able to design, develop and manipulate data warehouses and multidimensional databases, data mappings Requires a depth and breadth of database warehouse knowledge that shall help with formal design of relational databases and provides insight into strategic data manipulation Able to work under pressure, juggle multiple projects, use own initiative and motivation to meet deadlines and set priorities without close supervision Attention to detail and accuracy are critical You will be an enthusiastic team-player, flexible and results driven Excellent spoken and written English, clear oral communication skills Continuous improvement – must be willing and able to express new ideas, concerns and opinions directly to management and wider teams Knowledge and proven skills in Oracle Exadata, Big data tools (Hadoop, HDI, Sparc) Knowledge and proven skills in data modeling and design guidance including identification of data entities Must have experience implementing External tables for data loading Experience with PL/SQL bulk read and write code Must have experience with PL/SQL package driven development Experience and knowledge in the performance design aspects of PL/SQL coding Experience with complex SQL statements and performance aspects of SQL Understanding of data modeling concepts including dimensional modeling Excellent verbal and communications skills Prior experience in defining coding standards and best practices for Oracle PL/SQL development Minimum Oracle v11 experience. Knowledge/experience in 12c PL/SQL enhancements a plus Ability to come up with technical design for loading based on a complex data model Working experience in data mapping for data loading, bulk data loading and External tables Ability to perform SQL tuning of queries, optimize reports and data retrieval response times Strong in debugging and understanding existing code for modifications Able to work as a W2 employee of Genesis10 (no Corp-to-Corp) If you have the described qualifications and are interested in this exciting opportunity, please apply About Genesis10: Genesis10 is a leading U.S. business and technology consulting firm with hundreds of clients needing proven talent and solutions to power their strategic initiatives. If you are a high performing business or IT professional with solid, referenced experience, we want to meet you. Genesis10 recruiters and delivery professionals are highly accomplished career advocates, who get to know you beyond your resume to position you with the opportunities that fit your skills, experience and aspirations. We have benefit options to fit your needs and a support staff that works with you from placement throughout your engagement ā€“ project after project. To learn more about Genesis10 and to view all our available career opportunities, please visit us at www.genesis10.com. “Genesis10 is an Equal Opportunity Employer, M/F/D/Vā€ [...]