JPMorgan Chase & Co.
Software Engineer III, Data Modeling
Job Description
We have an exciting and rewarding opportunity for you to take your software engineering career to the next level.
As a Software Engineer III, Data Modeling at JPMorgan Chase within the Corporate sector, specifically within the Risk Technology team, you will be a seasoned member of an agile team, responsible for designing and delivering trusted market-leading technology products in a secure, stable, and scalable manner. Your role will involve implementing critical technology solutions across multiple technical areas within various business functions in support of the firm’s business objectives.
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
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 offer a competitive total rewards package including base salary determined based on the role, experience, skill set, and location. For those in eligible roles, we offer discretionary incentive compensation which may be awarded in recognition of firm performance and individual achievements and contributions. We also offer a range of benefits and programs to meet employee needs, based on eligibility. These benefits include comprehensive health care coverage, on-site health and wellness centers, a retirement savings plan, backup childcare, tuition reimbursement, mental health support, financial coaching and more. Additional details about total compensation and benefits will be provided during the hiring process.
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. We also make reasonable accommodations for applicants’ and employees’ religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.
JPMorgan Chase is an Equal Opportunity Employer, including Disability/Veterans