Data Integration Engineer

Responsibilities

• Build, maintain, and improve integrations between Canoe and enterprise platforms, including Addepar, Snowflake, reporting tools, portfolio systems, accounting systems, data warehouses, and other vendor applications.
• Support document ingestion, classification, extraction, validation, exception management, and downstream delivery of alternative investment data.
• Analyze, troubleshoot, and resolve data issues involving capital calls, distributions, capital account statements, NAVs, commitments, contributions, withdrawals, valuations, K-1s, fund metadata, investor entities, and related alternative investment documents.
• Support, maintain, and enhance Canoe‑related data workflows across alternative investments, investment operations, portfolio management, client reporting, performance analytics, and financial reporting.
• Develop and maintain data pipelines, SQL queries, reconciliation logic, data validation scripts, exception reports, and operational monitoring routines.
• Partner with investment operations, reporting, portfolio management, accounting, compliance, and technology teams to translate business requirements into data requirements, mappings, validation rules, and integration specifications.
• Support secure and controlled data movement from Canoe into Snowflake and other enterprise data platforms.
• Contribute to data modeling, data transformation, and consumption‑layer design for alternative investment data used in reporting, analytics, portfolio review, and client service workflows.
• Use APIs, file‑based integrations, ETL/ELT tools, automation scripts, and platform configuration to improve the reliability and scalability of Canoe‑related workflows.
• Monitor production data feeds, identify exceptions, perform root‑cause analysis, coordinate remediation, and coordinate issue escalation to vendors or internal teams as appropriate.
• Validate data quality, completeness, timeliness, and consistency across Canoe, Addepar, Snowflake, reporting tools, and other downstream systems.
• Participate in platform enhancements, regression testing, user acceptance testing, release planning, production deployments, and change‑management activities.
• Maintain documentation for data flows, source‑to‑target mappings, business rules, control points, reconciliation procedures, support runbooks, and platform operating procedures.
• Identify opportunities to automate manual processes, reduce recurring exceptions, improve document‑processing accuracy, and strengthen operational controls.
• Ensure Canoe‑related data processes align with Brown Advisory’s standards for security, privacy, auditability, operational resilience, and financial services regulatory expectations.
• Collaborate with architects, data engineers, analysts, platform owners, vendors, and business stakeholders to improve the reliability, usability, and scalability of the alternative investment data environment.

• Bachelor’s degree in Information Systems, Information Technology, Computer Science, Finance, Accounting, Business Analytics, Data Analytics, or a related field.
• 5+ years of experience in data engineering, data analysis, platform integration, investment operations technology, financial systems support, or enterprise data operations.
• Experience with Canoe or comparable alternative investment document automation, data extraction, data management, or investment operations platforms.
• Strong understanding of alternative investment workflows, including capital calls, distributions, statements, valuations, commitments, contributions, withdrawals, fund metadata, investor entities, and client reporting requirements.
• Experience supporting data integrations, data pipelines, data feeds, file‑based transfers, API‑based integrations, or vendor platform connectivity.
• Intermediate to advanced SQL skills, including querying, joins, aggregations, data profiling, exception identification, validation, and reconciliation.
• Experience analyzing and resolving data quality issues across investment, accounting, reporting, portfolio, transaction, position, and reference datasets.
• Familiarity with wealth or asset management workflows, including portfolio management, investment operations, client reporting, performance reporting, alternative investments, and financial reporting.
• Experience translating business requirements into technical specifications, data mappings, validation rules, reconciliation procedures, and operating documentation.
• Strong analytical, problem‑solving, documentation, communication, and stakeholder‑management skills.
• Ability to work effectively in a fast‑paced environment with multiple priorities, production deadlines, and high expectations for data accuracy and reliability.
• Ability to work in Brown Advisory’s Baltimore office three days per week.