Apply Now    

Software Engineer -ETL & Database

Req #: 180032207
Location: Plano, TX, US
Job Category: Technology
Potential Referral Amount: 3000 US Dollar (USD)
As a member of our Software Engineering Group you will dive head-first into creating innovative solutions that advance businesses and careers. You’ll join an inspiring and curious team of technologists dedicated to improving the design, analytics, development, coding, testing and application programming that goes into creating high quality software and new products. You’ll be tasked with keeping the team and other key stakeholders up to speed on the progress of what’s being developed. Coming in with an understanding of the importance of end-to-end software development-such as Agile frameworks-is key. And best of all, you’ll be working with and sharing ideas, information and innovation with our global team of technologists from all over the world.
 
The Prime Brokerage Cross Business Financial Analytics & Control Group, within JPMorgan Corporate & Investment Bank - P&L Engine and Analytics, seeks to generate the most efficient, accurate and readily-useable Reports, Data feeds, & Back-up files for Senior Management and other users across many departments in Prime Services -- including the Front Office, Risk Management, and Operations.
These reports provide advisory, evaluation & business-decision support (such as Daily P&L reports per Salesperson and Daily Client Equity trends), analysis for regulatory controls (like 15C3-3 and Basel I & II schedules), month-end commissions & fees extracts (supporting Operations Billing & Accounting), and granular detail-level reconciliations (ranging from all stock ECN/Exchange charges, to option Broker bills, to inter-department systems validation).
The Financial Analytics & Control Group handles vast amounts of data from various sources which we analyze & transform the immense raw information into useful files that are easy & clear to understand, supporting the business activities of the firm.
Role description:  Data Analytics Analyst
The candidate, to be based in Dallas, will be responsible for assisting the team in covering the following functions:
    • Analyzing and generating financial reports
    • Performing ad-hoc queries and problem solving P&L issues through: Mainframe, SAS, Excel Spreadsheets for controllers, business and other relevant areas in a timely fashion
    • Working knowledge of various warehouse methodologies, technologies and design concepts
    • Communicating and follow up with all relevant areas (Billing, Interest, Middle Office, Front Office, Technology) as needed.
 
This role requires a wide variety of strengths and capabilities, including:
  • Advanced knowledge of application, data and infrastructure architecture disciplines
  • Understanding of architecture and design across all systems 
  • Working proficiency in developmental toolsets
  • Ability to collaborate with high-performing teams and individuals throughout the firm to accomplish common goals
  • Proficiency in one or more general purpose programming languages -
  • Understanding of software skills such as business analysis, development, maintenance and software improvement
 
  1. The candidate should have experience in developing and designing enterprise-wide applications from end to end.
  2. Hands on experience with UNIX shell scripting, Cognos, ETL tool [either of PENTAHO or INFORMATICA], Oracle, Version Control [CVS/SVN/Git].
  3. Experience with VB scripting and Access database, SAS programs.
  4. Good to have:
  • Java knowledge
  • Mainframes

 

Our Corporate & Investment Bank relies on innovators like you to build and maintain the technology that helps us safely service the world’s important corporations, governments and institutions. You’ll develop solutions for a bank entrusted with holding $18 trillion of assets and $393 billion in deposits.  CIB provides strategic advice, raises capital, manages risk, and extends liquidity in markets spanning over 100 countries around the world.
When you work at JPMorgan Chase & Co., you’re not just working at a global financial institution. You’re an integral part of one of the world’s biggest tech companies. In 14 technology hubs worldwide, our team of 40,000+ technologists design, build and deploy everything from enterprise technology initiatives to big data and mobile solutions, as well as innovations in electronic payments, cybersecurity, machine learning, and cloud development. Our $9.5B+ annual investment in technology enables us to hire people to create innovative solutions that will not only transform the financial services industry, but also change the world. 

At JPMorgan Chase & Co. we value the unique skills of every employee, and we’re building a technology organization that thrives on diversity.  We encourage professional growth and career development, and offer competitive benefits and compensation.  If you’re looking to build your career as part of a global technology team tackling big challenges that impact the lives of people and companies all around the world, we want to meet you. 
 
@2017 JPMorgan Chase & Co. JPMorgan Chase is an equal opportunity and affirmative action employer Disability/Veteran
 
 
Apply Now    

Join our Talent Community

Not ready to apply? Leave your information with us and we will keep you up to date with new career opportunities.

Things to note

Sign in to our application system to continue your job search or update your profile.

Current employees sign in here. Contractors sign in here.

Any information you provide is confidential and will only be viewed by our recruiters in an effort to fill open positions. In addition, the information you provide is subject to our privacy policy practices.

Please note that J.P. Morgan will not accept unsolicited approaches or speculative CVs, nor will J.P. Morgan be responsible for any related fees, from Third Party Firms who are not preferred suppliers.

The firm invites all interested and qualified candidates to apply for employment opportunities.

Need disability related assistance?

If you are a US or Canadian applicant with a disability who is unable to use our online tools to search and apply for jobs, please click here.

Important links

Click here to view the "EEO is the Law" poster.

Click here to view the "EEO is the Law" supplemental poster.

Click here to view our U.S. Pay Transparency Policy.

JPMorgan Chase is an equal opportunity and affirmative action employer Disability/Veteran.