Data Modeler

Axelon Services Corporation

Irving, TX

JOB DETAILS
SKILLS
Analysis Skills, Big Data, Blueprints, Business Operations, Business Strategy, Commercial Banking, Credit Risk, Data Analysis, Data Management, Data Mapping, Data Modeling, Data Quality, Data Sets, Enterprise Architecture, Finance, Illustrating Ability, Information Architecture, Interoperability, Investment Capital, Investment Services, Loans, Metadata, Needs Assessment, Operational Audit, Oracle, Performance Tuning/Optimization, Presentation/Verbal Skills, Problem Solving Skills, Regulatory Reports, Relational Databases (RDBMS), Requirements Management, Risk, Risk Management, SQL (Structured Query Language), Scripting (Scripting Languages), System Operations, Unified Modeling Language (UML), Usability Engineering, Wholesale Industry, Writing Skills, erwin Data Modeler
LOCATION
Irving, TX
POSTED
4 days ago


Pay Rate: $67.00 - $72.00 Negotiable based upon years of experience



Summary:

  • Location: Irving, TX
  • Work Mode: Hybrid


Responsibilities:

  • Identify data and information needs for the wholesale lending business.
  • Develop conceptual, logical models and metadata solutions.
  • Perform data analysis on various data sets.
  • Design and maintain a blueprint of the information architecture, data integrations, and controls aligned to the renewed business strategy.
  • Unify data concepts across disparate front office, credit risk, servicing, and reporting functions.
  • Determine database structural requirements by analyzing company operations, applications, and data from existing systems.
  • Participate in requirement engineering and working groups, collaborating with business leads, operations, SMEs, technologists, and governance teams.
  • Define, model, and rationalize target state solutions, socialize with key stakeholders, and conduct walkthroughs.
  • Incorporate data standards and implement a governance model.
  • Develop data flows, ownership matrices, mapping, and data lineage.
  • Assist in the implementation of physical data models, contribute to system and operational design, and optimize for usability and performance.


Requirements:

  • 8-10 years of hands-on experience in data modeling and implementation using RDBMS, Oracle preferred.
  • Hands-on modeling expertise using Magic Draw, Erwin, or Enterprise Architect and metadata management tools.
  • Financial industry knowledge in wholesale lending, risk management, servicing, and risk/regulatory reporting.
  • SQL query knowledge and performing data analysis.
  • Product knowledge in commercial banking, capital and investment banking, and markets.


Preferred Skills:

  • Experience in UML/relational/hierarchical/Big Data concepts is a plus.
  • Prefer data modeling experience using Magic Draw and Cameo. Utilize Code Engineering Sets to generate executable code or a database script. Write custom macros to efficiently validate and manage data models.
  • Knowledge of data management methodologies involving architecture, modeling, storage, and security.
  • Prior experience in data integration, interoperability, and data quality solutions.
  • Analytical and problem-solving skills, excellent verbal, written, and presentation skills.


Education:

  • Bachelors degree/University degree or equivalent experience.
  • Certification in Data Architecture/Modeling is a plus.

About the Company

A

Axelon Services Corporation