SQL Performance and Analytics Solutions Senior Associate

Posted 7 Days Ago
Be an Early Applicant
Manila, First District NCR, National Capital Region
Hybrid
5-7 Years Experience
Financial Services
We’re one of the world’s biggest technology-driven companies
The Role
As a Senior Associate, you'll utilize strong SQL and data analytics skills to develop operational reports and executive dashboards in the mortgage servicing field. Collaborating with stakeholders, you'll analyze reporting needs, optimize SQL performance, and migrate dashboards to cloud platforms. The role demands strong communication and analytical capabilities to manage and derive insights from large datasets.
Summary Generated by Built In

Job Description
Bring your expertise on using your strong SQL development skills and knowledge of Oracle, SQL Server, Teradata, and other related RDBMS.
As a Data Analytics Sr. Manager in our Home Lending team, you will identify the business's reporting needs and develop operational reports, executive dashboards, and ad-hoc analysis. Your role includes gathering business requirements, identifying data sources, and collaborating with Data teams to build optimal data solutions. You will use your strong SQL development skills and knowledge of Oracle, SQL Server, Teradata, and other related RDBMS. Your role requires mortgage servicing business knowledge, data science, and data management skills. You will focus on designing, building, and implementing reports and digital dashboards. We are looking for a strong communicator who is eager to learn and thrive in a collaborative environment.
Job Responsibilities:

  • Collaborates with business partners to understand their reporting needs and develop solutions that enhance data consumption and reporting efficiency.
  • Analyze complex reporting issues, identify root causes, and propose solutions with clear and concise documentation.
  • Fosters strong relationships with business stakeholders, technology teams, and subject matter experts.
  • Participates in the design, architecture, and implementation of data models, working closely with technical partners.
  • Optimizes performance through advanced techniques like query tuning, stored procedures, and indexing in SQL Server.
  • Migrates existing Excel/SSRS dashboards and reports to a modern cloud platform and rewrites existing SQL code to align with new data model databases.


Required qualifications, capabilities and skills:

  • Bachelor's degree in Finance, Data Engineering, Management Information Solutions, Data Science, or similar discipline
  • 3 years of experience in financial services, business analytics, project management, or a similar field.
  • Excellent written and verbal communication skills to connect with all levels of the organization.
  • Ability to thrive in a fast-paced environment, manage multiple tasks effectively, and prioritize efficiently.
  • Strong analytical skills with the ability to analyze large datasets and communicate insights clearly.
  • Proficiency in SQL, including advanced skills in SQL code performance tuning, query optimization, and indexing.
  • Proficiency in MS SSRS, SSAS, SSIS and Excel
  • Experience with data visualization tools like Tableau or Power BI. Experience with AWS tools such as Snowflake, Glue, Redshift, QuickSight, and Athena
  • Familiarity with Python, Alteryx, Agile methodologies, Confluence, JIRA, data warehousing, and ETL pipelines.
  • Understanding of different data model types and design principles and understanding of cloud platforms such as AWS


About Us
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 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.
About the Team
Our Consumer & Community Banking division serves our Chase customers through a range of financial services, including personal banking, credit cards, mortgages, auto financing, investment advice, small business loans and payment processing. We're proud to lead the U.S. in credit card sales and deposit growth and have the most-used digital solutions - all while ranking first in customer satisfaction.

Top Skills

Python
SQL

What the Team is Saying

Nick S.
Lupe C.
Edwin T.
Dawn T.
Meng M.
The Company
HQ: New York, NY
289,097 Employees
Hybrid Workplace
Year Founded: 1799

What We Do

JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm with assets of $3.7 trillion and operations worldwide. The firm is a leader in investment banking, financial services for consumers and small businesses, commercial banking, financial transaction processing, and asset management. A component of the Dow Jones Industrial Average, JPMorgan Chase & Co. serves millions of consumers in the United States and many of the world’s most prominent corporate, institutional and government clients under its J.P. Morgan and Chase brands.

Technology fuels every aspect of our company and is at the heart of everything we do. With over 50,000 technologists globally and an annual tech spend of $12 billion, we are dedicated to improving the design, analytics, development, coding, testing and application programming that goes into creating high quality software and new products.

Learn more about technology at our firm, explore resources from our Distinguished Engineers, AI & ML researchers, and other experts; access the latest episode of our TechTrends podcast, and more at www.jpmorgan.com/technology. Information about JPMorgan Chase & Co. is available at www.jpmorganchase.com.

©2023 JPMorgan Chase & Co. All rights reserved. JPMorgan Chase is an Equal Opportunity Employer, including Disability/Veterans.

Why Work With Us

Our technologists work on a diverse range of solutions that include strategic technology initiatives, big data, mobile, electronic payments, machine learning, cybersecurity, enterprise cloud development, and other state-of-the-art technologies.

Gallery

Gallery
Gallery
Gallery
Gallery
Gallery
Gallery

JPMorganChase Teams

Team
Product + Tech
About our Teams

JPMorganChase Offices

Hybrid Workspace

Employees engage in a combination of remote and on-site work.

Typical time on-site: Flexible
Company Office Image
HQNew York, NY
SG
Bengaluru, Karnataka
Bournemouth, GB
Brooklyn, NY
Buenos Aires, Avaya
Chicago, IL
Dallas, TX
Dublin, IE
Glasgow, GB
Houston, TX
Hyderabad, Telangana
London, GB
Mumbai, Maharashtra
Philadelphia, PA
San Francisco, CA
Tampa, FL
Westerville, OH
Wilmington, DE
Learn more

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account