This hands-on senior role builds a modern, trusted data foundation for wealth advisors, client service teams, and firm leaders.
You will co-design and own transformation and semantic layers, bringing software engineering discipline to analytics.

Key Responsibilities:

Design and maintain dbt models on Microsoft Fabric, and co-own the Power BI semantic layer with shared metrics and row-level security.
Establish data quality standards, implement Git-based workflows and CI/CD, and mentor analysts while partnering with business and technology stakeholders.

Why Join:

Mercer Advisors offers a collaborative, flexible work environment with a competitive benefits package.
You will influence data architecture and practices in a firm recognized as #1 RIA in the nation for two consecutive years.

Mercer Advisors

Mercer Advisors is a financial advisory firm that helps families amplify and simplify their financial lives by integrating financial planning, investment management, tax, estate, insurance, and more. With over 42,800+ families served across 110+ U.S. cities and ranked #1 RIA by Barron's, it offers a flexible, national workplace where more than half of employees and client-facing professionals are women.

Apply for This Position