Icon hamburger
US
What job do you want?
Apply to this job.
Think you're the perfect candidate?
Apply Now
Thumsup

You’re being taken to an external site to apply.

Enter your email below to receive job recommendations for similar positions.
Default3

Data Warehouse/ BI Architect

Genesis10 Jersey City Contractor
$129,751.00 (Careerbuilder est.)
Apply Now
Genesis10 is currently seeking a Data Warehouse/ BI Architect with our client in the financial industry in their Jersey City, NJ  or Charlotte,NC location. 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”
 

Recommended skills

Data Modeling
Data Warehousing
Metadata
Data Mapping
Extract Transform Load (Etl)
Dimensional Modeling

Location

CareerBuilder Estimated Salary What is the Careerbuilder Estimated Salary? Only about 20% of the jobs in our search results contain salary information. When a job posting doesn’t include a salary, we estimate it by looking at similar jobs in the same industry in that location. It is not necessarily endorsed by the employer and actual compensation may vary based on your experience.

x

What is the Careerbuilder Estimated Salary?

Only about 20% of the jobs in our search results contain salary information. When a job posting doesn’t include a salary, we estimate it by looking at similar jobs in the same industry in that location. It is not necessarily endorsed by the employer and actual compensation may vary based on your experience.
This estimation is based on Job title, Industry, Location and Skills
$129,751
Avg. Yearly Salary
Apply to this job.
Think you're the perfect candidate?
Apply Now

Help us improve CareerBuilder by providing feedback about this job: Report this job

Report this Job

Once a job has been reported, we will investigate it further. If you require a response, submit your question or concern to our Trust and Site Security Team

Job ID: 19-08402

CAREERBUILDER TIP

For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.