Analytics Engineer

Position Summary

The Analytics Engineer is responsible for owning the design build and ongoing maintenance of data products in the MART layer of the firms data platform. This role creates and evolves foundational and business data products from governed underlying data applying reusable business logic documentation testing and access controls so data can be consumed consistently across the enterprise. The ideal candidate also authors and maintains semantic models that make trusted data easier to use for AI experiences dashboards reporting and downstream integrations into operational platforms. Success in this role requires strong technical depth a product mindset and close partnership with engineering BI analytics and business stakeholders.

This is a hybrid role with 3 days/week onsite in St. Louis.

Primary Responsibilities

• Own the design development and maintenance of MART-layer foundational and business data products built from curated enterprise data.

• Translate business requirements into reusable data products metrics and transformation logic that support consistent consumption across teams and platforms.

• Build and maintain semantic models with rich metadata business definitions and synonyms to enable trusted self-service analytics and AI consumption.

• Develop models that support multiple consumption patterns including dashboards reports AI agents APIs file delivery and operational system integrations.

• Apply complex business logic in a governed version-controlled manner using modern transformation tooling and software engineering best practices.

• Partner with data engineers BI engineers analysts architects and business stakeholders to define product intent validate logic and prioritize enhancements.

• Ensure data product quality through testing monitoring reconciliation and issue resolution across upstream data transformations and downstream consumption.

• Document data products semantic models lineage and usage guidance to improve transparency stewardship and user adoption.

• Support governed access patterns through metadata role-based access considerations and alignment with enterprise data governance standards.

• Continuously improve MART-layer patterns semantic model design and consumer enablement based on platform evolution and business needs.

Required Skills

• Strong experience building analytics-ready data models and reusable business logic in modern cloud data platforms such as Snowflake.

• Hands-on expertise with DBT or similar transformation frameworks including modular modeling testing documentation and version control.

• Proven ability to design and maintain semantic models metrics dimensions and business definitions for consistent downstream consumption.

• Strong SQL skills and experience optimizing transformation logic for performance scalability and maintainability.

• Experience supporting multiple data consumption patterns including BI dashboards AI use cases reporting APIs file delivery and operational integrations.

• Understanding of data governance metadata lineage role-based access and quality controls in enterprise data platforms.

• Ability to partner effectively with cross-functional stakeholders to translate business needs into scalable trusted data products.

• Strong written and verbal communication skills with the ability to document logic definitions assumptions and usage guidance clearly.

Qualifications

• Bachelors degree in Computer Science Information Systems Data Analytics Engineering or a related field or equivalent practical experience.

• 5 years of experience in analytics engineering data engineering BI engineering or a closely related data role.

• Experience building governed data models and data products in enterprise environments with multiple downstream consumers.

• Demonstrated experience applying software engineering best practices to analytics workflows including Git-based development testing and deployment discipline.

• Experience working with modern BI and semantic technologies such as Power BI Snowflake semantic capabilities or similar platforms is preferred.

• Familiarity with metadata/catalog platforms lineage tooling and enterprise documentation practices is preferred.

• Experience in financial services wealth management or other regulated industries is a plus.

• Demonstrated ability to work independently manage priorities and take ownership of data products from design through ongoing support.

This position is an exempt position. The annualized base pay range for this role is expected to be between $90000 - $110000. Actual base pay could vary based on factors including but not limited to experience subject matter expertise geographic location where work will be performed and the applicants skill set. The base pay is just one component of the total compensation package for employees. Other reward may include an annual cash bonus and a comprehensive benefits package.

#LI-KJ2

About Focus Financial Partners

Focus is a leading financial services firm comprised of integrated wealth management family office and business management services. Blending deep expertise and expansive resources with a boutique client-first fiduciary philosophy Focus helps individuals families and institutions navigate complex financial situations with highly personalized solutions tailored to their unique needs. To learn more about Focus visit follow the company onLinkedIn.

Focus is an equal opportunity employer and bases its employment decisions on the employee or candidates skillset and without regard to an employee or candidates race color religion sex (including pregnancy) gender identity sexual orientation national origin age disability genetic information veteran status or any other characteristic protected by local state and/or federal law.

Focus complies with federal and state disability laws and makes reasonable accommodations for applicants and employees with disabilities. If reasonable accommodation is needed to participate in the job application or interview process to perform essential job functions and/or to receive other benefits and privileges of employment please contact .

The following language is for US based roles only

For California Applicants:Information on your California privacy rights can be found here

For Indiana Applicants: It is unlawful for an employer to discriminate against a prospective employee on the basis of status as a veteran by refusing to employ an applicant on the basis that they are a veteran of the armed forces of the United States a member of the Indiana National Guard or a member of a reserve component.

For Maryland Applicants: I UNDERSTAND THAT UNDER MARYLAND LAW AN EMPLOYER MAY NOT REQUIRE OR DEMAND AS A CONDITION OF EMPLOYMENT PROSPECTIVE EMPLOYMENT OR CONTINUED EMPLOYMENT THAT ANY INDIVIDUAL SUBMIT TO OR TAKE A POLYGRAP OR SIMILAR TEST. AN EMPLOYER WHO VIOLATES THIS LAW IS GUILTY OF A MISDEMEANOR AND SUBJECT TO A FINE NOT EXCEEDING $100.

For Massachusetts Applicants: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this shall be subject to criminal penalties and civil liability.

For Montana Applicants: If hired the employment relationship is governed by the Wrongful Discharge from Employment Act. Mont. Code Ann. Section.

For Rhode Island Applicants: Focus is subject to Chapters 29-38 of Title 28 of the General Laws of Rhode Island and is therefore covered by the states workers compensation law. If you willfully provide false information about your ability to perform the essential functions of the job with or without reasonable accommodations you may be barred from filing a claim under the provisions of the Workers Compensation Act of the State of Rhode Island if the false information is directly related to the personal injury that is the basis for the new claim for compensation. The Company complies fully with the Americans with Disabilities Act.