Senior Addepar Data Engineer / Analyst

Skills

• Data Engineering
• Data Analysis
• Investment Operations Technology
• Financial Systems Support
• Platform Analytics
• Enterprise Data Operations
• Addepar Platform
• Snowflake
• Canoe
• Python
• dbt
• Elasticsearch
• ETL/ELT Tools
• APIs
• File-Based Integrations
• Automation Scripts
• SQL
• Data Profiling
• Data Reconciliation
• Data Validation
• Exception Management
• Portfolio Accounting
• Performance Measurement
• Client Reporting
• Asset Classification
• Account Hierarchy
• Investment Data Governance
• Agile Delivery
• Requirements Analysis
• User Acceptance Testing
• Change Management
• Technical Documentation
• Investment Operations
• Reporting
• Compliance
• Data Governance
• Data Quality
• Data Lineage
• Audit Controls
• Operational Resilience
• Vendor Management

Responsibilities

• Serve as a senior technical and analytical resource for Brown Advisory’s Addepar data ecosystem.
• Support, enhance, and scale Addepar workflows across portfolio management, client reporting, investment operations, performance analytics, and advisory processes.
• Analyze, troubleshoot, and resolve complex data issues involving accounts, entities, ownership structures, portfolios, holdings, transactions, securities, classifications, attributes, benchmarks, performance, and reporting outputs.
• Build, maintain, and improve data pipelines between Addepar and enterprise platforms, including Snowflake, reporting tools, client platforms, portfolio systems, accounting systems, Canoe, and other vendor applications.
• Develop SQL queries, reconciliation logic, exception reports, data profiling routines, and automated data quality controls.
• Partner with business and technology stakeholders to translate portfolio management, client reporting, operations, and analytics needs into data requirements, technical specifications, and scalable delivery solutions.
• Support ingestion, transformation, normalization, and validation of portfolio, client, account, security, transaction, performance, benchmark, alternative investment, and reference data.
• Contribute to Snowflake-centered data architecture by supporting secure data ingestion, modeling, quality checks, consumption-layer design, and integration with analytics and reporting platforms.
• Collaborate with investment operations and reporting teams to validate performance, exposure, allocation, classification, and client reporting data.
• Support production data operations, including data-feed monitoring, exception management, issue triage, root-cause analysis, release validation, vendor escalation, and post-incident remediation.
• Identify opportunities to automate manual workflows, reduce recurring data exceptions, improve data quality, and strengthen operational controls.
• Maintain clear documentation for data flows, mappings, business rules, reconciliation procedures, platform processes, and production support runbooks.
• Participate in platform enhancements, regression testing, user acceptance testing, release planning, and change-management activities.
• Ensure Addepar-related data processes align with Brown Advisory’s standards for security, privacy, auditability, operational resilience, and financial services regulatory expectations.
• Partner with architects, engineers, platform owners, business analysts, vendors, and data governance stakeholders to continuously improve the reliability, scalability, and usability of the Addepar data environment.

Qualifications

• Bachelor’s degree in Information Systems, Information Technology, Computer Science, Finance, Accounting, Business Analytics, Data Analytics, or a related field.
• 5+ years of hands-on experience with the Addepar platform in a wealth management, asset management, family office, investment advisory, or financial services environment.
• 5+ years of experience in data engineering, data analysis, investment operations technology, financial systems support, platform analytics, or enterprise data operations.
• Strong understanding of the Addepar data model, including accounts, entities, ownership structures, portfolios, holdings, transactions, securities, classifications, attributes, benchmarks, performance, and reporting views.
• Experience supporting Addepar data imports, exports, data feeds, integrations, reconciliation processes, and platform configuration.
• Intermediate to advanced SQL skills, including joins, aggregations, data profiling, exception identification, reconciliation, and large-dataset analysis.
• Experience diagnosing and resolving data quality issues across portfolio, account, transaction, position, security master, performance, and reporting datasets.
• Strong understanding of wealth or asset management workflows, including portfolio management, investment operations, client reporting, performance reporting, alternative investments, and financial reporting.
• Experience translating business requirements into data requirements, technical specifications, data mappings, validation rules, and operating procedures.
• Strong analytical, problem-solving, communication, documentation, and stakeholder-management skills.
• Ability to operate effectively in a fast-paced environment with multiple priorities, production deadlines, and high expectations for accuracy, reliability, and responsiveness.
• Ability to work in Brown Advisory’s Baltimore office three days per week.