Settings

CAREERS

Sr Consultant - Data Analytics Audit

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

Technology continues to drive the financial industry, highly skilled business intelligence specialists have become essential to success. 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.

 Northern Trust is seeking a professional that desires to use their skills as a Business Intelligence Specialist to drive insightful thinking and thought provoking visuals. The responsibilities of this analyst will include working with business partners to develop, identify, and prioritize opportunities for analytical solutions, create and implement valuable data insights for management to use for daily decisions, collaborate within a team to identify efficiencies, and work directly with management to align with the AS strategic direction. This will include the use of BI tools to assist in the insightful process, creation of highly complicated aggregated analytical datasets to derive value, and presentation and communication of the intelligence found from the support of AS.  The BI specialist will need to be a great communicator and an excellent team player, able to partner with management of all levels.

 

Business Intelligence Reporting Specialist


Responsibilities


• Work with the business leaders and stakeholders to understand their strategies, how they align with the corporate strategies, and determine ways to use analytics to help them in decision making
• Work across business units to define and develop analytic capabilities that can be leveraged to solve cross business unit challenges
• Support the analytic needs of business units to help with prioritization to deliver the most valuable solutions  
• Analyze and understand Northern Trust’s core business processes and data flows to design and develop enduring solutions that provide analytical insights
• Develop and deliver solutions that leverage and extend existing Business Intelligence and analytics infrastructure
• Create metric governance within AS and propagate it into the enterprise where applicable
• Ensure all developed BI solutions are scalable, repeatable, supportive, and effective
• Assist with applying and developing statistical models/methods to address business issues using BI tools
• Develop metrics and create ad-hoc reporting as needed to support AS vision
• Assist internal customers with acceptance and adoption of implemented solutions
• Propagate and enable a self-service operating model to empower the AS staff in their analytical journey
• Create structured analytic solutions to solve business problems that are reusable and cross functional
• Develop complex queries against normalized and dimensional models to support business partners
• Identify efficiency opportunities in analytical datasets for more effective BI reporting and utilization
• Utilize problem-solving and analytic skills to rapidly create ad-hoc queries and visualization to answer complex business questions or identify data issues
• Work closely with customers and technology partners to analyze and document data, analytics, and visualization requirements for business analytics solutions 


 

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.
• Experience using BI tools for insight creation and analytic support (e.g., Tableau, PowerBI, COGNOS, Microstrategy, Spotfire)
• Knowledge using other analytics tools (e.g., Microsoft Business Intelligence Suite, R, Python, Spark, H2O)
• 7+ years of relevant experience developing business intelligence, decision support solutions, or creating reporting visualizations
• 5+ years of experience with data analysis or data profiling


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
• Excellent presentation, 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
• Knowledge in a data quality and profiling tools a plus (e.g., Talend, SSIS, Paxata, Ataccama, Alation)
• Prior experience with statistical software or other data mining tools a plus (e.g., SPSS, SAS, ODM, Vertica)
• Expertise with relational databases, querying data warehouses, decision support or ETL tools a plus (e.g., Abintio, Informatica, DataStage, SSRS)
• 2+ years of experience in designing and coding ETL or architecting and implementing data models

 

 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 December 31, 2018, Northern Trust Corporation had:

 

$10.1 trillion in assets under custody/administration
$7.6 trillion in assets under custody
$1.1 trillion in assets under management
$132 billion in banking assets

 

 

 

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 #: 75158

United States, Illinois, Chicago

📁 InformationTechnology

Requisition #: 70216

United States, Illinois, Chicago

📁 InformationTechnology

Requisition #: 75759

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