Senior Analytics Engineer, Data Platform & BI

Mercer Advisors Inc.; United States; On-site; USD 140,000 - 165,000; Full time

Benefits offered by this job

Health insurance

401(k) plan

Paid holidays and PTO

Wellness programs

Job summary

Mercer Advisors seeks a Senior Analytics Engineer to build a modern, trusted data foundation supporting wealth advisors, client service teams, and leadership. You will co-design transformation layers, ensure governance, and ship reliable data products with CI/CD practices.

You bring ownership, mentoring skills, and a strong engineering discipline to analytics, enabling AI-enabled insights and scalable data platforms across the firm.

Qualifications

• Bachelor's degree in computer science, engineering, data science, statistics, information systems, or a related field, or equivalent practical experience.
• Five+ years of experience in analytics engineering, data engineering, or BI development with production data models.
• Advanced SQL skills with optimization and dimensional modeling.
• Hands-on production dbt experience with tests and documentation.
• Experience with Microsoft Fabric or similar cloud data platform (Snowflake/Databricks/BigQuery).
• Strong Power BI experience including semantic modeling, DAX, and governance.
• Familiarity with Git and CI/CD pipelines for analytics.
• Proficiency in Python for scripting, automation, and data validation.
• Experience establishing data quality and observability practices.
• Ability to translate business needs into technical designs and communicate with executives.
• Strong written and verbal communication; collaborative mindset.
• Knowledge of data privacy, security, and governance; regulated data a plus.
• Experience in wealth management or financial services is a plus.

Responsibilities

• Design, build, and maintain dbt models on Microsoft Fabric transforming raw data into clean layers.
• Co-own the Power BI semantic layer with certified models and shared measures.
• Enforce data quality via tests, freshness checks, and data contracts; monitor pipelines.
• Introduce and maintain software engineering practices for analytics (Git workflows, PR reviews, CI/CD).
• Partner with wealth advisors, finance, operations to translate questions into reliable data models and metrics.
• Document models, metrics, and lineage with clear definitions and maintain a datasets catalog.
• Optimize performance and cost with incremental loading and good query design.
• Collaborate with security, compliance, and technology on access controls and privacy.
• Review teammates' work, mentor analysts and engineers, contribute to standards and onboarding.
• Evaluate tooling and lead rollout of approved changes.
• Troubleshoot data issues and communicate status to technical and non-technical audiences.

Skills

Advanced SQL

dbt

Power BI

Python

Git

CI/CD

Data modeling

Communicating with stakeholders

Cloud data platforms

Education

Bachelor's degree in CS/engineering/data science/info systems or related field

Tools

Microsoft Fabric

Snowflake

Databricks

BigQuery

Azure DevOps

GitHub Actions

Job description

Mercer Advisors seeks a Senior Analytics Engineer to build a modern, trusted data foundation supporting wealth advisors, client service teams, and leadership. You will co-design transformation layers, ensure governance, and ship reliable data products with CI/CD practices.

You bring ownership, mentoring skills, and a strong engineering discipline to analytics, enabling AI-enabled insights and scalable data platforms across the firm.