Source description
About the role
Extract, cleanse, deduplicate, and migrate client data from a wide range of source systems — including relational databases (MySQL, PostgreSQL, SQL Server, Oracle) and CRMs (Salesforce, HubSpot, Microsoft Dynamics) — into our target platforms (Azure or Salesforce).
Design and execute data transformation pipelines that map source data to our proprietary schema, applying business rules, normalization logic, and quality validation.
Implement and manage InvestorFlow's productized integrations, coordinating with clients and internal teams to ensure smooth, on-time deployments.
Own and maintain custom integrations built on Talend, including monitoring, troubleshooting, optimization, and documentation.
Evaluate integration requirements and recommend the right tooling — Talend, MuleSoft, Dell Boomi, or otherwise — based on complexity and client needs.
Contribute to Snowflake-based transformation workloads, optimizing queries and data flows for performance and efficiency.
Build reusable ETL templates and frameworks to accelerate future migration and integration engagements.
Collaborate with Professional Services, Engineering, and client teams to gather requirements and deliver accurate, timely results.
Where applicable, lead or mentor junior data engineers, providing technical direction and reviewing deliverables.
Stay current on emerging tools and trends in data integration, ETL, and cloud platforms.
More at InvestorFlow