Data Solution Architect

Senior Data Solution Architect

REMOTE (preference would be Toronto, NYC, Boston, or Charlotte, but ANY qualified candidate will do!)

Direct Hire (not a contract) - MUST be authorized to work in the US without sponsorship (USC or GC).

More about our client and their need:

About Us

We are a consulting and technology advisory firm specializing in helping financial services organizations navigate transformation across data, digital, and client-focused capabilities. Our teams work across major financial hubs and support a wide range of institutions seeking to modernize their technology and operating models.

We offer an environment that blends the stability of an established firm with the innovative mindset of a growing organization. Our culture emphasizes collaboration, professional development, and high-impact work.

Why Join Us?

Balanced stability and entrepreneurial energy
We provide the structure of a mature consultancy while encouraging creativity, autonomy, and new ideas.

Strong investment in growth
We are backed by long-term investors who support our expansion, innovation initiatives, and new service offerings.

Exposure to leadership
You’ll collaborate directly with senior leaders across the firm and have the opportunity to influence key decisions.

Professional development focus
From structured training programs to hands-on learning and mentorship, we prioritize continuous development and offer paid training time each year.

Performance-driven culture
Career advancement is based on merit, impact, and capability. Your work will have visible, tangible influence internally and for clients.

About Our Technology Services Group

Our technology services practice focuses on supporting financial institutions with the design and implementation of modern data and digital platforms. We help clients improve operational efficiency, unlock value from data, and deploy solutions that support strategic business goals.

Our team works across a broad range of financial services areas and partners closely with clients on system integration, data architecture, and large-scale transformation initiatives.

Role Overview

In this role, you will:

• Work with senior stakeholders to analyze challenges across sales, service, marketing, product, and client experience domains.
• Design solution architectures that support future-state business and technology objectives.
• Recommend and integrate platforms such as CRM, CLM, CDP, CMS, marketing automation, and sales enablement tools.
• Oversee implementation of technology platforms and end-to-end solution design.
• Contribute to internal frameworks, methodologies, and technical accelerators.
• Stay current with market-leading technologies and assess vendor strengths and limitations.
• Mentor and guide junior team members.
• Collaborate with specialists in business architecture, data strategy, and technology design.

Role Requirements

• 8–10 years of hands-on experience as a data engineer or data architect.
• Strong experience with the Microsoft Fabric Data Platform , including data models, pipelines, and data architecture.
• Knowledge of medallion data architecture and implementation of data quality checks.
• Experience with data modeling techniques including star schema and snowflake models.
• Understanding of financial services products, client segments, and operating models.
• Ability to lead executive-level discussions, workshops, and governance forums.
• Strong SQL proficiency and experience with cloud data platforms such as Snowflake, Databricks, and AWS.
• Familiarity with investment-related data (positions, transactions, security data, ABOR/IBOR) is beneficial.
• Experience integrating cloud-based architecture (Azure, AWS, Snowflake).
• Strong problem-solving skills, attention to detail, and communication abilities.
• Comfortable working in dynamic, fast-paced transformation environments.
• Willingness to travel based on client needs.

Compensation & Benefits

• Competitive salary with discretionary performance-based bonus.
• 25 days of paid time off per year.
• 401(k) matching program.
• Support for professional certifications and training, including paid study days.
• Choice of laptop.
• Medical, dental, and vision benefits.
• Teamwide training programs and company-sponsored retreats.