Software Engineering - Data Modeler at JPMorgan Chase Bank, N.A. in Wilmington, Delaware

Posted in General Business 8 days ago.

Type: Full-Time

Job Description:

As a member of our Software Engineering Group we look first and foremost for people who are passionate around solving business problems through innovation & engineering practices. You will be required to apply your depth of knowledge and expertise to all aspects of the software development lifecycle, as well as partner continuously with your many stakeholders on a daily basis to stay focused on common goals. We embrace a culture of experimentation and constantly strive for improvement and learning. You'll work in a collaborative, trusting, thought-provoking environment-one that encourages diversity of thought and creative solutions that are in the best interests of our customers globally.

This Data Modeler role requires a wide variety of strengths and capabilities, including:

  • BS/BA degree or equivalent experience
  • Gather and Publish Data Dictionaries: Maintain data models in ER/win. Capture data models from existing databases, and record descriptive information into Erwin.
  • Identify business needs, organize and define data, create and maintain Conceptual, Logical and Physical data models; Maintain appropriate Version Control on data models.
  • Participate in the de-normalization of the data model, ensuring that business rules which are impacted during de-normalization are implemented via an alternate mechanism (i.e. trigger, application code).
  • Closely work with the App Dev team and DBA to create an appropriate Conceptual, Logical and Physical Data Model.
  • Present data designs and project approaches to the DRB for review and approval, and ensure all DRB artifacts are created.
  • Generate DDL and validate that the DDL is implemented properly.
  • Identify opportunities to reuse data and reduce redundancy in data across the enterprise

Technical Skill

  • Data Modeling: ERWin, TOAD
  • Collaboration Tools: Confluence, JIRA
  • Database Platforms / Language: SQL, Oracle, Teradata, Hadoop, Cassandra and Hive
  • Methodology: Agile/Scrum; Knowledge of writing technical requirements / user stories and experience working in an Agile environment
  • Some Cloud knowledge preferred. Background on CCPA regulation preferred.
  • SQL development a plus
JPMorgan Chase & Co., one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.

We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. In accordance with applicable law, we make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as any mental health or physical disability needs.

Equal Opportunity Employer/Disability/Veterans