Design and build ETL/ELT pipelines, canonical client/account data models, and revenue attribution logic for equities and adjacent products. Resolve entity and reconciliation issues across CRM, OMS/EMS, and finance systems, partnering with Front Office, Finance, Compliance, and Operations to ensure governance and accurate management reporting.
The Senior Data Engineer will play a pivotal role in architecting and implementing data solutions for Cantor Fitzgerald's Technology Markets division. This role demands a deep understanding of financial services data, particularly in Equities Trading and Broker-Dealer Operations, to drive data-driven decision-making and operational efficiency. The successful candidate will collaborate closely with CRM product owners and front-office stakeholders to translate complex business workflows into robust data structures, ensuring accurate revenue tracking and attribution across coverage teams and products.
Responsibilities
- Architect and build ETL/ELT pipelines for CRM data migration, cleansing, and normalization, resolving entity conflicts across legacy systems.
- Define canonical data models for client hierarchies, account structures, and relationship ownership, ensuring consistency across business lines.
- Address entity resolution challenges, including duplicate client records and mismatched account IDs, for accurate data representation.
- Translate business workflows into data structures that reflect actual coverage team operations, collaborating closely with front-office stakeholders.
- Design and maintain revenue tracking data models, including trading commissions, advisory fees, and relationship-attributed P&L, ensuring accurate attribution.
- Build attribution logic to allocate revenue across coverage teams, products, client accounts, and booking entities, considering commission sharing and soft dollar arrangements.
- Ensure accurate reconciliation between front-office OMS/EMS data, finance ledgers, and CRM-reported metrics for management reporting.
- Standardize client master data across Equities and adjacent product lines, applying consistent hierarchy models and industry-standard identifiers.
- Partner with Compliance, Operations, and Front Office to maintain data governance standards and support downstream reporting and compliance.
- Deep understanding of financial services data, particularly in Equities Trading, Broker-Dealer Operations, or Client/Account Management.
- Familiarity with trade lifecycle data, order management, execution, settlement, and data flow into downstream reporting and P&L systems.
- Working knowledge of client and account hierarchy models, legal entity structures, account types, and sub-accounts, and their mapping to coverage and revenue attribution.
- Understanding of sell-side revenue tracking and attribution, including commissions, advisory fees, and reconciliation challenges between front-office and finance systems.
- Familiarity with counterparty and client identifier standards, such as LEI, DTCC, and FIX protocol client IDs.
- 5-8 years of hands-on data engineering experience, with at least 3 years in financial services, and expertise in Python, Java, and SQL.
- Direct experience with Salesforce CRM, including data model, APIs, and integration patterns, and proven experience with data normalization and entity resolution.
- Comfortable working directly with stakeholders across Front Office, Finance, Compliance, and Operations, and able to drive independent deliverables in a fast-paced environment.
- Preferred: Hands-on experience with AI/ML tools for data workflow automation and self-service analytics, and exposure to Cloud data platforms and industry data standards.
- Experience with Fixed Income, Prime Brokerage, or multi-asset CRM data, and orchestration/transformation tools like dbt or Airflow, is an advantage.
Cantor Fitzgerald New York, New York, USA Office
499 Park Avenue, New York, NY, United States, 10022
Similar Jobs
Edtech • Information Technology • Software
Lead ownership of Pluralsight's Search backend: build and maintain scalable, reliable ingestion and query systems, design and analyze experiments, consume and produce platform data, collaborate cross-functionally, and participate in on-call rotation to resolve alerts and improve the system.
Top Skills:
AlgoliaElasticsearchKafkaNode.jsPostgresPythonTypescript
Consumer Web • eCommerce • Internet of Things
Build and maintain production SDKs (TypeScript, Python, Go) and integrations for AI agent frameworks and edge runtimes. Implement DNSid identity flows, cryptographic key lifecycle, middleware/plugins, testing and CI pipelines, package releases, and reference apps. Collaborate with Developer Advocates and technical writers while contributing upstream to third-party frameworks and shaping protocol specifications.
Top Skills:
A2ACertificate ChainsCi/CdCloudflare WorkersCrewaiDnsDns Operator ApisDnssecEd25519Es256Fastly ComputeGitGoGo Module ProxyGo ModulesHttp/1.1Http/2Jwk SetsJwtLangchainLanggraphLlamaindexMcpMicrosoft Agent FrameworkMtlsNpmOauth 2.0OidcOpenai Agents SdkPypiPythonSemantic VersioningSpiffe/SpireTlsTypescriptVercel EdgeWebassemblyWebid
Artificial Intelligence • Cloud • Security • Software • Cybersecurity
Build, maintain, and improve local and remote coding agent sandboxing solutions to secure SDLC workflows. Drive technical roadmap, implement safeguards and integrity mechanisms, integrate security with platform and DevOps teams, mentor junior engineers, participate in incident response, and ensure pragmatic user-focused security for production environments.
Top Skills:
AWSAzureGCPGoJavaScriptKubernetesLinux LandlockMacos SeatbeltPythonRust
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
