Job Details

Position Summary:

Title: Azure Data Architect/Engineer
Duration: 12 Months - Long Term
Location: Washington, DC 20433

Hybrid Onsite: 4 Days onsite per week from Day1.

The intend of this work is to guide the design and development of the data ingestion process into Azure Databricks environment, creating data services to the .Net application for business.

Scope Of Work:
Client is looking for Azure Data Architect person to perform the following scope of work:

• Design, develop and maintain core data architectural constructs with a special focus on elements of Azure Data Factory, Azure Data Lake and Azure Databricks platforms.

• Bachelor's or master's degree in computer science, Computer Engineering or Information Systems.
• Minimum 10-15+ years in Data Warehousing, Data Engineering & Analytics Experience.
• Minimum 8+ years of Cloud data architecture with at least 4 + years on Azure.
• 5-7 yrs experience in Data with one large program from end to end
• Proven experience as a Data Architect designing and implementing new data solutions in Microsoft Azure platform.
• A minimum of 5 years of experience designing and developing data solutions in both Azure and Databricks.
• Hands-on experience in Azure Data Factory, Azure Synapse, Azure Databricks, Azure SQL Database, Azure Functions, and Logic Apps.
• High proficiency in developing complex ETL Data Pipelines using Databricks with PySpark, manage & maintain Data Lake & Lakehouse (CDC & SCD).
• Excellent understanding of data warehousing concepts and technologies (e.g., dimensional modeling, star schema, data vault, medallion architecture, etc.).
• Experience with designing and developing data solutions using technologies such as Databricks, Snowflake, Dremio, Spark, Hadoop or Kafka.
• Strong proficiency in SQL and experience with relational databases (e.g., Oracle, PostgreSQL, SQL Server).
• Expert knowledge of ETL/ELT tools and frameworks, batch, real-time and near real-time loads.
• Expertise in programming languages such as Python and Spark.
• Familiarity with designing data products for consumption by .Net applications, APIs or analytical solutions, such as Power BI.
• Proven ability to leverage components like Azure Automation, Azure Power Shell Scripting, AZ Copy, Azure DevOps, ARM Templates.
• Ability to visualize and create high-level models (rigorous information-rich diagrams).
• Experience in Unity Catalog is preferred.
• Experience integration with Power BI and defining the approach for data self-service. Proven experience with Power BI, including Semantic Model development and DAX.