Data Solution Architect

Remote, US
Data & AI
Full-Time

Role introduction

 

As a Senior Data Architect you can expect to...

  • Architect, lead, and deliver complex data modernization initiatives leveraging Azure Synapse, Microsoft Fabric, Azure Data Lake, Databricks, and related Azure services.
  • Drive on-premises to Azure migration strategies, modernizing legacy data warehouses into scalable lakehouse and Delta Lake architectures.
  • Design and implement enterprise data integration frameworks across Dynamics 365 F&O, Dynamics 365 CE, Salesforce, SAP, Workday, and third-party platforms using Azure-native services and Data API Gateways.
  • Build, optimize, and maintain advanced data pipelines in Azure Synapse and Azure Data Factory (ADF), supporting both full and incremental data loads from cloud and on-premises environments.
  • Establish scalable, cost-efficient, and high-performing data architectures by driving performance optimization and platform best practices across Databricks and Synapse environments.
  • Implement enterprise-grade data platform capabilities including Delta Lake features such as CDC, schema evolution, and slowly changing dimensions (SCDs).
  • Apply modern governance, security, and observability frameworks using Azure Purview, Key Vault, and Data Mesh principles to ensure trusted and compliant data solutions.
  • Lead the design and implementation of reusable CI/CD frameworks using Azure DevOps, GitHub, ARM templates, and PowerShell automation.
  • Partner with cross-functional Microsoft service line teams, including Power Platform, Dynamics 365, Azure Infrastructure, and Modern Work, to deliver integrated client solutions.
  • Serve as a trusted advisor by contributing to client roadmaps, strategy discussions, proposals, steering committee meetings, and executive communications while ensuring customer satisfaction and delivery excellence.

You’re great at...

  • Leading complex on-premises to Azure data transformation journeys across large enterprise environments.
  • Designing modern data platforms using lakehouse, Data Mesh, microservices, and cloud-native architectural patterns.
  • Building near real-time ingestion and processing solutions using technologies such as Kafka, Event Hubs, or similar platforms.
  • Integrating Azure AI and machine learning services to enhance analytics and intelligent decision-making capabilities.
  • Developing and managing automated deployment and CI/CD pipelines using Azure DevOps, GitHub Actions, ARM/Bicep, and PowerShell.
  • Communicating complex technical concepts effectively to executives, business stakeholders, and technical teams.
  • Mentoring data engineers, guiding solution architecture decisions, and ensuring delivery quality across multi-team engagements.
  • Ensuring data quality, integrity, governance, and security throughout the data lifecycle.
  • Thriving in a collaborative environment while solving complex challenges with creativity, adaptability, and a commitment to continuous learning.

Sound interesting? If so, you’ll have...

  • A bachelor’s degree in Computer Science, Information Technology, or a related field.
  • 10+ years of experience in data architecture, ETL, data warehousing, and cloud transformation initiatives.
  • Deep expertise with Azure Synapse, Databricks, Spark, Azure Data Factory (ADF), Azure Data Lake Storage (ADLS), Azure Functions, Python, and SQL/T-SQL.
  • Proven experience optimizing cloud platform cost, performance, scalability, and operational efficiency.
  • Strong knowledge of Data Mesh, Delta Lake, Azure Purview, and modern data governance and observability frameworks.
  • Hands-on experience building scalable real-time ingestion, data processing frameworks, and enterprise data platforms.
  • Strong understanding of Common Data Model (CDM), Dataverse, Power BI Dataflows, and integrations with Dynamics 365 and other enterprise applications.
  • Experience with Azure Key Vault, Logic Apps, runbooks, DevOps pipelines, PowerShell scripting, ARM templates, Git, and CI/CD automation.
  • Demonstrated success leading client-facing architecture discussions, technical solution delivery, and enterprise transformation programs.
  • Strong analytical, problem-solving, communication, collaboration, and business process analysis skills, with the ability to guide clients through complex challenges.

The Perks

We offer competitive pay with a 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.

Apply now!

Fill out the form below, include your resume and we will get in touch with you shortly.

U.S. Standard Demographic Questions

We invite applicants to share their demographic background. If you choose to complete this survey, your responses may be used to identify areas of improvement in our hiring process.

optional

LARGE ENOUGH TO SERVE, SMALL ENOUGH TO CARE

Why work at HSO?

At HSO we take pride in being large enough to serve, but small enough to care. We are uniquely positioned to empower you to transform your career without compromising your life and we take pride in investing as much in our people as we do in our clients.

  • 1

    Collaborative

    At HSO we enjoy a culture of collaboration and support and a collaborative hybrid working model where we team flexibly with purpose at the heart of our working arrangements. We use teamwork not just to meet challenges, but to also promote one another’s success.

  • 2

    Ever-Evolving

    We believe strongly in our values of always learning, always evolving and not standing still. HSO is dedicated to the ongoing professional development of people starting with the training and certification of our early career starters through to supporting senior experienced professionals.

  • 3

    Value Driven

    Our values and culture are attractive to people who want to work with value-driven teams around the world. Collaborating with colleagues and clients who are experts in their field provides an exceptional opportunity in your career to be continuously upskilling and expanding your knowledge and talent for accelerated learning and career progression.

  • 4

    Entrepreneurial

    At HSO we transform the way in which people work and how businesses operate to get results for our clients. This takes exceptional cutting-edge technology, knowledge, talent, determination and entrepreneurial spirit. Our culture and values support entrepreneurial mindsets and attitudes where your voice will always be heard.