Data Solution Architect

A leading global financial services firm is seeking an Experienced Data Solution Architect to join its Data Architecture & Modeling team in New York, NY. This role sits at the center of enterprise data strategy and offers high visibility across senior leadership, bankers, and cross-functional technical teams.

Details:

• 6-month contract (Extension Highly Likely)
• Compensation: $80 - $100 p/hour
• NYC, NY | Hybrid | 3 Days On-Site

Responsibilities:

• Partner with senior stakeholders to capture workflows, define data domains, and map business requirements.
• Design logical and semantic data models that align with enterprise data architecture.
• Define key attributes, hierarchies, and rules for core datasets (funds, sponsors, coverage, deals, etc.).
• Explore, validate, and shape raw data using SQL, Python, and Databricks.
• Collaborate with data engineers on ingestion, transformations, and enrichment.
• Prototype transformations and pipelines before handing off to engineering for production builds.
• Present models, gather feedback, and iterate to ensure accuracy and alignment.
• Serve as a bridge between business partners and technical teams.

Mandatory Requirements:

• 6 years of experience in data architecture, solution design, or hybrid business/data roles.
• 5 years of experience in SQL, Python, PySpark
• 3 years of experience with Databricks
• Understands data modeling, semantics, ontologies, and MDM best practices.
• Knows how to translate complex data concepts into actionable design for both technical and non-technical audiences.
• Is highly organized, proactive, and comfortable balancing strategic design with hands-on prototyping.

If interested, please send me your resume, and upon review I will give you a call.

Cheers!

Amy

Oscar Associates Limited (US) is acting as an Employment Agency in relation to this vacancy.