Address
Form of workJob Description
Onsite Flexibility: 80% Remote/1 day onsite in Jersey City NJ
MUST BE LOCAL TO JERSEY CITY NJ
MUST HAVE LINKEDIN PROFILE THAT MATCHES RESUMES YEARS OF EXPERIENCE
Description:
The Data Modeler designs, maintains, and builds conceptual, logical and physical database models and data-driven solutions. They will also be responsible for database architecture, design, creation and optimization. Deriving data conversion and migration methods for existing data, and developing automated conversion and migration methods. The Data Modeler will be part of the Database Review Group and will construct, review and advise on conceptual, logical and physical database designs. Acts as a subject matter expert focusing on standardization of database models and is responsible for forming and maturing the Database Review Process. Applies technical knowledge where expertise is required to interpret questions of processes, the bank's internal standards and external regulatory requirements. Reports to the team lead of Data Design and Development. Has no direct/indirect reports.
Responsibilities:
Meet with business stakeholders and other technical team members to gather analyze application requirements
Designs database solutions to satisfy application, business and technical requirements
Designs, maintains and builds conceptual, logical and physical database models and data-driven solutions using available database development tools.
Designs and maintain source to target mapping.
Implement database solutions using available database development tools.
Facilitates data discovery and design sessions with business stakeholders and other technical team members to gather and analyze database requirements.
Develops standards by which to manage a data modeling practice across the organization.
Translates business requirements into easy to understand and implementable database solutions.
Generates and implements all DDL for Oracle Applications.
Provides support for data specific issues on development and production database systems.
Participates in the software development lifecycle (SDLC) process developing and managing requisite project artifacts.
Manages data delivery projects.
Provides written status reports to management regarding project status, tasks, and risk issues.
Voting member of the Database Review Process.
Qualifications:
Ability to analyze existing database schema DDL/ instance layout and determine impacts migrating to new target schema /instance environment.
Expert functional knowledge of at least one data modeling tool, (i.e., IDA- IBM Infosphere Data Architect/ERWIN/Embarcadero ER/ Studio, etc.).
Expertise in logical and physical modeling.
Ability to interpret regulatory requirements and derive data-driven solutions (i.e., Dodd- Frank, Basel III).
Excellent verbal, written and interpersonal communication skills.
Project management abilities including multi-tasking skills and the ability to work in a fast-paced, deadline-oriented and dynamic environment
Ability to influence people outside the immediate span of control, negotiate and resolve conflicts, and work with business users, IT partners and vendors.
Customer focused team player with a positive attitude, expert communication skills and ability to communicate technical information to Business and Technology partners.
Forward thinker who is able to set direction and seeks to improve business processes that deliver better services. Work Experience: 5 to 7 years of specialized experience
A minimum of 5 years working in a financial institution. 7 years of experience working with logical database design, physical database design and data analysis; 5 years of experience in Reference Data Management and Master Data Management.
Education: Required: High School or Equivalent Preferred: BA / BS (or equivalent experience) Degree in Finance, Mathematics, Computer Science, or Management Information Systems is advantageous.
Licenses / Certifications / Registrations: Language Skills: Business fluency in the following language(s): English
Software Systems / Programming Languages: Required: MS Office, MS Visio and MS project. Preferred: SQL (either in an Oracle or SQL environment). Basic knowledge of regulatory and compliance functions and terminology; business process modeling BPM.
MUST BE LOCAL TO JERSEY CITY NJ
MUST HAVE LINKEDIN PROFILE THAT MATCHES RESUMES YEARS OF EXPERIENCE
Description:
The Data Modeler designs, maintains, and builds conceptual, logical and physical database models and data-driven solutions. They will also be responsible for database architecture, design, creation and optimization. Deriving data conversion and migration methods for existing data, and developing automated conversion and migration methods. The Data Modeler will be part of the Database Review Group and will construct, review and advise on conceptual, logical and physical database designs. Acts as a subject matter expert focusing on standardization of database models and is responsible for forming and maturing the Database Review Process. Applies technical knowledge where expertise is required to interpret questions of processes, the bank's internal standards and external regulatory requirements. Reports to the team lead of Data Design and Development. Has no direct/indirect reports.
Responsibilities:
Meet with business stakeholders and other technical team members to gather analyze application requirements
Designs database solutions to satisfy application, business and technical requirements
Designs, maintains and builds conceptual, logical and physical database models and data-driven solutions using available database development tools.
Designs and maintain source to target mapping.
Implement database solutions using available database development tools.
Facilitates data discovery and design sessions with business stakeholders and other technical team members to gather and analyze database requirements.
Develops standards by which to manage a data modeling practice across the organization.
Translates business requirements into easy to understand and implementable database solutions.
Generates and implements all DDL for Oracle Applications.
Provides support for data specific issues on development and production database systems.
Participates in the software development lifecycle (SDLC) process developing and managing requisite project artifacts.
Manages data delivery projects.
Provides written status reports to management regarding project status, tasks, and risk issues.
Voting member of the Database Review Process.
Qualifications:
Ability to analyze existing database schema DDL/ instance layout and determine impacts migrating to new target schema /instance environment.
Expert functional knowledge of at least one data modeling tool, (i.e., IDA- IBM Infosphere Data Architect/ERWIN/Embarcadero ER/ Studio, etc.).
Expertise in logical and physical modeling.
Ability to interpret regulatory requirements and derive data-driven solutions (i.e., Dodd- Frank, Basel III).
Excellent verbal, written and interpersonal communication skills.
Project management abilities including multi-tasking skills and the ability to work in a fast-paced, deadline-oriented and dynamic environment
Ability to influence people outside the immediate span of control, negotiate and resolve conflicts, and work with business users, IT partners and vendors.
Customer focused team player with a positive attitude, expert communication skills and ability to communicate technical information to Business and Technology partners.
Forward thinker who is able to set direction and seeks to improve business processes that deliver better services. Work Experience: 5 to 7 years of specialized experience
A minimum of 5 years working in a financial institution. 7 years of experience working with logical database design, physical database design and data analysis; 5 years of experience in Reference Data Management and Master Data Management.
Education: Required: High School or Equivalent Preferred: BA / BS (or equivalent experience) Degree in Finance, Mathematics, Computer Science, or Management Information Systems is advantageous.
Licenses / Certifications / Registrations: Language Skills: Business fluency in the following language(s): English
Software Systems / Programming Languages: Required: MS Office, MS Visio and MS project. Preferred: SQL (either in an Oracle or SQL environment). Basic knowledge of regulatory and compliance functions and terminology; business process modeling BPM.
