Senior Analytics Engineer

Mercer Advisors

Where
Remote, USA
Pay
$140K to $165K a year

Posted 13 days ago· Checked live at Mercer Advisors 3 hours ago

Live.Open on the employer's own site.

See how you score for this job

One sentence and your resume. We score it against what Mercer Advisors asks for, line by line.

See my score
Is this job still open?
Yes. We checked it live on Mercer Advisors's own hiring page 3 hours ago.
What is the job?
For more than 40 years, Mercer Advisors has been helping families amplify and simplify their financial lives by integrating financial planning, investment management, business management, tax, estate, insurance, and more, all managed by a single team. We deliver the kind of comprehensive care once reserved for only the wealthiest households. Today, we serve over 42,800+ families across 110+ cities across the U.S.
What does it pay?
$140K to $165K a year, as the posting states.
Our verdict
Live. Open on the employer's own site.

What the job is

For more than 40 years, Mercer Advisors has been helping families amplify and simplify their financial lives by integrating financial planning, investment management, business management, tax, estate, insurance, and more, all managed by a single team. We deliver the kind of comprehensive care once reserved for only the wealthiest households.

Today, we serve over 42,800+ families across 110+ cities across the U.S.

Knowledge, Skills, and Abilities

  • 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, with a track record of delivering production data models used across a business.
  • Advanced SQL skills, including query optimization and dimensional modeling (facts, dimensions, slowly changing dimensions).
  • Hands-on experience with dbt in production, including modular model design, testing, documentation, macros, incremental models, and deployment practices.
  • Experience with Microsoft Fabric (Lakehouse or Warehouse, Data Factory or pipelines, OneLake) 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 governance of shared datasets; familiarity with a metrics or semantic layer approach.
  • Familiarity with AI-enabled analytics tools and what they need from the data layer to give reliable answers, such as governed metrics, clear definitions, and good documentation.
  • Working knowledge of Git, pull request workflows, and CI/CD pipelines (for example Azure DevOps or GitHub Actions).
  • Proficiency in Python for scripting, automation, and data validation.
  • Experience establishing data quality, testing, and observability practices, and a clear point of view on how to scale them.
  • Ability to translate ambiguous business needs into clear technical designs, and to explain tradeoffs to non-technical stakeholders and executives.
  • Strong written and verbal communication, and a collaborative, ownership-minded approach to working with analysts, engineers, and business partners.
  • 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, as is familiarity with CRM, portfolio accounting, or custodial data.

Base Pay Range

$140,250 - $165,000 USD

Benefits

Mercer Advisors offers a competitive and robust benefit package to our employees. Our benefit programs are focused on meeting all of our employees and their eligible dependents health and welfare needs. We offer the following:

  • 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 offerings 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, any supplemental STD, plus Parental Leave (8 weeks) to provide time for recovery, baby bonding, and enjoying your family time.
  • Adoption Assistance Reimbursement Program
  • Company Paid Concierge Services for you and your loved ones for the spectrum of caring needs for your aging parents, young children, life’s challenges and more.
  • 401(k) Retirement Plan with both Traditional and Roth plans with per pay period match as well as an after-tax option
  • Pet Insurance
  • Personalized financial planning and guidance from Mercer Advisors professionals, offered at preferred employee pricing

We are not accepting unsolicited resumes from agencies and/or search firms for this job posting.

Mercer Advisors is an equal opportunity employer and does not discriminate on the basis of any characteristic protected by applicable federal, state, or local law. Mercer Advisors participates in E-Verify and complies with federal employment eligibility verification requirements.

If you need an accommodation during the application or hiring process, please email PeopleTeam@merceradvisors.com. This inbox is for accommodation requests only.

For information about applicant rights, required employment notices, E-Verify participation, and state specific disclosures, please review our Applicant Notices and Employment Rights.

If you are a resident of California, learn more about Mercer's California Consumer Privacy Policy here.

Similar open jobs

Remote data scientist jobs (409)