Sql data analyst Jobs in Etobicoke, ON

Description:

We are seeking a talented individual to join our Data Solutions team at Mercer. This role will be based in Boston, Toronto, or the U.K. This is a hybrid role that has a requirement of working at least three days a week in the office.

The Data Solutions Team partners with the business teams to ensure that their data is available, accurate and fit for purpose. The Senior Alternatives Data Analyst will collaborate with the Private Markets and Hedge Fund teams to manage the data that is critical to the investment process.

We will count on you to:

• Partner closely with the Private Markets and Hedge Fund Investment teams on data management and strategyDevelop knowledge of Investment Team workflows and critical data needs to understand and deliver their specific capabilities and requirements, working closely with platform providers and data and technology teams to implement tailored, fit-for-purpose solutions.Support the development and execution of investment data strategies by rolling out new platforms and solutions that adhere to data governance, management, and quality principles, ensuring they meet evolving needs.Support the delivery of alternatives data platforms and capabilities, working with data, technology, and platform providers to implement scalable solutions aligned to Mercer’s broader data strategy.
• Deliver Operational Transformation & Effectiveness
• Contribute to the execution of the alternatives data roadmap, helping sequence and deliver initiatives that improve data quality, availability, and usability while balancing near‑term value with long‑term capability building.
• Drive operational transformation and efficiency by identifying opportunities to streamline data processes, reduce manual effort, and improve consistency across private markets and hedge fund workflows.
• Apply strong data governance and quality principles, ensuring alternatives data is accurate, timely, well‑controlled, and fit for investment decision‑making and downstream analytics.
• Perform root‑cause analysis on complex data issues, coordinating across investment teams, operations, technology partners, and third‑party vendors to resolve issues and prevent recurrence.
• Elicit, document, and refine business and data requirements, serving as a bridge between investment teams and technology partners throughout delivery. Partner with technology teams during design and implementation to validate requirements, support testing, and ensure delivered solutions meet business intent.
• Support and enable alternatives analytics use cases, including portfolio analytics, exposure analysis, performance, and risk, ensuring data foundations meet analytical and reporting needs.
• Manage day‑to‑day interactions with external data vendors and platform providers, monitoring data delivery, quality, and service levels, and escalating issues as appropriate.
• Collaborate and Promote Best PracticesFoster strong partnerships and collaboration with business, data, and technology partners to ensure comprehensive understanding of data needs and capabilities within the Investment Teams.Act as an ambassador for a data-driven culture, promoting the importance of data in decision-making, risk management and operational efficiency.Collaborate with business and technology colleagues to identify opportunities for data and workflow innovation that advance the data strategy and position Mercer as a leader in the investment space.Define and track measurable outcomes for data initiatives, contributing to metrics and dashboards that demonstrate progress, data quality improvements, and business impact.

What you need to have:

• 7+ years of experience in Asset Management, with direct exposure to Private Markets and/or Hedge Fund investment teams and their end‑to‑end data workflows.
• Strong understanding of alternatives investment data across the investment lifecycle, including fund structures, exposures, performance, risk, and reporting challenges unique to private assets.
• Hands‑on experience working within complex investment data ecosystems, including portfolio analytics, performance, risk, and exposure data used by investment and client teams.
• Strong communication skills, with the ability to tailor messaging to technical and non‑technical stakeholders and clearly articulate business outcomes.
• Demonstrated ability to translate business requirements into fit‑for‑purpose data solutions, balancing speed, quality, and scalability.
• Experience performing root‑cause analysis of data quality and operational issues, partnering across investment, operations, technology, and third‑party providers.
• Ability to operate effectively under pressure in a fast‑paced alternatives environment, with a results‑oriented and problem‑solving mindset.
• Results-oriented approach with a demonstrated ability to sympathize with the operational challenges of our investors and drive change.
• Enthusiasm for solving problems through data, technology and connecting the dots.

What makes you stand out:

• Proven track record of partnering closely with Private Markets and Hedge Fund investment teams to deliver impactful, data‑driven solutions.
• Experience contributing to data transformation initiatives, including the rollout or enhancement of alternatives data platforms, tools, or operating models.
• Strong judgment in triaging data issues, coordinating across internal stakeholders and external vendors, and managing communication and escalation appropriately.
• Working knowledge of alternatives data platforms and vendors such as iLevel, Vidrio, S&P EDM, Diligence Vault, Dasetti, or similar tools supporting private assets.
• Ability to connect data, technology, and investment objectives, enabling better decision‑making, risk management, and client outcomes.
• Professional certifications such as CFA or CAIA, or demonstrated progress toward them.

Mercer is a business of Marsh (NYSE: MRSH), a global leader in risk, reinsurance and capital, people and investments, and management consulting, advising clients in 130 countries. With annual revenue of over $27 billion and more than 95,000 colleagues, Marsh helps build the confidence to thrive through the power of perspective. For more information about Mercer, visit mercer.com, or follow us on LinkedIn and X.Marsh is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age background, disability, ethnic origin, family duties, gender orientation or expression, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, veteran status (including protected veterans), or any other characteristic protected by applicable law. If you have a need that requires accommodation, please let us know by contacting Marsh is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one “anchor day” per week on which their full team will be together in person.The applicable base salary range for this role is $68 400 to $136 800.The base pay offered will be determined on factors such as experience, skills, training, location, certifications, education, and any applicable minimum wage requirements. Decisions will be determined on a case-by-case basis. In addition to the base salary, this position may be eligible for performance-based incentives.We are excited to offer a competitive total rewards package which includes health and welfare benefits, tuition assistance, 401K savings and other retirement programs as well as employee assistance programs.