Software Engineer III

We have an exciting and rewarding opportunity for you to take your software engineering career to the next level.

As a Software Engineer III at JPMorgan Chase within Asset and Wealth Management, you will be an experienced member of an agile team, tasked with designing and delivering reliable, market-leading technology products that are secure, stable, and scalable. Your role involves implementing essential technology solutions across diverse technical domains, supporting various business functions to achieve the firm's strategic goals.

Job responsibilities

• Design, develop, and optimize complex PL/SQL procedures and functions.
• Perform SQL tuning and optimization to enhance performance.
• Implement resilient setups, including partitioning, indexing, clustering, and debugging.
• Develop and manage materialized views to improve query performance and data retrieval.
• Lead migration efforts of complex procedures to SQL, ensuring seamless integration and functionality.
• Design and implement Snowflake solutions, including external tables and dynamic queries.
• Manage sharing objects and visibility settings to ensure secure and efficient data access.
• Develop and optimize materialized views for enhanced data processing.
• Facilitate data movement in and out of Snowflake, ensuring data integrity and security.
• Optimize compute resources and monitor costs to ensure efficient and cost-effective operations.

• Formal training or certification on software engineering concepts and 3+ years applied experience
• Extensive hands-on experience in Oracle PL/SQL development and Snowflake implementation.
• Proven track record in SQL tuning, resilient setups, and migration of complex procedures.
• Strong understanding of materialized views, partitioning, indexing, and clustering in Oracle.
• Experience with external tables, dynamic queries, and compute optimization in Snowflake.
• Proficient in debugging and optimizing database systems for performance and reliability.
• Solid understanding of data sharing, visibility, and security best practices.
• Knowledge of cost monitoring and optimization strategies in Snowflake.
• Excellent communication skills to work effectively with cross-functional teams.
• Ability to provide technical leadership and mentorship to junior developers.

• Familiarity with cloud-based data solutions and integration strategies.
• Exposure to modern data visualization and reporting tools.
• Proficiency in Java and Python for enhanced software development capabilities.
• Experience with AI/ML technologies to drive innovation and data-driven insights.
• Passion for exploring new technologies and driving innovation in database systems.