Job summary:


Title:
Azure Data Lead/Architect - Onsite

Location:
Cheshire, CT, USA

Length and terms:
Long term - W2 or C2C


Position created on 12/02/2025 09:47 pm

Job description:


**** Webcam interview;  *** Long term project *** Onsite ****

Job Description:

About the Job:

  • We are seeking a highly skilled Azure Data & BI Engineer with expertise in Azure Data Factory (ADF) and Azure Synapse Analytics to join our dynamic team within our organization.
  • This role involves integrating seamlessly with Internal Development Platforms (IDP) and other tools to enhance the developers experience on Azure.
  • The ideal candidate will have a strong background in data integration, ETL processes, and data warehousing.
  • This role involves designing, developing, and maintaining data solutions that support our business intelligence and analytics initiatives.

Responsibilities

  • Design & Develop the ETL
  • Good experience in writing SQL, and PySpark programming.
  • Create the Pipelines (simple and complex) using ADF.
  • Work with other Azure stack modules like Azure Data Lakes, SQL DW
  • Must be extremely well versed with large volumes of data.
  • Understand the business requirements for Data flow process needs.
  • Understand requirements, functionality, and technical specifications of documents.
  • Development of mapping documents and transformation business rules as per scope and requirements/Source to target.
  • Responsible for continuous formal and informal communication on project status
  • Good understanding of JIRA stories process for SQL development activities

Requirements

  • Experience: 12+ years
  • Must have domain expertise in Property and Casualty (P&C) insurance, with a solid understanding of industry-specific data, workflows, and business processes.
  • 10 years of Experience in developing data ingestion, data processing and analytical pipelines for big data, relational databases, and data warehouse solutions.
  • Extensive hands-on experience implementing data migration and data processing using Azure services: ADLS, Azure Data Factory, Azure Functions, Synapse, Azure SQL DB, etc.
  • Experience in Data Sets, Data Frame, Azure Blob & Storage Explorer
  • Proficient in Power BIwith hands-on experience in SQL performance tuningfor optimized data retrieval and reporting.
  • Demonstrated expertise in functional data validation, ensuring data accuracy and integrity across business processes.
  • Well versed in DevOps and CI/CD deployments.
  • Have a good understanding of Agile/Scrum methodologies.
  • Strong attention to detail in high-pressure situations.
  • Experience in the insurance (e.g., UW, Claim, Policy Issuance) or financial industry preferred
  • Excellent problem-solving skills and the ability to troubleshoot complex issues in distributed systems.
  • Effective communication and collaboration skills, with the ability to effectively interact with stakeholders at all levels.

Skills:

  • Azure services: ADLS, Azure Data Factory, Azure Functions, Synapse, Azure SQL DB, etc
  • Must have domain expertise in Property and Casualty (P&C) insurance

Contact the recruiter working on this position:



The recruiter working on this position is Fazal(Shaji Team) Uddin
His/her contact number is +(1) (703) 4684697
His/her contact email is fazal@msysinc.com

Our recruiters will be more than happy to help you to get this contract.