Senior Analytics Engineer

Talenthop; United States; On-site; USD 120,000 - 190,000; Full time

Job summary

Talenthop is seeking a Senior Analytics Engineer to build a reliable data infrastructure supporting wealth advisors, client service teams, and leadership. You will transform raw data into accurate datasets and metrics, applying software engineering best practices to analytics work and mentoring teammates.

In this role you will design data transformation models with dbt on Microsoft Fabric, manage Power BI semantics, ensure data quality, and collaborate with stakeholders to deliver trusted

Qualifications

• Bachelor's degree or equivalent experience.
• 5+ years in analytics engineering, data engineering, or business intelligence with production experience.
• Advanced SQL and dimensional data modeling.
• Hands-on dbt experience with modular design, testing, and deployment.
• Experience with Microsoft Fabric or a comparable cloud data platform.
• Proficient in Power BI semantic modeling, DAX, row-level security, and dataset governance.
• Familiarity with AI-enabled analytics tools' data requirements.
• Working knowledge of Git workflows and CI/CD pipelines.

Responsibilities

• Design, build, and maintain data transformation models using dbt on Microsoft Fabric.
• Manage the Power BI semantic layer ensuring consistent metric definitions across platforms.
• Implement and uphold data quality standards through testing and monitoring.
• Apply software engineering practices including version control, code review, and CI/CD for analytics deployments.
• Collaborate with stakeholders to translate business needs into reliable data models and retire redundant reports.
• Document data models, metrics, and lineage with clear business definitions and maintain a catalog of certified datasets.
• Optimize data processing performance and cost.
• Enforce data access controls and compliance with security policies.
• Review and mentor team members on best practices.
• Recommend and lead improvements in tooling, architecture, and workflows.
• Troubleshoot data issues and communicate findings clearly.

Skills

SQL

Dimensional modeling

Power BI modeling

DAX

Row-level security

Dataset governance

AI analytics data requirements

Git workflows

CI/CD pipelines

dbt

Microsoft Fabric

Education

Bachelor's degree or equivalent experience

Tools

dbt

Microsoft Fabric

Power BI

Job description

The organization operates in the financial advisory industry, assisting families in managing their financial lives through integrated services including financial planning, investment management, business management, tax, estate, and insurance. It addresses the complexity faced by clients by providing comprehensive care typically accessible to high-net-worth households. The organization serves over 42,800 families across more than 110 U.S. cities and has been recognized nationally for its independent fiduciary approach.

About the Opportunity:

The SENIOR ANALYTICS ENGINEER role is pivotal in establishing a reliable and modern data infrastructure that supports wealth advisors, client service teams, and leadership in making informed decisions. This position is responsible for transforming raw data into accurate, well-documented datasets and metrics, facilitating both served and self-serve analytics. The role emphasizes applying software engineering best practices to analytics work, mentoring team members, and collaborating with various stakeholders to enhance data quality and usability.

Responsibilities:

• Design, build, and maintain data transformation models using dbt on Microsoft Fabric.
• Manage the Power BI semantic layer ensuring consistent metric definitions across platforms.
• Implement and uphold data quality standards through testing and monitoring.
• Apply software engineering practices including version control, code review, and continuous integration for analytics deployments.
• Collaborate with stakeholders to translate business needs into reliable data models and retire redundant reports.
• Document data models, metrics, and lineage with clear business definitions and maintain a catalog of certified datasets.
• Optimize data processing performance and cost.
• Enforce data access controls and compliance with security policies.
• Review and mentor team members on best practices.
• Recommend and lead improvements in tooling, architecture, and workflows.
• Troubleshoot data issues and communicate findings clearly.

Requirements:

• Bachelor's degree in a relevant field or equivalent experience.
• Minimum five years in analytics engineering, data engineering, or business intelligence with proven production experience.
• Advanced skills in SQL and dimensional data modeling.
• Hands-on experience with dbt, including modular design, testing, and deployment.
• Experience with Microsoft Fabric or a comparable cloud data platform.
• Proficient in Power BI semantic modeling, DAX, row-level security, and dataset governance.
• Familiarity with AI-enabled analytics tools' data requirements.
• Working knowledge of Git workflows and CI/CD pipelines.

Pay Range and Compensation Package:

• The pay range and compensation package for this role will be determined based on the candidate's experience, skills, and other relevant factors.

Equal Opportunity Statement:

Our client is an equal opportunity employer. They celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, or national origin.