Settings

CAREERS
📁
InformationTechnology
📅
71028 Requisition #
Apply for Job
Share this Job
Sign Up for Job Alerts

For more than a century, Northern Trust has worked hard building our legacy of outstanding service, expertise and integrity. From a Chicago-based bank founded in 1889, we now have more than 20 international locations and 18,100 employees globally. We serve the world’s most-sophisticated clients – from sovereign wealth funds and the wealthiest individuals and families, to the most-successful hedge funds and corporate brands.


We burnished our reputation as a global leader delivering innovative investment management, asset and fund administration, fiduciary and banking solutions enabled by sophisticated, leading technology. And through it all, we continually laid a solid, forward-looking foundation on which future generations can continue growing and achieving greater.


As of June 30, 2018, Northern Trust Corporation had:


$135 billion in banking assets

$8.1 trillion in assets under custody

$10.7 trillion in assets under custody/administration

$1.1 trillion in assets under management


Must have (Technical)

 

• Configuration of the OFSAA solution, 5+years of experience on OFSAA.

• Research and solve the data related issues within the environment.

• Advising other assets engaged in the project on OFSAA configuration details.

• Experience in leading and developing data warehousing applications/ profitability applications in financial and banking domain.

• Act as business analyst for gathering requirements

• Recommend enhancements in Oracle DB and tool based on implementation experience. • Experienced in all phases of Software Development Life Cycle

• Knowledge of Oracle 11g, SQL, PL SQL, Erwin, Data Architecture, Unix Shell Scripting, advanced Performance tuning

 

• Experienced in OFSAA Data Foundation Must have (Operational)

• Designs technology solutions by modeling requirements and applying standard application methodology best practices

• Thorough understanding of key business processes and ability to communicate and translate those needs to technical solutions

• Work closely with business partners, technical resources and management (Application Managers, Business Analysts, System Analysts and Development teams)

• Evaluate the risks and solutions before taking action, so that action plans are timely, realistic and positive

• Understand complex SQL queries, analyze data related issues and identify root cause of issues / defects. Develop and implement performance optimal system.

• Maintain the end-to-end OFSAA batch and provide technical support.

• Document system process flows and write test scripts for system testing.

• Excellent written and verbal communication skills Nice to have:

 

• Experience with other profitability methodologies Major Responsibilities:

 

 • Configuration and maintenance of FTP rules and T2Ts to transform data in OFSAA.

• Troubleshoot technical issues by analyzing OFSAA log files and fixing the issues. Analyze data related issues and identify root cause of issues / defects.

• Testing in support of projects and creation of project artifacts as required by project life cycle.

 

 

• Production support of OFSAA, this includes batch runs and minor development requests to fix defects as required.

• Support projects per SDLC procedure – Perform analysis based on business requirement, design, develop, test and implement changes to Oracle Application and related interfaces.

Qualifications

 

• Education Bachelor's Degree in Computer Science or Information Systems.

• 5 - 8 years of IT experience

• 5+ years of experience in implementing OFSAA v8.0 or higher

 • Sound understanding of key processing dimensions, hierarchies and attributes within OFSAA Profitability solution.

• Good knowledge of the end-to-end data flow and profitability calculations within OFSAA profitability solution.

• Working knowledge of writing SQL queries and troubleshoot data related issues. • Flexible in managing competing priorities and objectives.

• Ability to work independently as needed.

Previous Job Searches

My Profile

Create and manage profiles for future opportunities.

Go to Profile

My Submissions

Track your opportunities.

My Submissions

Similar Listings

United States, Illinois, Chicago

📁 InformationTechnology

Requisition #: 73467

United States, Illinois, Chicago

📁 InformationTechnology

Requisition #: 73466

United States, Illinois, Chicago

📁 InformationTechnology

Requisition #: 65679

Reasonable Accommodation
Northern Trust is committed to working with and providing reasonable accommodations to individuals with disabilities. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the employment process, please email our HR Service Center or call 1-800-807-0302 (North America), +630-276-5353 (Asia Pacific), +44(0)207 982 4357 (Europe, Middle East and Africa) and let us know the nature of your request and your contact information.

Equal Employment Opportunity Statements
  • APAC EEO Statement
    • APAC EEO STATEMENT

      It is the policy and practice of Northern Trust to provide equal employment opportunities to all employees and applicants. Northern Trust does not discriminate on the basis of race, colour, religion or belief, nationality, ethnic or national origin, sex, marital status, sexual orientation, disability or age. All employment decisions will be made in a non-discriminatory manner in accordance with our obligations under the law and codes of practice. This includes human resources’ decisions relating to recruitment, terms and conditions of employment, transfers, promotions and access to learning and development.

  • Canada EEO Statement
    • Canada EEO STATEMENT

      Northern Trust is an Equal Opportunity Employer. Hiring and other employment decisions at Northern Trust are made without regard to race, colour, religion, sex, ancestry, national origin, ethnic origin, age, disability, citizenship, veteran status, sexual orientation, record of offences, marital status, family status, or any other characteristic protected by federal, provincial, or local law, regulation, or ordinance.

  • EMEA EEO Statement
    • EMEA EEO STATEMENT

      It is the policy and practice of Northern Trust to provide equal employment opportunities to all employees and applicants. Northern Trust does not discriminate on the basis of race, colour, religion or belief, nationality, ethnic or national origin, sex, marital status, sexual orientation, disability or age. All employment decisions will be made in a non-discriminatory manner in accordance with our obligations under the law and codes of practice. This includes human resources’ decisions relating to recruitment, terms and conditions of employment, transfers, promotions and access to learning and development.

  • USA EEO Statement
    • USA EEO STATEMENT

      It is the policy of The Northern Trust Company to afford equal opportunity in all phases of employment without regard to an individual's age, race, color, religion, creed, gender, national origin, citizenship status, marital status, pregnancy, sexual orientation, gender identity, gender expression, genetic tests and information, physical or mental disability, protected veteran status or any other legally protected status. EEO poster (U.S.)EEO is Law Poster Supplement