Hybrid Analytics Engineer: Data Products & Semantic Models

Focus Financial Partners; Missouri; Hybrid; USD 90,000 - 110,000; Full time

Job summary

Focus Financial Partners seeks an Analytics Engineer to own MART-layer data products and the governance, testing, and metadata that enable enterprise analytics and AI consumption.

You will collaborate with data engineers, BI engineers, analysts, and business stakeholders to translate requirements into scalable data solutions, with a hybrid work pattern requiring 3 days onsite per week in St. Louis.

Qualifications

• Bachelor's degree in a related field or equivalent practical experience.
• 5+ years in analytics engineering, data engineering, BI engineering, or related data role.
• Experience building governed data models and data products in enterprise environments.
• Experience applying software engineering best practices to analytics workflows (Git, testing, deployment).
• Experience with BI/semantic technologies such as Power BI or Snowflake semantic capabilities is preferred.

Responsibilities

• Own the design, development, and maintenance of MART-layer data products.
• Translate business requirements into reusable data products, metrics, and transformation logic.
• Build semantic models with metadata, definitions, and synonyms for trusted analytics.
• Support multiple consumption patterns: dashboards, AI, APIs, file delivery, integrations.
• Apply governance and version control to data transformations and logic.
• Collaborate with data engineers, BI engineers, analysts, architects, and stakeholders to define product intent.
• Ensure data product quality through testing, monitoring, and reconciliation.
• Document data products, lineage, and usage guidance.

Skills

Snowflake

DBT

Semantic models

SQL

Data governance

Stakeholder partnership

Communication

Education

Bachelor’s degree

Tools

Power BI

Metadata/catalog platforms

Job description

Focus Financial Partners seeks an Analytics Engineer to own MART-layer data products and the governance, testing, and metadata that enable enterprise analytics and AI consumption.

You will collaborate with data engineers, BI engineers, analysts, and business stakeholders to translate requirements into scalable data solutions, with a hybrid work pattern requiring 3 days onsite per week in St. Louis.