Senior Analytics Engineer

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, develop, and manage dbt models on Microsoft Fabric, covering staging, intermediate, and mart layers.

• Co-manage the Power BI semantic layer, which includes certified semantic models, shared measures, and row-level security.

• Set data quality standards through dbt tests, source freshness evaluations, data contracts, monitoring, and alerts.

• Oversee Git workflows, conduct pull request reviews, and implement automated CI/CD for dbt and Fabric deployments, maintaining distinct development, testing, and production environments.

• Collaborate with wealth advisors, client services, finance, operations, and technology teams to convert business inquiries into dependable data models and metric definitions.

• Document models, metrics, data lineage, business definitions, and certified dataset ownership.

• Enhance transformation and semantic-model performance and cost-efficiency through incremental loading, partitioning, and effective query design.

• Implement access controls, privacy safeguards, and audit capabilities for client and firm data alongside Information Security, Compliance, and Technology teams.

• Review the work of team members and provide mentorship to analysts and engineers.

• Contribute to the development of team standards, templates, and onboarding resources.

• Assess and suggest enhancements in tooling, architecture, and workflows, leading approved implementations.

• Diagnose data issues, conduct root cause analyses, and relay impacts and updates to both technical and non-technical stakeholders.

• Report directly to the VP of Client Data & Analytics.

⛳️ Requirements

• Bachelor's degree in computer science, engineering, data science, statistics, information systems, or a related field, or equivalent practical experience.

• A minimum of five years of experience in analytics engineering, data engineering, or business intelligence development.

• Proficient in advanced SQL, including query optimization and dimensional modeling.

• Hands-on experience with dbt, including modular model design, testing, documentation, macros, incremental models, and deployment practices.

• Familiarity with Microsoft Fabric or similar cloud data platforms such as Snowflake, Databricks, or BigQuery.

• Strong expertise in Power BI, encompassing semantic model design, DAX, row-level security, and shared dataset governance.

• Knowledge of AI-enabled analytics tools and regulated data requirements.

• Working knowledge of Git, pull request processes, and CI/CD pipelines.

• Proficient in Python for scripting, automation, and data validation tasks.

• Experience in implementing data quality, testing, and observability practices.

• Capability to convert ambiguous business requirements into technical designs and articulate trade-offs to non-technical stakeholders and executives.

• Excellent written and verbal communication skills with a collaborative and ownership-oriented mindset.

• Understanding of data privacy, security, and governance principles.

• Experience with sensitive or regulated data is preferred.

• Background in wealth management, financial services, or another regulated industry is advantageous.

• Familiarity with CRM, portfolio accounting, or custodial data is a plus.

• Availability from Monday to Friday, 8:00 AM to 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 leave.

• 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 options, per-pay-period matching, and after-tax contributions.

• 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.