Location: Vienna, VA—Hybrid—1 day a week onsite needed. Description: + Provide technical architecture guidance and expertise in developing, architecting, and maintaining Azure Synapse Analytics end to end solution, Azure Databricks, spark pool, and monitoring of high-volume of complex data warehouse and analytical processes. + Experience in designing and architecting end to end Analytics solution in Synapse. + Experience in designing and architecting Change data capture frameworks. + Demonstrable experience in designing and orchestrating data pipelines to load data efficiently in Synapse dedicated SQL Pool. + Experience in Azure Data Lake, Azure Data Factory, Azure data flow, Azure functions and Databricks. + Create data pipeline designs, source to target mappings, and data models. + Knowledge of data engineering requirements and design practices including fact qualifier matrices, dimensional modeling, business questions + Investigate data quality, perform data profiling, and understand the meaning of complex operational data. + Strong relationship and communication skills to collaborate and document end-users needs. + Work directly with our end users to apply data and analytics to business challenges. + Experience in architecting solutions to optimize dedicated SQL pools in Azure Synapse Analytics using different data distribution methods, partitioning, and query optimization. + Experience in architecting consumption patterns like Analytical, Operational, Real-time, and bulk consumption patterns. + Experience in optimization of data ingestion, curation, Synapse analytics, analyzing large data sets, and Knowledge of Performance/cost optimization techniques + Experience in large scale warehouse migration from on-prem to cloud. + PowerBI architect experience is preferred. Relevant certification is a plus.