Azure Data Fabric Architect

ValueMomentum; Missouri; Remote; USD 120,000 - 150,000; Full time

Job summary

A leading solutions provider in the insurance industry is seeking a Data Solution Architect. The ideal candidate will have extensive knowledge of Microsoft data services and significant experience in designing and maintaining cloud-based data pipelines. Responsibilities include creating ETL/ELT processes and ensuring data quality for advanced analytics solutions. Candidates should possess deep expertise with Azure technologies and demonstrate a strong background in data engineering and architecture, particularly in relation to data warehousing and cloud solutions.

Qualifications

• 15+ years of experience in data engineering and design.
• 4+ years in designing data warehouse and analytics solutions.
• Familiarity with data quality management and privacy/security.

Responsibilities

• Design ETL/ELT pipelines for data integration.
• Automate and maintain ETL/ELT processes.
• Conduct testing for ETL/ELT solutions.

Skills

Microsoft Azure services

ETL/ELT processes

Data warehouse design

Python

Scala

CI/CD practices

Tools

Azure Data Factory

Databricks

SSIS

Spark

Azure DevOps

Job description

Data Solution Architect

The ideal candidate will have a deep understanding of Microsoft data services, including Azure Fabric, Azure Data Factory (ADF), Azure Synapse, and ETL/ELT processes. This role focuses on designing, developing, and maintaining cloud-based data pipelines and solutions to drive our analytics and business intelligence capabilities.

• Design and map ETL/ELT pipelines for new or modified data streams, ensuring integration into on-prem or cloud-based data storage.
• Automate, validate and maintain ETL/ELT processes using technologies such as Databricks, ADF, SSIS, Spark, Python, and Scala.
• Proactively identify design, scope, or development issues and provide recommendations for improvement.
• Conduct unit, system, and integration testing for ETL/ELT solutions, ensuring defects are resolved.
• 15+ years of experience in data engineering and architecture, with a strong focus on data warehouse design and optimization.
• 4+ years of experience in designing and implementing data warehouse and analytics solutions (on-premise and cloud).
• 3+ years of expertise in data warehousing concepts (ETL/ELT, data quality management, privacy/security, MDM) with hands‑on experience using ADF, Data Factory, SSIS, and related tools.
• 3+ years of experience with cloud data and cloud-native data lakes/warehouses. Microsoft Azure services (Fabric Lakehouse, ADF, Data Factory, Synapse, etc.).
• 2+ years of experience in Python, Scala, or Java for use with distributed processing and analytics, such as Spark.
• Familiarity with CI/CD practices and tools such as Azure DevOps, Git, or Jenkins.

About ValueMomentum

ValueMomentum is a leading solutions provider for the global property & casualty insurance industry, supported by deep domain and technology capabilities. We offer a comprehensive suite of advisory, development, implementation, and maintenance services across the entire P&C insurance value chain. This includes Underwriting, Claims, Distribution, and more, empowering insurers to stay ahead with sustained growth, high performance, and enhanced stakeholder value. Trusted by over 75 insurers, ValueMomentum is one of the largest standalone insurance-focused solutions providers to the US insurance industry.