Lead Integration Engineer with Canoe experience

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. We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, citizenship status, age, disability, genetic information, protected veteran status, or any other characteristic protected by applicable law. https://www.e-verify.gov/sites/default/files/everify/posters/IER_RighttoWorkPoster.pdf