Data Solution Architect (experienced) - New York, NY

This position requires the successful candidate to work on a W2 directly with FDM. We cannot accept C2C, 1099 or employment sponsorship (e.g. H1-B) for this position.

FDM is a global business and technology consultancy delivering client and industry driven solutions through our 5 core specialist Practices; Software Engineering, Data & Analytics, IT Operations, Change & Transformation, and Risk, Regulation & Compliance.

FDM is seeking a Data Solution Architect located in New York, NY to support a project. Involvement in this project is anticipated to last initially 12 months but may be extended.

This role will be hybrid with requirements to be in office 3 days per week.

This role is critical to building the firm’s enterprise data model and delivering business-ready data to bankers and senior stakeholders. The Data Solution Architect will engage directly with business teams to capture workflows, define data domains, and translate requirements into logical models. Working closely with data engineers and business analysts, the DSA will ensure data is mastered, trusted, and consumable in downstream systems including Databricks, Salesforce, and DealCloud.

This is a high-visibility, hands-on role ideal for individuals who combine strong business engagement skills with technical fluency in data modeling, SQL, Python, and modern analytics platforms.

Primary Responsibilities

• Partner with bankers, operational leaders, and senior stakeholders to capture workflows, entities, and data requirements.
• Design and maintain logical and semantic data models aligned to the firm’s enterprise architecture.
• Define attributes, hierarchies, and business rules for core domains (e.g., funds, sponsors, deals, coverage).
• Explore and validate datasets in SQL, Python, and Databricks, shaping raw data into business-ready domain tables.
• Collaborate with data engineers on ingestion, transformations, and enrichment of data for business consumption.
• Prototype transformations and pipelines in Python/Databricks, then hand off to Engineers implement in production.
• Present domain models and outputs to stakeholders, gather feedback, and iterate to ensure alignment.
• Serve as a trusted bridge between business stakeholders and technical teams, ensuring that models are both accurate and usable.

• 5-7 years of experience in data architecture, solution design, or hybrid business/data roles within financial services or consulting.
• Strong proficiency in:
  • SQL (querying, joining, validating relational datasets).
  • Python (data wrangling, prototyping, APIs, Pyspark).
  • Databricks or equivalent data platforms.
• Deep understanding of data modeling, semantics, ontologies, and master data management (MDM).
• Familiarity with data integration patterns (ETL/ELT, APIs, third-party data sources).
• Strong communication skills, with proven ability to translate complex data concepts for business and technical audiences.
• Highly organized, proactive, and able to balance big-picture design with hands-on prototyping.

About FDM  

FDM is an award-winning global business and technology consultancy powering the people behind tech and innovation for over 30 years. We collaborate with world-leading companies to identify the expertise they need, exactly when they need it. We have helped successfully launch nearly 25,000 careers globally to date and are a trusted partner to over 300 companies worldwide. 

FDM has 2500+ employees worldwide, with over 80 nationalities working together as a team. From our origins in Brighton, UK, FDM now has 19 centers located across North America, Europe and Asia-Pacific and is now on the FTSE4Good Index. 

Dedicated to Diversity, Equity and Inclusion  

FDM Group’s mission is to make tech and business careers accessible for everyone. Our diverse team of 80+ nationalities thrive on differences, fuels innovation through varied experiences, and celebrates shared successes. As an Equal Opportunity Employer that is listed on the FTSE4Good Index, FDM ensures every qualified applicant, regardless of race, color, religion, sex, sexual orientation, national origin, age, disability or any other status protected by federal or provincial law, gets the chance they deserve. 

FDM Group, Inc. is registered to operate and hire employees in select states within the US. We will consider employment applications exclusively from candidates who are either residing in one of the following states or willing to relocate to them: Arizona, California, Colorado, Delaware, Florida, Georgia, Illinois, Indiana, Massachusetts, Maryland, Maine, Minnesota, North Carolina, New Jersey, New York, Pennsylvania, Tennessee, Texas, Utah, and Virginia.