Software Engineer III, Data Modeling
JPMorgan Chase
- Wilmington, DE
- Permanent
- Full-time
- 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.
- Formal training or hands-on experience 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
- Familiarity with modern front-end technologies
- Previous experience in financial services industry