Azure Data Warehouse Developer

Azure Data Warehouse Developer

 

  • JOB TYPE: Freelance, Contract Position (no agencies/C2C - see notes below)
  • LOCATION: Remote- North America - PST/CIST | Partial overlap
  • HOURLY RANGE: Our client is looking to pay $35-$40 /hr
  • ESTIMATED DURATION: 20h/week - Long term
  • EXPERIENCE: 3-5 years
  • BRAINTRUST JOB ID: 8399

 

THE OPPORTUNITY

Requirements

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.

What you’ll be working on

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.

Apply Now!

Logos/outerjoin logo full

Outer Join is the premier job board for remote jobs in data science, analytics, and engineering.