Data Solution Architect

HSO

• $125K — $150K *
US-AnywhereRemote in United States
Information Technology
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Computer Science, Information Technology, or related field.
  • 10+ years of experience in data architecture, ETL, data warehousing, and cloud transformation initiatives.
  • Deep expertise with Azure Synapse, Databricks, Spark, and Azure Data Factory (ADF).
  • Proven experience optimizing cloud platform cost, performance, and operational efficiency.
  • Strong knowledge of Data Mesh, Delta Lake, and modern data governance frameworks.
  • Experience in building scalable real-time data processing frameworks.
  • Strong analytical, problem-solving, and communication skills.

Responsibilities

  • Architect and deliver complex data modernization initiatives leveraging Azure technologies.
  • Drive migration strategies from on-premises to Azure, modernizing legacy data warehouses.
  • Design and implement enterprise data integration frameworks across multiple platforms.
  • Build and maintain advanced data pipelines in Azure Synapse and ADF.
  • Establish scalable, high-performing data architectures through optimization best practices.
  • Implement enterprise-grade data platform capabilities using Delta Lake features.
  • Lead the design of CI/CD frameworks using Azure DevOps and PowerShell.

Benefits

  • Unlimited paid time off for work-life balance.
  • Flexible and affordable benefits program including medical, dental, and vision coverage.
  • 401(k) plan with company match to support retirement planning.
  • Collaborative and dynamic work environment with enthusiastic teammates.
Full Job Description
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.

Similar Jobs

More Jobs at HSO

More Information Technology Jobs

Find similar Data Solution Architect jobs: