Senior Data Engineer

Job Title: Senior Data Engineer – Trading & Client /CRM DomainsLocation: NYCFirm Overview:Cantor Fitzgerald L.P., with over 16,000 employees, has been a leading global financial services firm at the forefront of financial and technological innovation since 1945. Cantor Fitzgerald & Co. is a preeminent investment bank serving more than 5,000 institutional clients around the world, recognized for its strengths in fixed income and equity capital markets, investment banking, SPAC underwriting, PIPE placements, commercial real estate, and for its global distribution platform. Capitalizing on the firm’s financial acumen and technology prowess, Cantor’s portfolio of businesses also includes Prime Brokerage, Asset Management, and other businesses and ventures. For 79 years, Cantor has consistently fueled the growth of original ideas, pioneered new markets, and provided superior service to clients. Cantor operates trading desks in every major financial center globally, with offices in over 30 locations around the world. As one of the few remaining private partnerships on Wall Street, Cantor has the distinct ability to focus on long-term value creation and solid relationship building. Our structure allows us to respond quickly to client needs, develop solutions that address complex challenges, avoid the limitations of bureaucracy, and attract talented individuals who are driven to succeed. About the RoleWe are seeking a Senior Data Engineer with deep domain expertise in financial services data — spanning Trading, Sales, Broker-Dealer operations, and Client/Account management — to join a high-impact initiative at the intersection of data engineering and capital markets.The near-term focus is a firm-wide CRM replacement and rationalization program, where you will lead hands-on engineering work across client data migration, revenue attribution modeling, and integration between front-office systems and the new CRM platform (Salesforce). As the program matures, the role will expand to broader data platforms across trading and client domains.This is a role for someone who understands how capital markets businesses work — not just how to move data between systems. You should be as comfortable discussing commission structures, account hierarchies, and trade lifecycle as you are writing production Python or designing a dbt model. Key ResponsibilitiesCRM Data Engineering & MigrationArchitect and build ETL/ELT pipelines to migrate, cleanse, and normalize client and account data into Salesforce, resolving entity conflicts across fragmented legacy source systemsDefine and enforce canonical data models for client hierarchies, account structures, and relationship ownership across business linesResolve entity resolution challenges: duplicate client records, mismatched account IDs, and inconsistent counterparty identifiers across source systemsCollaborate with CRM product owners and front-office stakeholders to translate business workflows into data structures that reflect how coverage teams actually operateRevenue Data & AttributionDesign and maintain revenue tracking data models spanning trading commissions, advisory fees, and relationship-attributed P&LBuild attribution logic to correctly allocate revenue across coverage teams, products, client accounts, and booking entities — including commission sharing, soft dollar, and CSA arrangements where applicableEnsure accurate reconciliation between front-office OMS/EMS data, finance ledgers, and CRM-reported metricsSupport management reporting datasets for coverage leadership and senior managementClient & Account Data NormalizationStandardize client master data across Equities and adjacent product lines, applying consistent hierarchy models from legal entity through account and sub-account levelsApply industry-standard identifier frameworks (LEI, DTCC counterparty IDs, FIX protocol client identifiers) to support downstream reporting, compliance, and cross-system reconciliationPartner with Compliance, Operations, and Front Office to ensure data governance standards are met and maintainedOngoing Data Platform Work (expanding scope beyond CRM)Develop, test, and deploy production-grade pipelines in Python, Java, and SQL, with transformation layers built on modern frameworks (dbt preferred)Build and maintain reusable, well-documented data models that can support multiple downstream consumers across the firmInstrument data quality checks, lineage tracking, and alerting across the data stackSupport integration with visualization and reporting tools used by business stakeholders (Tableau, Power BI, or equivalent)Qualifications:Domain Knowledge (weighted heavily)Deep understanding of financial services data in one or more of the following: Equities Trading, Broker-Dealer Operations, Institutional Sales, or Client/Account ManagementFamiliarity with trade lifecycle data — order management, execution, settlement, and how that data flows from OMS/EMS into downstream reporting and P&L systemsWorking knowledge of client and account hierarchy models as used in institutional markets: legal entity structures, account types, sub-accounts, and how they map to coverage and revenue attributionUnderstanding of how sell-side revenue is tracked and attributed — commissions, advisory fees, and related structures — and the reconciliation challenges that arise between front-office and finance systemsFamiliarity with counterparty and client identifier standards: LEI, DTCC, FIX protocol client IDs, or similarTechnical Skills5–8 years of hands-on data engineering experience, with at least 3 years in financial servicesExpert proficiency in Python, Java, and SQL; ability to write production-quality, well-tested codeDirect experience with Salesforce CRM — data model, APIs, and integration patternsProven experience with data normalization, entity resolution, and master data management at scaleComfortable working directly with stakeholders across Front Office, Finance, Compliance, and OperationsAbility to drive deliverables independently in a fast-paced, project-driven environmentPreferred QualificationsHands-on experience applying AI/ML tools to automate data workflows and deliver self-service analytics and dashboards to non-technical stakeholdersExperience with Fixed Income, Prime Brokerage, or multi-asset CRM dataExperience with orchestration/transformation tools (dbt, Airflow, or similar)Exposure to Cloud data platforms (AWS, Azure, or GCP)Knowledge of industry data standards such as LEI, DTCC counterparty IDs, or FIX protocol client identifiersExperience with Salesforce Financial Services Cloud (FSC) or other capital markets CRM configurationsEducational Qualifications:Bachelor’s Degree required Salary: $180,000 - $210,000The actual base salary will be determined on an individualized basis considering a wide range of factors including, but not limited to, relevant skills, experience, education, and, where applicable, licenses or certifications held. In addition to base salary and a competitive benefits package (including health, vision, and dental insurance, paid time off and a 401(k) retirement), this position may be eligible for additional types of compensation including discretionary bonuses and other short- and long-term incentives (e.g., deferred cash, equity, etc.).We do not accept unsolicited resumes, candidate referrals, or outreach from third-party recruiters or staffing agencies. Any such submissions will be considered property of Cantor Fitzgerald and will not be eligible for any placement fee. Recruiters must have a signed agreement with our Talent Acquisition team and be invited to submit candidates for a specific role. Direct contact with hiring managers or employees is strictly prohibited.