Job Title: Canoe Data / Integration Engineer
Location: Remote - Open to Travel
Duration: Long Term
Position Summary:
Canoe Data / Integration Engineer to support and scale the firm’s alternative investment data ecosystem. This role is responsible for technical enablement, data integration, data quality, automation, and production support of Canoe/ Addepar related workflows within the firm.
The role will work at the intersection of technology, investment operations, portfolio management, client reporting, enterprise data, and vendor platforms.
Required Qualifications:
• Bachelor’s degree in Information Systems, Information Technology, Computer Science, Finance, Accounting, Business Analytics, Data Analytics, or a related field.
• 9+ years of experience in data engineering, data analysis, platform integration, investment operations technology, financial systems support, or enterprise data operations.
• Experience with Canoe/dynamo/Addepar 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.
Desired Qualifications:
• Direct hands-on experience with Canoe, including document collection workflows, extraction review, validation queues, exception management, data delivery, and platform support.
• Experience integrating Canoe with Addepar, Snowflake, Databricks, enterprise data warehouses, BI/reporting tools, CRM platforms, accounting systems, client portals, or portfolio management platforms.
• Experience using APIs, webhooks, ETL/ELT tools, orchestration platforms, secure file transfers, and automation scripts to support platform integrations.
• Experience with Snowflake, including data ingestion, transformation, modeling, access controls, data sharing, quality checks, and consumption-layer design.
• Experience with Python, dbt, Airflow, Azure Data Factory, AWS Glue, Fivetran, Matillion, or comparable data engineering tools.