Lead Azure Data Engineer

We need some Lead Azure Data Engineer with Strong SQL, Python, Pyspark, Azure Data Bricks, Azure Synapse

Job Description:

As an Azure Data Engineer, you will be expected to design, implement, and manage data solutions on the Microsoft Azure cloud platform. The ideal candidate will have a proven track record of writing complex SQL stored procedures with implementing OTLP database solutions (using Microsoft SQL Server)

Key Responsibilities:

• Collaborate with cross-functional teams to gather, analyze, and document business requirements for data integration projects.
• Develop and maintain robust data pipelines using Azure Data Factory and Databricks ensuring seamless data flow between systems.
• Expertise in Native SQL, Dynamic SQL, spark SQL, Azure SQL and ability to write complex stored procedures.
• Design and implement complex stored procedures to support data transformation and Implement business validation logic.
• Strong algorithmic programming skills
• Work closely with the team to ensure data quality, integrity, and accuracy across all systems.
• Utilize Databricks for advanced data processing and analysis.
• Experience on OLTP (Online Transaction Processing) systems using SQL Server and contribute to their enhancement and optimization.

Qualifications:

• Bachelor’s degree in computer science, Information Technology, or a related field.
• [Specify the number of years] years of experience in data integration and database development.
• Proficiency in Core SQL and Azure SQL.
• Extensive experience with Azure Data Factory and Databricks.
• Strong expertise in designing and implementing complex stored procedures.

Excellent problem-solving skills and attention to detail.

Job Types: Full-time, Contract

Benefits:

• 401(k)
• Dental insurance
• Health insurance

Experience:

• SQL: 10 years (Preferred)
• Azure Data Bricks: 5 years (Preferred)
• Azure Data Factory: 5 years (Preferred)
• Python: 5 years (Preferred)
• PySpark: 5 years (Preferred)
• Azure Synapse: 5 years (Preferred)
• OLTP: 5 years (Preferred)

Ability to Commute:

• Seattle, WA 98101 (Required)

Work Location: In person