Match score not available

Unlock Premium Benefits Today!
🚀 Elevate your career with priority access.
Stand out to top recruiters with Jobgether Priority Access:
  • ✅ Top Match: We help you identify job offers where you're a perfect fit.
  • ✅ Exclusive Referral Service: Connect directly with recruiters as a Jobgether Certified Premium User.
  • ✅ Personalized Feedback: Receive feedback and expert guidance on applications, and have your profile manually reviewed.

Start Your Free Trial Now!

Start my free trial

Azure Synapse Technical Lead

Remote: 
Full Remote
Contract: 
Fixed term
Work from: 
India

Offer summary

Qualifications:

8-10 years of experience in Data Warehouse development, with 3-5 years in Azure Synapse or SQL Data Warehouse., Hands-on ETL coding experience in at least 2 projects, focusing on Azure Synapse., Proficiency in relational and big data technologies such as SQL Server and Spark Pool., Strong communication skills with the ability to interact with business teams..

Key responsabilities:

  • Oversee the entire lifecycle of a data mart, including requirement analysis and pipeline development.
  • Design and develop pipelines from scratch and enhance existing Synapse pipelines for performance.
  • Set up dependencies between job processes to ensure system integrity and develop ETL/ELT load processes.
  • Create data mapping documentation and evaluate the quality of data in the data warehouse.

Optimum Data Analytics logo
Optimum Data Analytics
See all jobs

Job description

Position: Azure Synapse Technical Lead (Sr. Hands-On Developer)
Experience: 8-10 years
Work Mode: Remote
Notice Period: Immediate

Job Description:
Responsible for overseeing the entire lifecycle of a data mart, including data
requirement analysis, design, and development of Azure Synapse pipelines, as well
as setting up workflows and dependency flows.
Job Responsibilities:
• Design and develop pipelines from scratch based on existing requirements;
analyze existing report queries and database procedures/functions in SQL
Server.
• Enhance and optimize existing Synapse pipelines for performance and high
data quality.
• Set up dependencies between external and internal job processes to ensure
end-to-end system integrity.
• Develop and customize Synapse pipelines according to end-user
requirements.
• Develop ETL/ELT load processes:
Analyze source system data structures and fields.
Extract data from source systems using big data technologies (Spark
Pool).
• Create data mapping documentation, including transformation rules, default
values, and selection criteria.
• Implement, program, and configure transformation rules, as well as
structure/field/value mapping.
Evaluate the quality of data in the data warehouse/Data Mart.
• Manage source code control, Pull Requests and Code Reviews
Required Qualifications:
• 8 to 10 years of experience in Data Warehouse development, including at
least 3-5 years in Azure Synapse, SQL Data Warehouse, or Dedicated SQL
Pool.
• Hands-on ETL coding experience in at least 2 projects as a Team Member or
Team Lead, focusing on ETL coding using Azure Synapse, SQL Data

Warehouse, or Dedicated SQL Pool.
• Experience in designing and developing Synapse Pipelines for STAR
Schemas (Type 1, Type 2, Role-Playing Dimensions, Facts) in at least 2
projects.
• Proficiency in working with relational and big data technologies such as SQL
Server, Oracle, SQL Pool, and Spark Pool.
• Strong ability to communicate with business teams using business language.
• Knowledge of Project Management Methodologies and principles.
• Experience with billing and revenue management systems is a plus.
• Experience with Azure DevOps.

Required profile

Experience

Spoken language(s):
English
Check out the description to know which languages are mandatory.

Hard Skills

Azure Synapse AnalyticsData Warehouse SystemsETL (Extract Transform Load)Oracle CRMData Warehouse SystemsProject ManagementMicrosoft SQL Server Data Engine (MSDE)Revenue ManagementBillingAzure DevOps

Other Skills

  • Communication
Are you interested?

Related jobs

See more jobs