Senior Analytics Engineer

merceradvisors; USA; Remote; USD 130.000 - 190.000; Vollzeit

Benefits dieser Stelle

Medical plans

Dental plans

Vision plans

Health Savings Account

Retirement matching

Paid holidays

Paid parental leave

Disability insurance

Life insurance

Adoption assistance

Dependent-care savings

Employee support

Zusammenfassung

Mercer Advisors is seeking a senior data engineer to build a reliable data foundation for company reporting and self-service analytics in a financial advisory setting. The role combines hands-on data engineering with governance, documentation, and collaboration with business and technology teams.

You will shape raw data into governed, tested datasets and shared metrics while establishing engineering practices and driving cross-functional partnerships across advisory, client service, finance, and

Qualifikationen

• Senior, hands-on role with data engineering focus.

Aufgaben

• Create and maintain dbt transformations on Microsoft Fabric across staging, intermediate, and mart layers.
• Co-own Power BI semantic models, measures, and row-level security to ensure consistent metrics.
• Set data quality standards via tests, freshness checks, contracts, monitoring and alerts.
• Apply Git workflows, PR reviews, CI/CD, and manage separate dev/test/prod environments.
• Translate business questions into reliable data models and metric definitions.
• Document data definitions and lineage; maintain catalog of datasets and owners; optimize performance.
• Collaborate with security, compliance, and technology to manage access controls and auditability; mentor team members.

Jobbeschreibung

Role overview

Build a dependable data foundation for business reporting and self-service analysis in a financial advisory environment. This hands-on senior role shapes how raw data becomes governed, tested, documented datasets and shared metrics, while setting engineering practices and partnering with business and technology teams.

Responsibilities

• Create and maintain dbt transformations on Microsoft Fabric, organizing data into consistent staging, intermediate, and mart layers.
• Co-own Power BI semantic models, shared measures, certifications, and row-level security so metrics are consistent across reports and self-service analysis.
• Set data quality standards through tests, freshness checks, data contracts, monitoring, and alerts.
• Apply software delivery practices such as Git workflows, pull request reviews, automated CI/CD, and separate development, test, and production environments.
• Translate questions from advisory, client service, finance, operations, and technology teams into reliable models and metric definitions.
• Document data definitions and lineage, maintain a catalog of certified datasets and owners, and improve transformation and model performance.
• Work with security, compliance, and technology partners on access controls, privacy, and auditability; review colleagues’ work and mentor team members.

Requirements

The available listing describes this as a senior, hands-on position but does not provide specific years-of-experience, education, or other candidate qualifications.

Benefits and work setup

• Benefits listed include medical, dental, and vision plans; health savings account options; retirement plan with matching; paid holidays and time off; and paid parental leave.
• Additional offerings include disability and life insurance, adoption assistance, dependent-care savings, and employee support services.