Commercial and Investment Bank - Data Modeler Senior Associate

Location: Brooklyn, NY, United States

Job Family: Analytics Solutions & Delivery

About the Role

At JP Morgan Chase, we are at the forefront of financial innovation, powering global markets and economies through our Commercial and Investment Bank division. As a Data Modeler Senior Associate in the Analytics Solutions & Delivery team, you will play a pivotal role in designing and implementing end-to-end data models that drive strategic decision-making and operational efficiency. Based in our state-of-the-art Brooklyn, NY office, you will work on high-impact projects involving complex financial datasets, from trade executions to risk assessments, ensuring our data infrastructure supports the dynamic needs of investment banking clients worldwide. This position offers the opportunity to collaborate with elite teams in a collaborative environment that values innovation and excellence. Your core responsibilities will include developing scalable data architectures that integrate seamlessly with JP Morgan Chase's enterprise systems, adhering to stringent regulatory frameworks such as those from the SEC and Federal Reserve. You will analyze business requirements from commercial lending and capital markets teams, translating them into logical and physical data models that enhance data accuracy, accessibility, and performance. By leveraging advanced tools and methodologies, you will optimize models for real-time analytics, supporting everything from portfolio management to compliance reporting. This role demands a deep understanding of financial services data challenges, including handling high-velocity transaction data and ensuring robust data lineage for audit purposes. Joining JP Morgan Chase means becoming part of a legacy of trust and leadership in finance, with access to cutting-edge technologies and professional growth opportunities. You will contribute to transformative initiatives that shape the future of banking, while benefiting from a supportive culture that fosters work-life balance and continuous learning. If you are passionate about data-driven solutions in the financial sector and ready to make a meaningful impact, this Senior Associate position is your chance to excel in a world-class organization.

Key Responsibilities

• Design and implement end-to-end data models to support commercial and investment banking operations at JP Morgan Chase
• Collaborate with business stakeholders, data scientists, and IT teams to gather requirements and translate them into robust data architectures
• Develop and maintain conceptual, logical, and physical data models using industry-standard tools and methodologies
• Ensure data models comply with regulatory standards, internal governance policies, and best practices for data quality and security
• Optimize data models for performance, scalability, and integration with enterprise systems like core banking platforms
• Conduct data lineage analysis and impact assessments for changes in financial products or market regulations
• Support data migration and integration projects for mergers, acquisitions, or new product launches in investment banking
• Mentor junior associates and contribute to knowledge sharing within the Analytics Solutions & Delivery team
• Monitor and troubleshoot data model issues, providing solutions to enhance analytics and reporting capabilities
• Stay abreast of emerging technologies and trends in financial data modeling to drive innovation at JP Morgan Chase

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, Finance, or a related field; Master's degree preferred
• 5+ years of experience in data modeling, database design, and data architecture within the financial services industry
• Proficiency in relational database management systems (RDBMS) such as Oracle, SQL Server, or PostgreSQL
• Strong understanding of data warehousing concepts, ETL processes, and data governance in a banking environment
• Experience with financial data standards like FpML, ISO 20022, or regulatory reporting requirements (e.g., Basel III, Dodd-Frank)
• Demonstrated ability to work in agile environments and collaborate with cross-functional teams in investment banking
• Excellent problem-solving skills and attention to detail in handling complex datasets

Preferred Qualifications

• Experience in commercial and investment banking domains, including risk modeling or trade data management
• Familiarity with cloud-based data platforms such as AWS, Azure, or Google Cloud in a financial context
• Certification in data modeling (e.g., Certified Data Management Professional) or relevant financial certifications (e.g., CFA Level I)
• Prior work at a major financial institution with exposure to high-volume transaction data
• Knowledge of machine learning applications in data modeling for predictive analytics in banking

Required Skills

• Data modeling tools (e.g., ER/Studio, PowerDesigner, or Erwin)
• SQL and PL/SQL programming for query optimization
• ETL tools (e.g., Informatica, Talend, or SSIS)
• Big data technologies (e.g., Hadoop, Spark) for handling large-scale financial datasets
• Conceptual, logical, and physical data modeling techniques
• Data governance and metadata management
• Financial domain knowledge in commercial and investment banking
• Regulatory compliance and risk management principles
• Agile and Scrum methodologies
• Python or R for data analysis and scripting
• Cloud computing platforms (e.g., AWS RDS, Azure Synapse)
• Problem-solving and analytical thinking
• Communication and stakeholder management
• Attention to detail and accuracy
• Team collaboration and leadership

Benefits

• Competitive base salary and performance-based annual bonuses
• Comprehensive health, dental, and vision insurance plans
• 401(k) retirement savings plan with company matching contributions
• Generous paid time off, including vacation, sick days, and parental leave
• Professional development opportunities, including tuition reimbursement and access to internal training programs
• Employee stock purchase plan and financial wellness resources
• On-site fitness centers, wellness programs, and mental health support
• Flexible work arrangements and commuter benefits for Brooklyn, NY location

JP Morgan Chase is an equal opportunity employer.