> Markdown version of [/jobs/ext/1677026-azure-data-architect-with-sql-server-experience](https://www.wearedevelopers.com/jobs/ext/1677026-azure-data-architect-with-sql-server-experience). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Azure Data Architect with SQL server Experience - **Company:** EApps Tech LLC - **Location:** Irving, TX, United States - **Salary:** $124,800.0 - $145,600.0 - **Contract:** Permanent contract - **Skills:** Databases, Data Architecture, Data Validation, Data Infrastructure, Extract Transform Load (ETL), Data Migration, File Systems, Apache Hive, Microsoft SQL Server, Cloud Services, Microsoft SharePoint, SQL Stored Procedures, SQL Server Agent, SQL Server Integration Services, Data Streaming, Systems Integration, Transact-SQL, File Transfer Protocol (FTP), Data Ingestion, Azure Data Factory, Apache Spark, Data Lakes, Pyspark, Data Lineage, Data Delivery, Legacy Systems, Alteryx, Databricks - **Published:** July 31, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=3c605da470820458 ## About the Role * Strong data architecture experience across legacy and modern data platforms. * Deep knowledge of SQL Server, T-SQL, stored procedures, SQL Agent jobs, and SSIS. * Experience with ETL modernization and legacy pipeline migration. * Strong experience with Databricks, Spark, PySpark, Spark SQL, Delta Lake, and Lakehouse architecture. * Experience analysing and modernizing batch ingestion pipelines. * Ability to assess undocumented or partially documented legacy systems. * Strong understanding of data lineage, dependency mapping, and downstream impact analysis. * Experience with data migration, cutover planning, rollback planning, and production readiness. * Strong data validation and reconciliation experience. * Ability to work with business stakeholders, SMEs, engineering teams, QA teams, and platform teams. * Preferred Skills * Experience with Alteryx workflows. * Experience with SharePoint-based file processing and SFTP ingestion. * Experience with Azure Databricks, ADLS, ADF, or similar cloud data platforms. * Healthcare, supply chain, distributor, member sales, sourcing, or audit data experience. * Experience defining domain ownership and post-migration support models. ## Description We are looking for a Data Architect / Lead to lead the assessment, discovery, design, and implementation architecture for the Member Sales decommission and modernization initiative. The role will focus on analysing the current SQL Server, SSIS, SQL Agent jobs, stored procedures, Alteryx workflows, SFTP/SharePoint-based feeds, and downstream integrations, then defining a modern target-state architecture using Databricks., * Lead current-state assessment of Member Sales database assets, including tables, stored procedures, SSIS packages, SQL Agent jobs, ETL job plans, and downstream dependencies. Inventory and analyse existing ingestion and transformation pipelines. * Assess current acute and non-acute distribution data flows. * Analyse monthly SFTP to SharePoint to Alteryx processing used for PRS reporting. Review acute distribution ETL workflows loading into Member Sales and downstream EDB tables. * Define target-state architecture for modernizing existing pipelines and destination platform using Databricks. * Design migration approach for repointing existing pipelines to a new landing environment. Identify domain areas and recommend ownership model for transition to domain owners after the modernization work. * Define source-to-target mappings, data lineage, integration dependencies, and migration sequencing. * Ensure downstream continuity for PRS reporting, Provista line-item data delivery, sourcing, and auditing use cases. * Define data validation and parity strategy covering completeness, timing, reconciliation, and output comparison. * Create high-level and low-level architecture/design documentation. * Support effort estimation, delivery planning, assumptions, dependencies, risks, and SOW inputs. * Provide technical oversight during implementation and ensure alignment with enterprise architecture standards. ## Related Videos - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Related Articles - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Why Event-Driven Architecture Isn’t About Speed (and When You Actually Need It)](https://www.wearedevelopers.com/magazine/745-why-event-driven-architecture-isn-t-about-speed-and-when-you-actually-need-it) - [Navigating the AI Shift](https://www.wearedevelopers.com/magazine/629-navigating-the-ai-shift) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)