Azure Synapse Data Engineer Job at Mastech Digital, Canada

eTdDVFowWVdDbUg5dEVwNWovZklXNU1rZmc9PQ==
  • Mastech Digital
  • Canada

Job Description

Mastech Digital provides digital and mainstream technology staff as well as Digital Transformation Services for all American Corporations. We are currently seeking an  Azure Synapse Data Engineer for our client in the Consulting domain. We value our professionals, providing comprehensive benefits and the opportunity for growth. This is a Contract position, and the client is looking for someone to start immediately.

Duration: 6 Months Contract

Location: Etobicoke, ON, Canada

Salary: $70.00-$85.00/Hourly

Role: Azure Synapse Data Engineer

Primary Skills: MS Azure

Role Description: The Azure Synapse Data Engineer must have 3+ years of experience.

Required Experience and Skills:

- Strong experience of SSAS Tabular Model, DAX queries and query optimization, resolving performance issues, database tuning and data replication techniques with Microsoft SQL Server.

- Strong background with Stored Procedures, Functions, Triggers, Views and Data warehousing (Clear on the concepts of creating Facts, dims etc.)

- Must have strong experience in Azure SQL Database, Azure Data Factory (ADF), Azure Databricks (ADB), Synapse, T-SQL, Azure SQL DWH, ADLS, SparkSQL/PySpark and other Azure services for database, storage, security, and development of BI solutions is required. 

- Familiar with Microsoft Fabric is good to have. 

- Must have experience writing ADB/Synapse notebooks.

- Some knowledge and understanding of Azure functions, Azure Streaming Analytics, Document DB (or Cosmos), MDS (SQL Master Data Service) and Graph DB is required.

- Excellent Business Intelligence, Problem Solving, Analytical, Reporting and/or Visualization skills.

Primary Skills:

- SQL

- ADF

- Azure Synapse

- ADB

Secondary Skills:

- Strong communication skills, able to work directly with the client as an individual contributor.

Education: Any/Bachelor’s degree in Computer Science, Electrical/Electronic Engineering, Information Technology or another related field or Equivalent

Experience: Minimum 3+ years of experience

Relocation: This position will not cover relocation expenses

Travel: No

Local Preferred: Yes

Note: Must be able to work on a W2 basis (No C2C)

Recruiter Name: Sachin Anand

Recruiter Phone: (877) 884-8834 or (412) 226-0751 (Ext: 2267)

Benefits:

We have various coverages and additional benefits to choose from:

- Medical, Dental (Including Ortho) & Vision Insurance (Option to Enroll).

- Paid Leaves (Wherever applicable).

- Life & Disability Coverage (Upon eligibility).

- 401K Option, Education Assistance Program and more.

Mastech Digital is an Equal Opportunity Employer - All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

Job Tags

Hourly pay, Full time, Contract work, Local area, Immediate start, Relocation,

Similar Jobs

Shrine of the Most Blessed Sacrament

Night Shift Safety and Security Guard Job at Shrine of the Most Blessed Sacrament

Full Time Safety & Security Officer - Night ShiftSchedule: 5:30 PM - 5:30 AMJob SummaryThe Safety & Security Officer is responsible for protecting and safeguarding Monastery and Shrine residents, visitors, employees and Shrine assets. This position works both indoors... 

Navy Exchange Service Command

ENTRY LEVEL AUDITOR Job at Navy Exchange Service Command

 ...conformance with NEXCOM and MWR policies and procedures, under the application of professional auditing standards, specifically, Government Auditing Standards. Duties and Responsibilities: - Oversees, coordinates, and participates in performance auditing on assigned... 

City Holder game

Junior/Middle Project Manager (remote) Job at City Holder game

 ...What are you working on? The name of the project(s): CITY Holder At what stage of the project(s)? Advertising campaigns and updates...  ...and structure?10 For which tasks (responsibilities)?~ Management and coordination of work with contractors for creating video... 

LYCEE FRANCAIS DE LA NOUVELLE ORLEANS

High School Science Teacher Job at LYCEE FRANCAIS DE LA NOUVELLE ORLEANS

 ...teach a rich curriculum that nurtures students' natural curiosity about the world. Role and Responsibilities The duties of the teacher may include, but are not limited to the following tasks: Instruction Providing science instruction to students in grades in... 

Harmony Tree

[Make Up Artist] Job at Harmony Tree

As a Makeup Artist, you will have the opportunity to showcase your creativity and expertise in delivering exceptional makeup services to our diverse clientele. Your responsibilities will include:Providing professional makeup application services to clients based on their...