Senior Analytics Engineer (Fully Remote)

Mercer Advisors; United States; Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Competitive benefits package

Job summary

Mercer Advisors is seeking a hands-on senior analytics engineer to build a modern data foundation for wealth advisors, client service teams, and firm leaders. You will co-design and own transformation and semantic layers, applying software engineering discipline to analytics.

You will design and maintain dbt models on Microsoft Fabric, 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

Qualifications

• Hands-on senior analytics engineer role.
• Experience building and maintaining analytics models and semantic layers.
• Experience with data quality standards and data governance.

Responsibilities

• Design and maintain dbt models on Microsoft Fabric.
• Co-own the Power BI semantic layer with shared metrics and row-level security.
• Establish data quality standards and Git-based CI/CD workflows.
• Mentor analysts and partner with business and technology stakeholders.

Skills

dbt models

Power BI

CI/CD

data governance

mentoring

Tools

Git

Microsoft Fabric

Job description

• 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 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.