Senior Consultant – Data Analyst


Olmstead drives business success by helping clients build and leverage a strong data foundation. The right data strategy can reduce risk, increase productivity, improve decision making, and fuel innovation.

We are seeking a hands-on detail-oriented data analyst with investment management industry experience. Candidates will have experience with SQL, data modeling, data governance, and business intelligence reporting. They are not afraid to roll up their sleeves, challenge the status quo, leverage best practices, and grow beyond their comfort zone. They are an excellent communicator that uses precise language and frames messaging in business terms.

As a valued member of our expert data management consulting team, you will engage clients to document and analyze their data landscape. Analysis will help the client grow, develop new capabilities, and optimize data management. You will deliver a wide range of data-oriented engagements, such as Master Data Management solutions, data governance, data migrations, data warehousing, and client reporting.


As a key member of the Olmstead Data Management team you will work closely with other Olmstead team members. The primary objective is to elevate the client’s capabilities in the areas of data analysis, modeling, metadata management and data integration by applying Olmstead’s tools and approach to execute the following types of consulting activities:

  • Aid current state assessments by collecting information on data sources, data flows, information consumption, and information production 
  • Proactively analyze data to answer key questions from stakeholders or out of self-initiated curiosity with an eye for what drives business performance, investigating and communicating areas for improvement in efficiency and productivity 
  • Produce project deliverables that itemize and summarize to aid comprehension and decision making 
  • Collaborate with team members and client stakeholders to understand analytic needs and deliver actionable insights 
  • Produce reports and data mashups to answer business related questions 
  • Trace data requirements, data sources, and data flows for reports and processes 


  • Possess strong business knowledge of the investment management industry and common data management operations 
  • Data modeling expertise for investment data domains, such as security master, accounts, holdings, transactions, etc. 
  • Strong hands-on SQL and Excel skills with the ability to learn other analytic tools 
  • Experience creating Business Intelligence reports using a leading BI tool 
  • Familiarity with data management conventions and best practices 
  • Knowledge of Data Governance roles and practices and agile methodologies 
  • Bachelor’s degree required; MBA preferred 

If you are interested in joining Olmstead, please send an email to [email protected]