This role provides data analysis and data discovery support for the Focus Data Team, partnering closely with data modelers, engineers, and business stakeholders. The primary responsibility is upfront analysis of source systems, articulation of data concepts and relationships, and ownership of source-to-target mapping (Raw to Curate / Bronze to Silver) and baseline documentation that enables high‑quality, scalable data modeling and downstream data products.
This role is intentionally non-engineering focused, with accountability centered on clarity, documentation, stakeholder alignment, and readiness for development.
Job Details:
· Upfront Analysis
o Conduct upfront analysis of source system data sets, structures, and business concepts, working closely with Data Modelers and Business Stakeholders to define how source data is curated into the One Focus Data Model.
o Perform initial research and discovery, clearly articulating:
§ Core data concepts
§ Entity relationships
§ Critical attributes and their data structure
§ Assumptions, questions, and risks
§ Similarities / differences (and how we account for them) in like-source systems with differing underlying data models / architectures
o Produce and maintain clear, structured documentation capturing findings, relationships, open questions, and concerns related to in-scope data sets
o Partner with Data Modelers to validate, refine, and affirm data relationships and conceptual alignment prior to development
o Support ad hoc research and analysis related to in‑scope data sets as needed after upfront discovery (e.g., data anomalies / blockers, new use cases)
· Source to Target Mapping (STTM) + Business Documentation
o Own the creation and maintenance of Source to Target Mapping (STTM) and supporting baseline documentation, including:
§ Standard source to target mappings
§ Transformation and derivation logic (documented, not implemented)
§ Null handling expectations and edge cases
§ Initial identification of Critical Data Elements (CDEs)
§ Entity level and attribute level descriptions aligned to the curated model
o Act as single point of accountability for documentation quality, completeness, and on-time delivery ahead of development
Explicit Non-Ownership:
· Sprint planning or delivery estimation
· Engineering or development tasks, including:
o Data extraction or ingestion
o Table creation
o Transformation logic implementation (code portion)
o Pipeline development or orchestration
Context Specifics:
· Industry Domain
o Generally, Wealth Management
· Concepts
o Clients, Financial Accounts, Transactions, Billing, Financial Planning, Tax Planning – the confluence of all concepts working together
· Systems:
o CRM (Salesforce)
o Portfolio Accounting & Billing (Industry Niche e.g., Orion, Addepar)
o Financial Planning Tools (eMoney, MoneyGuide Pro)
Never miss an opportunity! Create an alert based on the job you applied for.
