Senior Analytics Engineer: Build Trusted Data & BI at Scale

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

Benefits offered by this job

Life insurance

Disability insurance

Health insurance

Vision insurance

401(k) with match

Paid holidays

Job summary

Mercer Advisors is seeking a Senior Analytics Engineer to design and own the data transformation and semantic layers, enabling trusted analytics for wealth advisors and client teams. You will co-create scalable data products, enforce coding standards, and mentor analysts and engineers.

You will work across business and technology stakeholders, author clear data definitions, and help govern datasets for AI-enabled insights while maintaining robust data security and governance practices.

Qualifications

• Bachelor's degree or equivalent practical experience.
• 5+ years in analytics engineering or BI development with production data models.
• Advanced SQL and dimensional modeling.
• Hands-on dbt in production with testing and documentation.
• Experience with cloud platforms like Fabric, Snowflake, Databricks or BigQuery.
• Power BI semantic modeling and governance of datasets.
• Familiarity with AI-enabled analytics requirements and data governance.
• Git-based workflows and CI/CD for data projects.

Responsibilities

• Design, build, and maintain dbt models transforming raw data into clean data layers.
• Co-own the Power BI semantic layer and reusable metrics.
• Establish data quality standards with tests, freshness checks, and data contracts.
• Implement software engineering practices for analytics including CI/CD and environments.
• Collaborate with wealth advisors, client service, finance, and IT to translate questions into data models.
• Document models, metrics, and lineage with clear definitions and owners.
• Optimize performance and cost of transformations and semantic models.
• Ensure access controls, privacy, and auditability in line with policies.

Skills

Advanced SQL

dbt in production

Power BI

Python

Git & CI/CD

Data modeling

Strong communication

Wealth management knowledge

Education

Bachelor's degree in CS/Engineering/Data Science or related

Tools

dbt

Microsoft Fabric

Power BI

Git

Azure DevOps / GitHub Actions

Python

Job description

Mercer Advisors is seeking a Senior Analytics Engineer to design and own the data transformation and semantic layers, enabling trusted analytics for wealth advisors and client teams. You will co-create scalable data products, enforce coding standards, and mentor analysts and engineers.

You will work across business and technology stakeholders, author clear data definitions, and help govern datasets for AI-enabled insights while maintaining robust data security and governance practices.