Senior Analytics Engineer — dbt, Power BI & Data Quality

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

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