This is a 6 month contract. Aiming at 20 hours a week, but may increase to 40 depending on the workload. Likely to extend.

Project Overview:

The goal of this project is to get our Azure Data Warehouse to a functional baseline with best practices implemented, that we can then use as a template to start implementing quite a few new data sources. Ultimately, these changes should improve our departments development workflow, ideally save on Azure costs, and fix a lot of issues inherent in our current architecture and processes. 

We are currently in the process of re-architecting our Azure Data Warehouse and as a part of that, we need someone to help implement the needed changes. Much of this work involves taking high level direction and then working autonomously to implement the needed changes, while also providing feedback/recommendations on best practices for what you are implementing (ex. Performance, Logging, Security, etc.). Most of this work will be centered around Azure Data Factory, but this person will also need to also be able to work within Azure Databricks, Azure Data Lakes, and Azure SQL Databases.

First few deliverables:

1. Finish implementing needed tables into Azure SQL Database leveraging Data
Factory Data Flows, using the current logic in Azure Databricks notebooks as
your requirements.

2. Start implementing new data sources into Azure SQL Database leveraging Data
Factory Data Flows, using supplied logic/requirements from us but also doing
your own analysis to determine issues or additional requirements that might
come up.

3. Throughout the project’s lifetime, work with the Team to identify places we can
improve, ex. best practices, easier for developers, performance, workflow,
monitoring & auditing, etc.

Why is this an interesting project to work on:

• Problem Solving. This project has problem solving & logic requirements/requests
  that span different Azure resources, which keeps the work diverse & interesting.
• Direct Business Impact. This project directly impacts the business and our
  customers, and this person will play a pivotal role in the success of the project.
  This person will not just be another cog in the wheel.
• Collaborative. This person will get to work closely with a strong Team, where
  everyone is specialized and good at what they do. Certain requests/problems
  end up crossing over between the Team members and the Team must align on
  solutions.

Mandatory Skills:

• Azure Data Factory – Pipelines & Data Flows
• Azure SQL Database
• Azure Data Lake
• Azure Databricks
• Visual Studio

Nice to have:

• Agile Project Management Methodology 

Tools the team uses:

• Azure DevOps – Agile Boards, Git, CI/CD
• Visual Studio | SQL Server Data Tools (ie. SSDT)
• Microsoft SQL Server Management Studio (ie. SSMS)
• Azure SQL Database
• Azure Data Factory (and Data Flows)
• Azure Data Lake
• Azure Databricks
• Microsoft Teams

About you:

• Quick Learner | Can be trained quickly and can self learn by reviewing
  documentation & code.

• Independent | Doesnt need a group to function efficiently & effectively.

• Collaborative | Able to collaborate with other team members to determine
  issues/solutions.

• Flexible | Able to quickly pivot based on business needs.

• Team Player | Easy to work with, and does whats needed for the success of the
  project as a whole.

• Multitasker | Able to easily multitask & manage multiple requests at the same
  time.