Senior Consultant Azure Synapse

| Remote
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

3Cloud is a technology services firm helping clients transform their business through the power of the cloud. We leverage Microsoft Azure to help clients speed up innovation, operate more efficiently and be more responsive to their client’s needs. As a Microsoft partner, we specialize in Azure migration, cloud-scale custom application development, Internet of Things (IoT), analytics, and managed development (DevOps) achieved through Azure-enabled infrastructure automation. 3Cloud is headquartered in Chicago with an additional office in Dallas. Remote based, US only. 

As a consultant in the Data and Analytics Practice you will be responsible for delivering quality solutions using the Microsoft’s Azure suite of tools, focusing specifically on the Synapse ecosystem. This is a senior position with extensive experience in data engineering and development, focused on database technologies, with specific experience with Azure Synapse. You will use your experience creating and optimizing star schema models in a dedicated SQL pool on Synapse to create effective structures to ingest data for analysis. You will also work with Table Distribution and Index types and understand partitioning strategies to update large tables. You will also use PolicyBase and Azure Data Factory to help ingest data. Your experience with Synapse Dynamic Management Views will help you to monitor and manage Azure Synapse Analytics. If you are an individual who is highly interested in Azure and Databricks technologies, you may be just who we are looking for to join our team.

Responsibilities

  • Understand Azure Synapse Analytics architecture
  • Be able to identify performance bottlenecks
  • Monitor Azure Synapse Analytics using Dynamic Management Views
  • Build performing data with Table Distribution and Index types
  • Partition tables using partitioning strategy
  • Creating and optimizing star schema models in a Dedicated SQL Pool
  • Configure and manage workload classification and resource classes
  • Build ingestion pipelines with PolyBase and ADF to load and export data (best practices)

Qualifications

  • Bachelor’s Degree desired in Computer Science, Information Technology, or related field
  • Minimum of 5 years of experience with database design, at least 2 years with Azure technologies, and previous Consulting experience
  • Advanced knowledge of SQL, including ability to write stored procedures, triggers, analytic functions, and tuning
  • Knowledge of relational and dimensional database structures, theories, principles, and practice
  • Expertise in working with Synapse and related technologies

Professional Skills:

  • Eagerness to contribute in a team-oriented environment
  • Desire to work in an information systems environment
  • Excellent communication (written and oral) and interpersonal skills for both technical and non-technical teams
  • Passionate about learning new technologies
  • Analytical approach to problem-solving; ability to use technology to solve business problems
  • Ability to work in a fast-paced environment

Additional Preferred Experience:

  • Predictive, Prescription, and Descriptive Analytics using Data Science tools and technologies including Azure ML Studio/Services, R programming language
  • Other Azure development expertise including Azure Databricks, Python, Scala, R
  • Other Azure technologies including storage (DataLake, DeltaLake, Blob Storage)
  • Knowledge of relational and dimensional database structures, theories, principles, and practice
  • Certifications are a plus
Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
    • .NETLanguages
    • C#Languages
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • SqlLanguages
    • Microsoft AzureLanguages

An Insider's view of 3Cloud

How would you describe the company’s work-life balance?

3Cloud has an excellent work-life balance. With the unlimited work from home policy, I have the ability to save myself time from a rather long, tedious commute and utilize that time to get more work done with higher quality. In addition to that, being closer to home allows me to spend more time with family, focus on things such as fitness, etc.

Sully

Associate Azure Consultant

What does your typical day look like?

My days are never the same - I juggle time, cost and quality to ensure all clients’ goals are met. Having exposure to open collaboration between teams that work with diverse technologies enables new growth opportunities. One thing stays consistent every day, though - I get to work on challenging projects with brilliant people.

Martyna

Senior Project Manager

How has your career grown since starting at the company?

I joined 3Cloud as a senior consultant. With the rapid pace at which 3Cloud has grown, the leaders recognized my leadership contributions and fast-tracked my career advancement to Delivery Director of our Cloud Infrastructure & Operations team. I lead seven seasoned architects that drive market leading Azure solutions for our clients.

Joe

Delivery Director

What is your vision for the company?

Our vision is to be the leading Microsoft Azure partner, both trusted by our clients and loved by our employees.

Mike

CEO

What are 3Cloud Perks + Benefits

3Cloud Benefits Overview

We believe our biggest perk is that we get to work with great clients on cutting-edge projects; our team members are challenged and develop amazing skills as they create. Our full benefits package targets life balance and connection.

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Dental Benefits
Health Insurance Benefits
Life Insurance
Onsite Gym
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Remote Work Program
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Company Outings
Stocked Kitchen
Some Meals Provided
Happy Hours
Parking
Professional Development Benefits
Job Training & Conferences
Lunch and learns
Cross functional training encouraged
Promote from within
Mentorship program
Time allotted for learning
Online course subscriptions available
Customized development tracks
Paid industry certifications
More Jobs at 3Cloud36 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
HR + Recruiting
Operations
Project Mgmt
Sales
Operations
new
Atlanta, GA
Developer
new
Chicago, IL
Developer
new
Chicago, IL
Developer
new
Remote
Finance
new
Remote
Data + Analytics
new
Remote
Project Mgmt
new
Remote
Developer
new
Remote
Developer
new
Chicago, IL
Developer
new
Chicago, IL
Developer
new
Chicago, IL
Developer
new
Remote
Data + Analytics
new
Chicago, IL
Project Mgmt
new
Remote
HR + Recruiting
new
Chicago, IL
Operations
new
Chicago, IL
Developer
new
Remote
Project Mgmt
new
Remote
Data + Analytics
new
Remote
Developer
new
Remote
Data + Analytics
new
Chicago, IL
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView 3Cloud's full profileSee more 3Cloud jobs