Data Solution Architect

* 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.