Settings

CAREERS

Senior Analyst, Data Analytics

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

Sr Consultant, Business Analysis

Summary
Founded in Chicago in 1889, Northern Trust is one of the world’s leading financial institutions.  We specialize in providing asset servicing solutions and asset management to both institutional and personal clients.  The delivery of products and services to this client base is supported through a network of offices in more than 40 countries around the globe.
We believe our most valuable asset is our engaged, empowered and diverse workforce.  As a global institution, Northern Trust is committed to building upon this diverse talent through encouraging innovative thinking and personal courage in an inclusive environment.  Northern Trust’s commitment to diversity and inclusion is evident in our internal initiatives for which we have won several globally recognized awards.
Knowledge gathered from raw data has become a valuable commodity in the technology driven data universe of financial services. Here at Northern Trust to support and implement the data analytics strategy in the Audit Services (AS) department, a new highly visible Data Analytics (DA) team is being formed that will be centralized with a physical presence in Chicago and India. Therefore, Northern Trust is seeking a highly skilled professional with the expertise to mine large quantities of data to turn the raw data into actionable insights and useful information. The Data Analytics Miner will be responsible for data profiling extensive data sets, creating data quality recommendations within the environment and processes, applying problem solving to generate efficiencies in the workflows, and creating insightful datasets to answer complex questions from our business partners.  This individual will need to be able to utilize analytical and BI tools to create insights and profiles (models), Extract Transform Load (ETL) tools to create datasets for evaluation, create and document governance (metadata) and linage around the data collected, and suggest and implement efficiencies for automation while utilizing the analytical datasets.  The Data Analytics Miner should be able to work well in a team environment that is collaborative and structured, but be able to take on independent tasks

Major Duties

• Perform extensive data mining including data profiling and data quality analysis
• Develop complex queries against normalized and dimensional models for data exploration
• Work with a complex data environment with large, disparate systems
• Identify current state business process or system inadequacies through analysis 
• Redesign and re-engineer existing datasets and processes so they are robust and repeatable
• Creates process improvements in analytical dataset creation based on analytical analysis
• Improve and streamline processes to improve data accuracy, viability, and value
• Assist in the development and automation of new business analytics solutions
• Collaborate on ETL processes and opportunities for automation
• Communicate complex technical concepts in a manner that a business experts can understand
• Utilize expert problem-solving skills to rapidly create ad-hoc queries to answer complex business questions or identify data issues using analytical datasets
• Create and maintain excellent technical documentation

Experience & Qualifications

Technical Skills Required:
• Bachelor’s degree in Computer Science, Information Systems, Statistical Analysis, or equivalent required
• Strong knowledge of relational database concepts and structures, data integration techniques, ETL processes and SQL best practices
• Knowledge in data quality or profiling tools (e.g., Talend, SSIS, Paxata, Ataccama, Alation)
• Experience with statistical software or other data mining tools (e.g., SPSS, SAS, ODM, Vertica)
• 5+ years of experience with data analysis or data profiling
• Must have 24 months as an Analyst.

Personal Skills Required:
• Strong analytical and problem solving skills
• Knowledge and understanding of data reporting workflows
• Highly developed mathematical skills required
• Strong financial acumen and ability to work across multiple business units
• Ability to foster a positive and collaborative environment
• Able to effectively adapt to highly dynamic and fast paced work environment
• Sense of ownership and urgency, with ability to work both independently and as part of team
• Highly organized and able to function with multiple targets in a deadline driven environment
• Developed oral and written communication skills

Additional Beneficial Competencies:
• Masters in Statistical analysis, or Business Administration
• Experience and knowledge in supporting or participating within an internal/external audit function
• Expertise with decision support or ETL tools a plus (e.g., Abintio, Informatica, DataStage, SSRS)
• Familiarity with other analytics tools a plus (e.g., Microsoft Business Intelligence Suite, R, Python, Spark, H2O)
• Experience using BI tools for insight creation and analytic support a plus (e.g., Tableau, PowerBI, COGNOS, Microstrategy, Spotfire)
• 3+ years of experience in designing and coding ETL or architecting and implementing data models
• 2+ years of relevant experience developing business intelligence, decision support solutions, or creating reporting visualizations

 

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,500 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.


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,500 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 March 31,2019, Northern Trust Corporation had:

$10.9 trillion in assets under custody/administration
$8.2 trillion in assets under custody
$1.2 trillion in assets under management
$122 billion in banking assets

Visit our Careers Site and Talent Network at http://careers.NorthernTrust.com
Like us on http://Facebook.com/NTcareers and Follow us on Twitter @NTcareers

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.

Disclaimer
Northern Trust does not authorize external parties to conduct recruiting events or extend offers of employment on its behalf. It is also not our policy to charge or collect fees of any kind from educational institutions or from candidates for participation in a recruitment event, recruitment process, or to receive offers of employment.

Any person or organization dealing with unauthorized parties, is doing so at their own risk. Northern Trust is not responsible for any losses (monetary or otherwise) that are incurred as a consequence. Northern Trust will also not have any obligation to provide employment to anyone who has been issued a fraudulent offer letter, or to offer any other recourse whatsoever. In order to verify the authenticity of any Northern Trust recruitment event, recruitment process or offer letter you can write to us at talent_acquisition_singapore@ntrs.com.

 

Previous Job Searches

My Profile

Create and manage profiles for future opportunities.

Go to Profile

My Submissions

Track your opportunities.

My Submissions

Similar Listings

India, Karnataka, Bangalore

📁 InformationTechnology

Requisition #: 73173

India, Karnataka, Bangalore

📁 InformationTechnology

Requisition #: 74624

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