Senior Data Analyst

Focus Partners Wealth•St. Louis, MO

1d•$110,000 - $130,000•Hybrid

About The Position

We are seeking an experienced Senior Data Analyst to join our Data & AI Team at Focus Financial Partners. In this role, you will take full ownership of executing on our most valuable, and at times most difficult, cross-cutting analytical needs, leading projects from inception through delivery and ongoing roadmap, going deep into our data domains, with particular depth in Employee and Corporate Finance data, and coordinating across organizational boundaries to deliver data solutions our business relies on. Our work starts with the needs of the business. You will partner closely with business leaders and stakeholders, owning timelines, requirements, and accountability for delivery of new domains and data products, then partner with our Data Team and source system owners to drive the full data product development lifecycle to fruition: from raw data analysis, to curation into our unified data model, through oversight and delivery of business-facing data products.

Requirements

Bachelor's degree in Business Analytics, Economics, Computer Science, Information Systems, or a related field, or equivalent hands-on experience. Formal degree requirements are secondary to a demonstrated track record of operating at a high level in the data and analytics / product management space.
6-8+ years of experience in analytics, business intelligence, data analysis, or a related discipline, preferably in a Financial Services context. Wealth Management background is a plus.
Advanced SQL proficiency.
Experience with Power BI or a similar BI platform.
Strong written and verbal communication skills, translating fluently between technical detail and business language.
Demonstrated ability to partner with senior business stakeholders and develop trusted relationships.
Experience gathering business requirements and logic, translating needs into technical solutions.
Strong analytical thinking and problem-solving abilities and demonstrated ability break down uses cases into smaller components and prioritize execution sequencing with stakeholders in an agile manner.
Comfortable operating in ambiguity, at times autonomously, on tight timelines without losing rigor.
High personal agency and situational awareness, anticipates what's next and takes initiative to keep work moving forward.
Familiarity with, or capacity to quickly adopt, AI-assisted tools to accelerate data work and improve analytical productivity.

Nice To Haves

Wealth Management background is a plus.

Responsibilities

Lead upfront analysis of newly onboarded source systems and stay abreast of upstream changes in source that impact our data model and analytics. For this role specifically, there will be an early emphasis on Workday Finance and Human Capital data, which will have deep interconnectivity with our core data model.
Partner closely with the data modeling team to determine how new sources of data layer into our unified model, informed by analysis and stakeholder discussions, determining the logic and relationships needed to fit business use cases. At times, this includes proposing your own model design and driving alignment with modelers, engineers, and stakeholders to accelerate the development cycle.
Own translation of raw data into the Curated model, including source-to-target mapping, transformation and derivation logic, null handling, and edge cases.
Author clear definitions, expectations, and known limitations for the data you curate; become the subject matter expert and go-to counterpart to stakeholders for the domains and data products you touch.
Serve as the authoritative source of Sprint / Backlog priorities and sequencing, insofar as they relate to projects that you own, and facilitate handoff of analyst documentation to developers, ensuring well-documented, on-time delivery.
Partner with business stakeholders and technical SMEs to understand their use cases, the data necessary to deliver said use cases, and quickly pivot into requirements, modeling, and development work.
Prove out proposed solutions using code and data visualization before handoff for production build.
Own ongoing enhancements and roadmap, with stakeholder buy in, for domains and projects that you own the delivery of to meet existing and evolving business needs.
Serve as a line of defense on live data, validating outputs and investigating anomalies so the business can trust what's being consumed.
Field ad hoc stakeholder requests as they arise, from debugging unexpected results to one-off reporting needs.
Stay across the details of stakeholder needs and anticipate priority, dependencies, and ‘how to’ of pending use cases.