Responsibilities :
- Develop conceptual, logical models and metadata solutions
- Performing Data Analysis on various data sets
- Design and maintain 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 of ICG
- Determine database structural requirements by analyzing client operations, applications and data from existing systems
- Participate in requirement engineering and working groups and collaborate with business leads, operations, SMEs, technologists and governance teams
- Define, model and rationalize target state solution, socialize with key stakeholders and conduct walkthrough
- Incorporate data standards and implement governance model
- Develop data flows, ownership matrixes, mapping and data lineage
- Assist in the implementation of physical data model, contribute to the system and operational design, carry out optimization for usability and performance
Qualifications :
- 8-10 years hand-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
- Experience in UML / relational / hierarchical / Big Data concepts is a plus
- Prefer data modelling 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, security
- Prior experience in data integration, interoperability and data quality solutions.
- Analytical and problem solver, excellent verbal, written and presentation skills
Education :
- Bachelor’s degree / University degree or equivalent experience
- Certification in Data Architecture / Modeling is a plus
This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.
Data Modeler (Banking)
Performing Data Analysis on various data sets. Determine database structural requirements by analyzing client operations, applications and data from existing systems. Develop data flows, ownership matrixes, mapping and data lineage. Product knowledge in commercial banking, capital and investment ban...
Data Center Hydraulic Modeler
A company is looking for a Data Center Hydraulic Modeler to support data center construction programs within the Execution Engineering team. ...
Sr., Data Analyst
Identify, analyze, and design solutions for, data and system issues that have the potential to negatively impact the credentialing process, department efficiency, downstream data flow, regulations, bylaws, and compliance. Serves as an expert in carrying out the operational responsibilities of data a...
Data Analyst JR: INTL -India
As a member of the data engineering team, you will be the key domain expert overseeing PepsiCo's business process and drive a strong discussion for how Supply Chain, Financial, Consumer, Channel, Category business needs to be defined and prioritize by working very closely with business leads, data s...
Principal Business Analyst - Financial - Work From Home
Principal Business Analyst - Financial. Designs, Develops, Manages and Executes complex business processes and makes recommendations to improve and support business activities. Coordinates business analyst tasks on information technology projects and provide project team member guidance/support thro...
Senior Data Modeler
Data Modeling,OLTP and SQL querying and Power DesignerData Modeling. Experience working with Data Engineering and Data Analytics teams. Strong Data modeling (Conceptual, Logical, Physical, 3nF, Dimensional) at both a project and enterprise level. Data Modeling Tool such as Powerdesigner, Oracle Desi...
Technical Business Analyst - $48bn+ AUM Private Equity firm
Your initial focus will be taking hold of a portfolio of projects to ensure that implementation plans are on track and aligned with business requirements. ...
Pgim Private Capital - Specialist, Business Systems Analyst (hybrid)
Your ability to apply business process analysis knowledge to improve and increase the success of the business by working with both the business process end users and technical teams will help keep our competitive edge. We are looking for an astute, resourceful professional like you to fulfill a busi...
1012 Data Modeler w/SQL Server Admin
Data Modeler w/SQL Server Admin. Develop solution patterns, Data Flow Diagrams, Data Models, ER Models and architectural specifications for your area(s) and work closely with other teams to implement them successfully. Perform database architecture for all technology-enabled capabilities in one or m...
Looking for Data Modeler - Plano, TX (Hybrid role) - Contract (Only W2) // Urgent Hiring
Improving and streamlining processes regarding data flow and data quality to improve data accuracy, viability and value. Have experience as a technical data developer and analyst with data architecture exposure. Experience in Oracle Data Warehouse with large amounts of data. Be able to design the co...