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 questionsInvestigate 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 techniquesExperience in large scale warehouse migration from on-prem to cloud.PowerBI architect experience is preferred. Relevant certification is a plus.