Data Solution Architect

HSO; New York (NY); On-site; USD 141,741 - 191,767; Full time

Benefits offered by this job

Unlimited PTO

Medical, dental & vision coverage

Flexible spending accounts

401(k) with company match

Job summary

HSO is seeking a Data Architect to design, govern, and implement modern data architectures supporting analytics, AI, and business transformation. You will define data models, integration patterns, and governance standards while collaborating with Data Engineers, Consultants, and client stakeholders.

Expect to lead workshops, guide data engineering teams, and ensure architectural alignment. Strong Azure data services expertise and cross-functional communication are required.

Qualifications

• Bachelor’s degree in Computer Science.
• 5+ years of experience designing and implementing enterprise data architectures.
• Strong proficiency with Azure data services (Synapse, ADF, Fabric, Databricks, ADLS, Azure SQL).
• Deep understanding of data modeling methodologies (Kimball, Inmon, Data Vault).
• Experience implementing governance frameworks, including metadata, lineage, quality, and security.
• Proficiency in SQL and familiarity with Python or Scala.
• Experience delivering data modernization, cloud migration, or analytics platform projects.
• Strong communication skills and ability to work cross-functionally with engineering and business teams.

Responsibilities

• Design scalable, cloud-based data architectures using Microsoft data services.
• Define enterprise-ready data models, data flows, integration patterns, governance frameworks, and development standards.
• Lead discovery and design workshops with client stakeholders to translate business requirements into technical data solutions.
• Oversee and guide data engineering teams during the build phase to ensure alignment with architectural standards.
• Establish and maintain metadata, lineage, data quality, and governance processes leveraging Microsoft Purview or similar tools.
• Conduct architectural reviews, performance tuning, and optimization of data systems.
• Communicate design decisions, risks, tradeoffs, and solution approaches clearly to both technical and non-technical audiences.
• Stay current with emerging data technologies, architectural patterns, and Microsoft cloud advancements.

Skills

Enterprise data architecture

Azure data services

Data modeling (Kimball, Inmon, Data Va

Governance & metadata

SQL

Python or Scala

Cross-functional comms

Education

Bachelor’s degree in Computer Science

Job description

As a Data Architect at HSO, you will design, govern, and implement modern data architectures that empower our clients to leverage their data for analytics, reporting, AI, and business transformation. You will define data models, integration patterns, governance standards, and architectural best practices while collaborating closely with Data Engineers, Consultants, and client technical and business stakeholders.

As a Data Architect you can expect to…

• Design scalable, secure, cloud-based data architectures using Azure Data Lake, Azure SQL, Synapse, Fabric, Databricks, and related Microsoft data services.
• Define enterprise-ready data models, data flows, integration patterns, governance frameworks, and development standards.
• Lead discovery and design workshops with client stakeholders to translate business requirements into technical data solutions.
• Oversee and guide data engineering teams during the build phase to ensure alignment with architectural standards.
• Establish and maintain metadata, lineage, data quality, and governance processes leveraging Microsoft Purview or similar tools.
• Conduct architectural reviews, performance tuning, and optimization of data systems.
• Communicate design decisions, risks, tradeoffs, and solution approaches clearly to both technical and non-technical audiences.
• Stay current with emerging data technologies, architectural patterns, and Microsoft cloud advancements.

You're great at...

• Structuring complex data challenges into clear, scalable architectural approaches.
• Explaining technical concepts simply and effectively to business stakeholders.
• Designing with both long-term scalability and real-world delivery constraints in mind.
• Bringing order to ambiguity — defining frameworks, standards, and processes where none exist.
• Collaborating with cross-functional teams and guiding technical contributors.
• Identifying inefficiencies and recommending strategic improvements.
• Balancing innovation with practicality in solution design.
• Seeing both the “big picture” and the technical details that make it possible.

Requirements

• Bachelor’s degree in Computer Science
• 5+ years of experience designing and implementing enterprise data architectures.
• Strong proficiency with Azure data services (Synapse, ADF, Fabric, Databricks, ADLS, Azure SQL, etc.).
• Deep understanding of data modeling methodologies (Kimball, Inmon, Data Vault).
• Experience implementing governance frameworks, including metadata, lineage, quality, and security.
• Proficiency in SQL and familiarity with Python or Scala.
• Experience delivering data modernization, cloud migration, or analytics platform projects.
• Strong communication skills and ability to work cross-functionally with engineering and business teams.

Benefits

We offer competitive pay with and performance-based bonus. Our employees also enjoy unlimited paid time off and a flexible and affordable benefits program designed to help you be and stay well, including: medical, dental & vision coverage, flexible spending accounts, health reimbursement account, and a 401(k) plan with a company match. Additionally, you’ll have the benefit of working alongside enthusiastic and energetic teammates in a dynamic and thriving environment. HSO is an Equal Opportunity Employer.

Salary: $166,754/yr.