JPMorgan Software Engineer III Data Modeling 

United States, Delaware, Wilmington 

816184673

Job responsibilities

• Executes software solutions, design, development, and technical troubleshooting with ability to think beyond routine or conventional approaches to build solutions or break down technical problems.
• Gathers, analyzes, synthesizes, and develops visualizations and reporting from large, diverse data sets in service of continuous improvement of software applications and systems
• Works with firm wide recommended data modeling tools to design, develop data warehouse systems/data mart, OLTP, OLAP/BI
• Performs Data Analysis and Data Profiling on different kinds of databases (relational, non-relational/NoSQL) to derive insights based on data to enable better decision making
• Creates conceptual, Logistical, & Physical Data Models and obtain approvals from Data Review Board/Stakeholders
• Creates source to target data mapping documents, Metadata inventory documents, and DDLs for physical implementation
• Normalizes (1/2/3 NF) and de-normalize database structures as per business needs, optimize database deigns for better performance by recommending best practices such as indexes, partitions, appropriate use of data types, collecting stats, etc.
• Performs ETL (Extract/Transform/Load) from various sources inclusive of databases spreadsheets for Data Integration purposes
• Establishes & tracks Data Governance, Data Management and Data Quality Policies and Process implementations. This includes ensuring there is proper data sourcing, metadata and lineage capture, data protection classification, masking/hashing data, data landscape updates and data quality rule implementation on all critical feeds.
• Defines & documents Data Modeling standards, processes, best practices, conduct trainings.
• Provides leadership, mentoring and guidance to junior team members to ensure data models are of high quality.

Required qualifications, capabilities, and skills

• Formal training or certification in software Engineering and 3+ years applied experience
• Hands-on practical experience in system design, application development, testing, and operational stability
• Proficient in coding in one or more languages
• Experience in developing, debugging, and maintaining code in a large corporate environment with one or more modern programming languages and database querying languages
• Experience in data modeling technologies using Erwin, Magic Draw, Hadoop, Hive, Impala, Teradata, Oracle, SQL, Java, Unix,
• Experience in cloud technologies such as AWS S3, RDS
• Experience in data management data architecture, data quality, and data governance
• Overall knowledge of the Software Development Life Cycle
• Solid understanding of agile methodologies such as CI/CD, Application Resiliency, and Security
• Demonstrated knowledge of software applications and technical processes within a technical discipline (e.g., cloud, artificial intelligence, machine learning, mobile, etc.)
• Experience in proactively identifying hidden problems and patterns in data and uses these insights to drive improvements to coding hygiene and system architecture

Preferred qualifications, capabilities, and skills

• Familiarity with modern front-end technologies
• Previous experience in financial services industry