Software Engineer II - ETL/Reporting

Job Description
You're ready to gain the skills and experience needed to grow within your role and advance your career - and we have the perfect software engineering opportunity for you.
As a Software Engineer II at JPMorganChase within Employee Platforms team, you are part of an agile team that works to enhance, design, and deliver the software components of the firm's state-of-the-art technology products in a secure, stable, and scalable way.As an emerging member of a software engineering team, you execute software solutions through the design, development, and technical troubleshooting of multiple components within a technical product, application, or system, while gaining the skills and experience needed to grow within your role.
Job responsibilities

• Design and develop scalable and resilient systems using AWS ETL to drive continual, iterative improvements for product teams.
• Execute software solutions, including design, development, and technical troubleshooting.
• Create secure, high-quality production code and maintain algorithms that run synchronously with appropriate systems.
• Produce or contribute to architecture and design artifacts for applications, ensuring software code development meets design constraints.
• Gather, analyze, synthesize, and develop visualizations and reporting from large, diverse data sets to support continuous improvement of software applications and systems.
• Identify hidden problems and patterns in data, using insights to drive improvements in coding hygiene and system architecture.
• Contribute to software engineering communities of practice and participate in events exploring new and emerging technologies.
• Add to a team culture of diversity, opportunity, inclusion, and respect.
• Collaborate with cross-functional teams to deliver robust solutions.
• Implement best practices for code quality, testing, and deployment.
• Support ongoing maintenance and enhancement of existing systems.

Required qualifications, capabilities, and skills

• Formal training or certification on software engineering concepts and 3+ years applied experience
• Demonstrate hands-on experience in system design, application development, testing, and operational stability.
• Code proficiently using Glue and EMR.
• Develop and manage SQL and NoSQL databases.
• Utilize AWS cloud technologies effectively in engineering solutions.
• Apply comprehensive knowledge of the Software Development Life Cycle.
• Understand and implement agile methodologies, including CI/CD, application resiliency, and security.
• Apply expertise in software applications and technical processes within disciplines such as cloud and artificial intelligence.
• Develop applications using multiple Cloud and Traditional Data Engineering technologies, including AWS services like Glue, EMR, and data warehouses.
• Develop data ingestion solutions from on-premise applications to private cloud AWS using services such as S3, Lambda, SQS, Event Bridge, Glue/Glue Studio/Glue workflows/Glue Data Catalogue, CloudWatch, Aurora MySQL/PostgreSQL, and EMR with Python/PySpark.
• Apply advanced understanding of KMS and IAM services.

Preferred qualifications, capabilities, and skills

• Demonstrate proficiency in software engineering disciplines, including business analysis, development, testing, deployment, maintenance, and improvement of software.
• Work with streaming services such as Kafka, AWS MSK, Confluent Kafka, or equivalent services.
• Implement CI/CD processes in AWS Cloud environments and utilize Infrastructure as Code services such as Terraform or CloudFormation.
• Apply knowledge in QuickSight, Sigma, Knowledge Graphs, and GraphDB.