Sr. Azure ETL Developer - Hybrid

Title: Sr. Azure ETL Developer - Hybrid

Location: Richmond, VA, United States

Length: Long term

Restriction: W2 or C2C

Description:

***Long term***Hybrid*** 3 days per week onsite

Descripton:

VDOT is looking for a Senior Azure ETL developer to ingest transform and load Data Assets and implementation of a cloud based data management platform that will support the agency.

This role is expected to take a Sr Developer role within the team, to extract business data and load it into a data warehousing environment. Design and test the performance of the system. Consult with various teams to understand the companys data storage needs and develop data warehousing options. Well versed in warehousing architecture techniques such as MOLAP, ROLAP, ODS, DM, and EDW.

Qualifications:

Experience in designing, building, and deploying scalable Azure cloud based data solutions.

Hands on experience with Azure services such as Azure Data Factory, Azure Databricks, Azure Data Lake Storage, Azure SQL, Azure Synapse, and other data sources.

Hands on experience in SQL Server (SSIS, SSRS, SSAS), ORACLE, T SQL, Azure SQL Database, Azure SQL Datawarehouse

Hands on experience in deploying and maintaining large scale data processing pipelines.

Experience in data analysis and provide cloud based technical solutions.

Experience working on both on prem and cloud based data solutions.

Experience in querying and analyzing small and large data sets to discover patterns and deliver meaningful insights.

Work with data architects, data engineers, business analysts, and business teams to provide Azure data driven solutions.

Well versed with Agile practices.

Familiarity with C# and .Net is a huge plus.

Required Skills:

Experience in designing, building, and deploying scalable Azure cloud based data solutions.10Years

Hands on experience with Azure services such as Azure Data Factory, Azure Databricks, Azure Data Lake Storage, Azure SQL, Azure Synapse5Years

Hands on experience in SQL Server (SSIS, SSRS, SSAS), ORACLE, T SQL10Years

Hands on experience in Azure SQL Database, Azure SQL Datawarehouse7Years

Hands on experience in deploying and maintaining large scale data processing pipelines.10Years

Hands on scripting experience with Windows and or Python, Linux Shell scripting. 10 Years

Highly Desired Skills:

Experience in Azure DevOps, or Continuous Integration Delivery 7 Years

Nice to have:

Knowledge of C# and .Net 3 Years