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.