We are storming the marketplace with the highly skilled, experienced, and certified professionals that businesses need.

Find your perfect job.

Application Architect V (Closed)

SkillStorm is seeking a Data Analyst for our client in Charlotte, North Carolina. Candidates must be able to work on SkillStorm's W2; not a C2C position. EOE, including disability/vets.

Description:

  • Part of Global Banking Data Strategy team, the role supports Wholesale Credit and Treasury areas of the Client to provide 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.

Responsibilities in the role include and not limited to:

  • 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.
  • 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.
  • Responsible for making sure an organization's strategic goals are optimized through the use of 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.
  • 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

 Minimum Required Skills:

  • 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, data de

Skills:

  • 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 modification

 

#LI-DNI

Similar Jobs

Technical Design Lead

Contract job in Charlotte

JavaScript Developer

Contract job in Charlotte

Business Event Analyst

Contract job in Charlotte

Risk Analyst

Contract job in Charlotte