Senior Data Modeler / Design Specialist

Company: SMBC Group
Location: Jersey City
Posted on: September 21, 2022

Job Description:

The Data Design Specialist 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. TheData Design Analyst will be part of the JRIA Database Review Group and will construct, review and advise on conceptual, logical and physical database designs throughout JRIA. 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.Meet with business stakeholders and other technical team members to gather analyze application requirementsDesigns database solutions to satisfy application, business and technical requirementsDesigns, 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.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 environmentAbility 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.Prior experience working in a financial institution and 7+ years of experience working with logical database design, physical database design and data analysis; Experience in Reference Data Management and Master Data Management.Education: Required:High School or EquivalentPreferred:BA / BS (or equivalent experience) Degree in Finance, Mathematics, Computer Science, or Management Information Systems is advantageous.

Keywords: SMBC Group, Jersey City , Senior Data Modeler / Design Specialist, Accounting, Auditing , Jersey City, New Jersey