Job description
Summary
The responsibilities will consist mainly of collaborating with the business to help define and implement analytic solutions based on their business strategy. This role will work with business unit specialists, the IT team, and other data analysts throughout the organization to extract the required data, to create the analytic models and to perform the analysis once the data is accumulated, then present findings and recommendations to the business. The role will work across business units in a team environment with minimal supervision.
Major Duties
- Full life cycle activities of data analytics to include requirements and design, data cleaning, developing analysis and reporting capabilities, linking databases and data sets.
- 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.
- Analyze and understand Northern Trust’s core business processes and data flows to design and develop enduring solutions that provide analytical insights (both rearview, and predictive).
- Assist with applying and developing statistical models/methods to address business issues.
- Develop metrics and create ad-hoc reporting as needed.
- Ensure issues are identified, tracked, reported on and resolved in a timely manner.
- Foster a positive and collaborative environment.
- Participate in special projects as needed and perform other duties, as assigned.
Knowledge/Skills
Technical Experience:
- Highly proficient with MS SQL Server (adept in stored procedures, views, TVFs, schemas, star models)
- Highly proficient as an architect of data analytical tools and visualization software (e.g. PowerBI, DAX, SSRS, Tableau, Plotly)
- Experience in Azure (Databricks, DevOps) and Power Platform
- Strong working knowledge of Python and Python libraries (e.g. Pandas, NumPy, Dash) or similar object-oriented programming language
- JIRA experience preferred
- Advanced skills in Access and Excel (VBA classing and modules)
General:
- Database systems competence is expected. Familiarity with relational database concepts, querying, data warehouses, and/or decision support tools
- Strong data and analytical skills with ability to manipulate large amounts of data for analytical projects and translate that data into sound insights
- Proficiency in navigating computer systems; ability to learn new data systems quickly and to comply with data integrity and security to safeguard all personal identifiable information
- Strong project management skills with familiarity of Agile and/or Waterfall methodologies
- Excellent oral and written communication skills are required with ability to be efficient and consistently deliver high-quality work under time constraints
- Highly motivated and organized with the ability to work well in teams (both interchangeably in leading and supportive roles) and independently on multiple simultaneous projects
- Highly flexible and adaptable to change
Education Required
Bachelor’s Degree in Mathematics, Economics, Computer Science, Information Technology, Statistics, Finance or a related field and/or equivalent work experience required.
