Senior Analytics Engineer

Job not on LinkedIn

🔥 0 minutes ago

🇺🇸 United States – Remote

💵 $140.3k - $165k / year

⏰ Full Time

🟠 Senior

📊 Analytics Engineer

👻 Ghost score 0%

What it means: the chance that no one is really hiring for this job.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Mercer Advisors

WebsiteLinkedInAll Job Openings

501 - 1000 employees

Founded 1985

🛡️ Insurance

💼 Consulting

💳 Fintech

Insurance • Consulting • Fintech

Mercer Advisors is a comprehensive financial advisory firm that focuses on simplifying and amplifying clients' financial lives. They offer a family office-style service, providing a unified team of financial planners, investors, accountants, and estate specialists who tailor financial plans to individual needs. With over 40 years of experience, the firm emphasizes personalized, fiduciary-focused service without compromising on institutional-grade portfolio management, making it accessible for families and individuals seeking to enhance their financial future.

📋 Description

• 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

• 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

• 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

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume