Senior Analytics Engineer

Mercer Advisors

. Design, build, and maintain dbt models on Microsoft Fabric across staging, intermediate, and mart layers .

Posted 11/5/2026full-timeRemote • United StatesSenior💰 $140,250 - $165,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in analytics engineering and data modeling, with a strong focus on dbt and Power BI. Proficient in SQL, Python, and data quality practices, while effectively collaborating with cross-functional teams to translate business needs into actionable data solutions.

Highest-signal resume keywords

Advanced SQL SkillsHands-On Production Experience With dbtStrong Power BI ExperienceProficiency In PythonExperience Establishing Data Quality Practices

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Analytics EngineeringData EngineeringBusiness Intelligence DevelopmentDimensional ModelingQuery OptimizationModular Model DesignTestingDocumentationIncremental ModelsData Validation

Soft Skills

Strong Written CommunicationStrong Verbal CommunicationCollaborative ApproachOwnership-Minded Approach

Tools & Technologies

Microsoft FabricPower BIGitCI/CD PipelinesAI-Enabled Analytics Tools

Industry Keywords

Data PrivacyData SecurityGovernance PrinciplesWealth ManagementFinancial ServicesRegulated Industry

Tech Stack

Tools & technologies

BigQueryCloudPythonSnowflakeSQL

About the role

Key responsibilities & impact

Design, build, and maintain dbt models on Microsoft Fabric across staging, intermediate, and mart layers
Co-own the Power BI semantic layer, including certified semantic models, shared measures, and row-level security
Establish data quality standards with dbt tests, source freshness checks, data contracts, monitoring, and alerting
Maintain Git workflows, pull request reviews, automated CI/CD for dbt and Fabric deployments, and separate development, test, and production environments
Partner with wealth advisors, client service, finance, operations, and technology teams to translate business questions into reliable data models and metric definitions
Document models, metrics, lineage, business definitions, and certified dataset ownership
Optimize transformation and semantic-model performance and cost through incremental loading, partitioning, and query design
Apply access controls, privacy protections, and auditability to client and firm data with Information Security, Compliance, and Technology teams
Review team members’ work and mentor analysts and engineers
Contribute to team standards, templates, and onboarding materials
Evaluate and recommend tooling, architecture, and workflow improvements and lead approved rollouts
Troubleshoot data issues, perform root cause analysis, and communicate impact and status to technical and non-technical audiences
Report to the VP, Client Data & Analytics

Requirements

What you’ll need

Bachelor's degree in computer science, engineering, data science, statistics, information systems, or a related field, or equivalent practical experience
Five or more years of experience in analytics engineering, data engineering, or business intelligence development
Advanced SQL skills, including query optimization and dimensional modeling
Hands-on production experience with dbt, including modular model design, testing, documentation, macros, incremental models, and deployment practices
Experience with Microsoft Fabric or a comparable cloud data platform such as Snowflake, Databricks, or BigQuery
Strong Power BI experience, including semantic model design, DAX, row-level security, and shared dataset governance
Familiarity with AI-enabled analytics tools and governed data requirements
Working knowledge of Git, pull request workflows, and CI/CD pipelines
Proficiency in Python for scripting, automation, and data validation
Experience establishing data quality, testing, and observability practices
Ability to translate ambiguous business needs into technical designs and explain tradeoffs to non-technical stakeholders and executives
Strong written and verbal communication and collaborative, ownership-minded approach
Understanding of data privacy, security, and governance principles
Experience with sensitive or regulated data is preferred
Experience in wealth management, financial services, or another regulated industry is a plus
Familiarity with CRM, portfolio accounting, or custodial data is a plus
Availability Monday through Friday, 8:00 AM–5:00 PM

Benefits

Comp & perks

Company Paid Basic Life & AD&D Insurance
Company Paid Short-Term and Long-Term Disability Insurance
Supplemental Life & AD&D; Short-Term Disability; Accident; Critical Illness; and Hospital Indemnity Insurance
Three Cigna medical plans, including two High Deductible Health Plans and a Traditional Co-Pay medical plan
Kaiser Medical plans available in California
Health Savings Account (HSA) with company contributions if enrolled in either HDHP medical plan
Two comprehensive Dental Plans
Vision Insurance Plan
Dependent Care Savings Account for child and dependent care
14 Company Paid Holidays including a full week off at Thanksgiving
Generous paid time off program for vacation and sick days
Employee Assistance Plan
Family Medical Leave
Paid Parental Leave (8 weeks)
Maternity benefits utilizing company paid STD, supplemental STD, and Parental Leave
Adoption Assistance Reimbursement Program
Company Paid Concierge Services
401(k) Retirement Plan with Traditional and Roth plans, per-pay-period match, and after-tax option
Pet Insurance
Personalized financial planning and guidance from Mercer Advisors professionals at preferred employee pricing
Eligible to earn incentive compensation through one of Mercer Advisors’ incentive compensation programs