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.
Our client, a very well known university, is seeking two Event Coordinators to assist them with an event in Chicago, Illinois on April 1, 2025! April 1st, 4:00 PM-9:00PM Lake Forest, Illinois Dress Code: Professional black pants, white shirt or black dress for ...
...Job Title: Business Analyst / Consultant (Insurtech / Insurance ) $150k-$180k plus potential equity and incentives Location: Austin, Texas Job Type: Full-time ________________________________________ NB: Please read the job requirements and send CV ****@*****.***...
...customer service skills, enjoy planning dream getaways, and want to work from anywhere with flexible hours, this could be the perfect... ...experience stress-free, unforgettable vacations What You'll Do: Consult with clients to understand their travel preferences, budget, and...
We are looking for 3 CT Technologists for our client facility in Philadelphia, PA. Pay range is $68-72.80 per hour Hours are M-F 0800 - 1630 ASAP Start Temporary contract for 12-weeks Travel package also available at $3100 per week on 40-hours. What you...
...Job Summary: Our client is seeking a Information Security Specialist to join their team! This position is located in Tempe, Arizona. Duties: Perform internal reviews to validate items identified in discovery Identify any gaps with and assist with remediation...